Latest Blog Posts - ExcelDemy

How to Build a Gantt Chart in Excel from Scratch

Sep 10, 2026

In this tutorial, we will show the steps to build a Gantt chart in Excel from scratch. Let's create a clean, professional Gantt chart with some ...

How to Build a Gantt Chart in Excel from Scratch

3 Excel Add-Ins That Instantly Level Up Your Workflow

Sep 9, 2026

In this article, we will list 3 Excel add-ins that instantly level up your workflow. Enable each add-in and use it for a practical Excel task

5 Conditional Formatting Tricks for Spotting Problems at a Glance

Sep 9, 2026

In this tutorial, we will show 5 conditional formatting tricks for spotting problems at a glance. These tricks will help you catch data-entry errors, ...

How to Build a Rolling Dashboard with Slicers and Timelines

Sep 1, 2026

In this tutorial, we will show how to build a rolling dashboard with Slicers and Timelines. We will build dynamic date logic that makes it "roll" ...

How to Lock Cells and Protect Sheets Without Locking Yourself Out

Sep 1, 2026

In this tutorial, we will show how to lock cells and protect sheets without locking yourself out. Follow this workflow to avoid getting locked out of ...

10 Essential Excel Functions for Financial Analysts

Aug 31, 2026

In this tutorial, we will cover 10 essential Excel functions for financial analysts with practical examples.

Paginated Reports in Power BI: When You Still Need a Pixel-Perfect PDF

Aug 16, 2026

In this tutorial, we will show how to create paginated reports in Power BI when you still need a pixel-perfect PDF.

How to Merge Data from Multiple Excel Files Using Power Query

Aug 16, 2026

In this tutorial, we will show how to merge data from multiple Excel files using Power Query.

10 Creative Ways to Visualize Data in Excel

Aug 16, 2026

In this tutorial, we will show 10 creative ways to visualize data in Excel. These practical and creative approaches go beyond the basics.

Power BI Templates (.pbit): Standardizing Reports Across Your Team

Aug 11, 2026

In this tutorial, we will show how to create and use Power BI templates to standardize reports across your team.

Power BI Templates (.pbit): Standardizing Reports Across Your Team

How to Perform Multi-Criteria Lookups with XLOOKUP and INDEX/MATCH

Aug 11, 2026

In this tutorial, we will show how to perform multi-criteria lookups with XLOOKUP and INDEX/MATCH.

10 Excel Functions to Simplify Your Data Analysis

Aug 11, 2026

These ten functions cover lookups, aggregation, and dynamic arrays, the core toolkit for turning raw spreadsheets into real insight.

10 Excel Functions to Simplify Your Data Analysis

Auditing and Validating Spreadsheets with ChatGPT

Aug 9, 2026

In this tutorial, we will show how you can audit and validate spreadsheets with ChatGPT. You will get a workflow to use ChatGPT as a spreadsheet ...

Auditing and Validating Spreadsheets with ChatGPT

How to Link Excel Charts to PowerPoint So They Auto-Update

Aug 9, 2026

In this tutorial, we will show how to link Excel charts to PowerPoint so they auto-update. Linked charts will automatically reflect the latest data ...

3 Excel Techniques for Cleaning Up Inherited ‘Legacy’ Spreadsheets

Aug 9, 2026

In this tutorial, we will show 3 Excel techniques for cleaning up inherited “legacy” spreadsheets. From quick formula fixes to a full Power Query ...