Advanced Excel Archives - Page 2 of 64

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

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

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

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

5 Excel Functions Every Marketer Should Know

Jul 14, 2026

In this tutorial, we will show five Excel functions that every marketer should know. These functions can help you summarize, categorize, measure ...

5 Excel Functions Every Marketer Should Know

How to Connect Excel to Live Web APIs Without Using VBA

Jul 8, 2026

In this tutorial, we will show how to connect Excel to live web APIs without using VBA. We will use Power Query’s From Web feature to pull live API ...

5 LAMBDA Functions That Turn Excel Into Your Own Programming Language

Jul 7, 2026

In this tutorial, we will show 5 LAMBDA functions that turn Excel into your own programming language.

Fixing Excel Formulas with ChatGPT

Jul 3, 2026

In this tutorial, we will show how to fix Excel formulas with ChatGPT. ChatGPT excels as a debugging partner: it can explain complex formulas, ...

How to Use Boolean Variables in VBA

Jul 2, 2026

In this tutorial, we will show how to use Boolean variables in VBA. Instead of writing long conditions repeatedly, you can store the result in a ...

Mining Your Excel Spreadsheets with ChatGPT

Jun 25, 2026

In this tutorial, we will show how you can mine your Excel spreadsheets with ChatGPT. You will get the prompts and techniques to get actionable ...

Mining Your Excel Spreadsheets with ChatGPT

How to Format Dates in Excel Using VBA

Jun 23, 2026

In this tutorial, we will show how to format dates in Excel using VBA. Here you will get VBA examples with short codes.

How to Build an Automated Invoice Routing Workflow with Excel and Power Automate

Jun 17, 2026

In this tutorial, we will show how to build an automated invoice routing workflow with Excel and Power Automate. It will read new invoice rows from ...