Latest Blog Posts - ExcelDemy

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 ...

Automating Excel Reports with ChatGPT-Generated Macros

Aug 4, 2026

In this tutorial, we will show automating Excel reports with ChatGPT-generated macros. You can create a reusable Excel reporting macro with the help ...

Composite Models in Power BI: Blending Import and DirectQuery Data

Aug 4, 2026

In this tutorial, we will show how you can use composite models in Power BI to blend import and DirectQuery data.

Composite Models in Power BI: Blending Import and DirectQuery Data

5 Ways to Build a Project Timeline in Excel Without an Add-In

Jul 31, 2026

In this tutorial, we will show five different ways to build a project timeline in Excel without an add-in. Each suits a different situation, from ...

5 Ways to Build a Project Timeline in Excel Without an Add-In

How to Build a Dynamic Drop-Down List That Updates Itself

Jul 30, 2026

In this tutorial, we will show how to build a dynamic drop-down list that updates itself. Add a new item to your source list, and it instantly ...

7 XLOOKUP Tricks That Make VLOOKUP Obsolete

Jul 29, 2026

In this tutorial, we walk through 7 XLOOKUP tricks that make VLOOKUP obsolete. It offers greater flexibility, fewer errors, and advanced capabilities ...

Power BI Alerts and Subscriptions: Getting Notified Before You Open the Report

Jul 23, 2026

In this tutorial, we will show how to use Power BI alerts and subscriptions to get notified before you open the report. Use an alert when the ...

Power BI Alerts and Subscriptions: Getting Notified Before You Open the Report

7 Keyboard Shortcuts That Will Cut Your Excel Time in Half

Jul 21, 2026

In this tutorial, we will list seven keyboard shortcuts that will cut your Excel time in half. These shortcuts can make the biggest difference in ...

7 Keyboard Shortcuts That Will Cut Your Excel Time in Half

Power BI Dataflows: Reusable ETL for Your Excel and Power BI Reports

Jul 14, 2026

In this tutorial, we will show how to use Power BI Dataflows to create reusable ETL (Extract, Transform, Load) for your Excel and Power BI reports. ...

Power BI Dataflows: Reusable ETL for Your Excel and Power BI Reports

Visualizing Excel Data with ChatGPT

Jul 14, 2026

In this tutorial, we will show how you can visualize Excel data with ChatGPT, from getting smart chart-type recommendations based on your data ...