Advanced Excel

How to Use Copilot in Excel for Forecasting and What-If Scenario Analysis

In this tutorial, we will show how to use Copilot in Excel for forecasting and what-if scenario analysis. We will combine both Copilot and Excel ...

How to Use Copilot in Excel to Build and Understand Complex Formulas (Step-by-Step)

In this tutorial, we will show how to use Copilot in Excel to build and understand complex formulas. You’ll describe the business goal in everyday ...

How to Clean Messy Data in Excel with Copilot (7 Common Problems Solved)

In this tutorial, we will show how to clean messy data in Excel with Copilot. We’ll solve 7 common problems using both methods side-by-side, with ...

5 Essential Power Query Transformations for E-commerce Sales Data

In this tutorial, we will learn 5 essential Power Query transformations for e-commerce sales data that are especially useful for online store ...

How to Show a Progress Message While VBA Runs

In this tutorial, we will show how to show a progress message with VBA runs. You do not need a UserForm or a graphical progress bar. In many cases, ...

Python in Excel: When and How It’s Useful

In this tutorial, we will show how to use Python in Excel and when and how it’s useful. Instead of switching to other tools like Jupyter or VS Code, ...

5 Python Libraries for Advanced Excel Data Analysis Every Pro Should Use

In this tutorial, we will show 5 Python libraries for advanced Excel data analysis every pro should use. These libraries allow you to perform ...

The Excel Email Generator: Using VBA to Send Personalized Outlook Messages from Spreadsheet Rows

In this tutorial, we will show how you can build an Excel Email Generator, using VBA to send personalized Outlook messages from spreadsheet rows. The ...

7 Excel Settings Secretly Slowing Down Your Large Workbooks

In this tutorial, we will show 7 Excel settings secretly slowing down your large workbooks, with practical steps to identify and fix them. We'll ...

7 Excel Functions for Effective Human Resources Management

In this tutorial, we will show 7 Excel functions for effective human resources management. We will focus on seven key functions. These are ...

Excel VBA Terminology: Macro vs Module vs Procedure

In this tutorial, we will discuss Excel VBA terminology: Macro vs Module vs Procedure. We’ll break them down with explanations, examples, and ...

Building a QR Code Inventory Tracker with Excel

In this tutorial, we will show you how to build a QR code inventory tracker with Excel.

How to Create Multiple Tables in the Same Sheet

In this tutorial, we will show how to create multiple tables in the same sheet.

Don’t Touch Your Raw Data: A Workflow Tweak to Save You From Yourself

In this tutorial, we’ll walk through a simple workflow tweak that can save you from yourself.

App-ify Your Excel Workbook with Vibe Coding

In this tutorial, we’ll show you how to app-ify your Excel workbook using vibe coding.

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo