---
title: "#excel-sheets articles | Hashnode"
description: "Explore 161 articles tagged #excel-sheets on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/excel-sheets"
---

Tag

# #excel-sheets

161 posts · 32 followers

[Alex Taylor](https://hashnode.com/@Allr) · [Jan 14](https://hashnode.com/posts/create-dynamic-excel-reports-with-python-conditional-formatting/69670616b9d686a1adca1e57)

### [Create Dynamic Excel Reports with Python Conditional Formatting](https://allr.hashnode.dev/create-dynamic-excel-reports-with-python-conditional-formatting?utm_source=hashnode&utm_medium=feed)

Manual conditional formatting in large Excel datasets can be a tedious, repetitive, and error-prone task. Imagine sifting through thousands of rows, manually applying rules to highlight critical data points, identify trends, or flag anomalies. This p...

8 min read · [allr.hashnode.dev](https://allr.hashnode.dev/create-dynamic-excel-reports-with-python-conditional-formatting?utm_source=hashnode&utm_medium=feed)

[a](https://hashnode.com/@Ariannaaa) · [Dec 15, 2025](https://hashnode.com/posts/data-analyst-vs-business-analyst-key-differences-you-should-know/693fc047831bab0df658fbaa)

### [Data Analyst vs Business Analyst: Key Differences You Should Know](https://online-trainner.hashnode.dev/data-analyst-vs-business-analyst-key-differences-you-should-know?utm_source=hashnode&utm_medium=feed)

Introduction: Two Careers, One Common Question Many professionals want a career in analytics, but they often ask one key question. Should they choose a Data Analyst role or a Business Analyst role? Both careers offer strong demand, high pay, and long...

7 min read · [online-trainner.hashnode.dev](https://online-trainner.hashnode.dev/data-analyst-vs-business-analyst-key-differences-you-should-know?utm_source=hashnode&utm_medium=feed)

[Victoria Quattrociocchi](https://hashnode.com/@VictoriaQuattrociocchi) · [Oct 17, 2025](https://hashnode.com/posts/dirty-data/68f2a304875c2ef66e080519)

### [Dirty data](https://victoriaquattrociocchi.hashnode.dev/dirty-data?utm_source=hashnode&utm_medium=feed)

Qué son los Datos sucios? Los datos sucios incluyen datos duplicados, desactualizados, incompletos, incorrectos/inexactos y datos incoherentes. Cada tipo de datos sucios puede tener un impacto significativo en el análisis, dando lugar a una visión im...

5 min read · [victoriaquattrociocchi.hashnode.dev](https://victoriaquattrociocchi.hashnode.dev/dirty-data?utm_source=hashnode&utm_medium=feed)

[Dipti M](https://hashnode.com/@diptim) · [Sep 11, 2025](https://hashnode.com/posts/mastering-advanced-excel-a-complete-guide-for-professionals/68c245ada4b3892d37831d5d)

### [Mastering Advanced Excel: A Complete Guide for Professionals](https://diptim.hashnode.dev/mastering-advanced-excel-a-complete-guide-for-professionals?utm_source=hashnode&utm_medium=feed)

Microsoft Excel has long been the go-to tool for data analysis, reporting, and decision-making across industries.

5 min read · [diptim.hashnode.dev](https://diptim.hashnode.dev/mastering-advanced-excel-a-complete-guide-for-professionals?utm_source=hashnode&utm_medium=feed)

[Tech Concept Hub](https://hashnode.com/@tchseo) · [Aug 31, 2025](https://hashnode.com/posts/excel-vs-power-bi-why-companies-prefer-one-over-the-other/68b3e51424755cae9f9ff2b9)

### [Excel vs Power BI: Why Companies Prefer One Over the Other](https://techconcepthub.hashnode.dev/excel-vs-power-bi-why-companies-prefer-one-over-the-other?utm_source=hashnode&utm_medium=feed)

Explore why companies transition from Excel to Power BI for enhanced scalability, integration, and collaboration in data analysis

1 min read · [techconcepthub.hashnode.dev](https://techconcepthub.hashnode.dev/excel-vs-power-bi-why-companies-prefer-one-over-the-other?utm_source=hashnode&utm_medium=feed)

[Mohammed Junaid](https://hashnode.com/@junaid04) · [Aug 26, 2025](https://hashnode.com/posts/week-7/68adcaa2f51ca9be95821710)

### [Week 7](https://journey-towards-business-analyst.hashnode.dev/week-7?utm_source=hashnode&utm_medium=feed)

Since I’m unemployed, I had a lot of time to focus on lots of things which we’ll go through one by one. 💡 Attaching worked files for reference → Click Here 20/08/2025 Focusing on the top formulas used in Excel. If you’re wondering where am I gett...

12 min read · [journey-towards-business-analyst.hashnode.dev](https://journey-towards-business-analyst.hashnode.dev/week-7?utm_source=hashnode&utm_medium=feed)

[Monika Khatnani](https://hashnode.com/@MonikaK03) · [Aug 18, 2025](https://hashnode.com/posts/master-in-financial-modelling-course/68a36f8c492ec827fe79de9b)

### [Master In Financial Modelling Course](https://online-financial-modeling-courses.hashnode.dev/master-in-financial-modelling-course?utm_source=hashnode&utm_medium=feed)

Understanding Financial Modelling Financial modelling is the art of creating a detailed representation of a company’s financial situation using spreadsheets and analytical tools. It involves projecting future revenues, expenses, and profitability to ...

2 min read · [online-financial-modeling-courses.hashnode.dev](https://online-financial-modeling-courses.hashnode.dev/master-in-financial-modelling-course?utm_source=hashnode&utm_medium=feed)

[Monika Khatnani](https://hashnode.com/@MonikaK03) · [Aug 18, 2025](https://hashnode.com/posts/future-proof-your-career-with-financial-modelling/68a3685ef8e16e1737d9c54f)

### [Future-Proof Your Career with Financial Modelling](https://online-financial-modeling-courses.hashnode.dev/future-proof-your-career-with-financial-modelling?utm_source=hashnode&utm_medium=feed)

Understanding Financial Modelling Financial modelling is the backbone of business and investment analysis. By creating structured financial spreadsheets, professionals can forecast outcomes, evaluate risks, and test business strategies. These models ...

1 min read · [online-financial-modeling-courses.hashnode.dev](https://online-financial-modeling-courses.hashnode.dev/future-proof-your-career-with-financial-modelling?utm_source=hashnode&utm_medium=feed)

[Iheanacho Emmanuel](https://hashnode.com/@Emmychi) · [Jun 19, 2025](https://hashnode.com/posts/mastering-pivot-tables-for-business-reporting/6854034809e731dc6aff4c58)

### [Mastering Pivot Tables for Business Reporting](https://emmalytica.hashnode.dev/mastering-pivot-tables-for-business-reporting?utm_source=hashnode&utm_medium=feed)

Mastering Pivot Tables for Business Reporting Pivot tables are among the most powerful tools in spreadsheet software like Microsoft Excel and Google Sheets. They are not just data summarizers; they are essential instruments in the business analyst's ...

6 min read · [emmalytica.hashnode.dev](https://emmalytica.hashnode.dev/mastering-pivot-tables-for-business-reporting?utm_source=hashnode&utm_medium=feed)

[Casie Liu](https://hashnode.com/@Casie) · [Apr 23, 2025](https://hashnode.com/posts/hide-unhide-worksheets-in-excel-python/680844750c87f12c7d5b363c)

### [How to Hide and Unhide Worksheets in Excel with Python | Easy Guide](https://casie.hashnode.dev/hide-unhide-worksheets-in-excel-python?utm_source=hashnode&utm_medium=feed)

Quickly learn how to hide and unhide worksheets in Excel files using Python. This guide offers easy steps to manage Excel worksheet visibility without hassl

4 min read · [casie.hashnode.dev](https://casie.hashnode.dev/hide-unhide-worksheets-in-excel-python?utm_source=hashnode&utm_medium=feed)
