4 Ways to Navigate Large Excel Workbooks Faster

Learn 4 ways to navigate large Excel workbooks using the sheet tab menu, Navigation pane, clickable hyperlinks, and Name Box bookmarks.

How to Audit an Excel Workbook: 8 Built-In Tools

How to audit an Excel workbook you didn’t build. Trace Precedents, Watch Window, Go To Special and 5 more tools show where every number comes from. Free practice file.

How to Make Excel Charts Like The Economist

Use PowerPoint Morph to zoom into a picture, spotlight one person and animate a timeline. Download the free PowerPoint template with all three examples.

Excel Advanced Filter: AND, OR and Between Criteria

Set up Excel Advanced Filter criteria for AND, OR and between conditions, and extract unique records. Get the free practice workbook.

Combine Multiple Excel Files into One with Power Query

Combine multiple Excel files from a folder into one table with Power Query. Download the practice files and follow along step by step.

PowerPoint Morph Transition: 3 Practical Examples

Use PowerPoint Morph to zoom into a picture, spotlight one person and animate a timeline. Download the free PowerPoint template with all three examples.

Copilot at Work – Microsoft 365 Copilot

Put Microsoft 365 Copilot to work in Excel and beyond. Learn to clean up data, build reports, and tackle everyday tasks with practical lessons that take you from start to finish.

Excel Lists in Cells: Put Multiple Values in One Cell

For 40 years, an Excel cell held one value. Now it can hold a list. Learn Ctrl+J, HAS, HASANY, HASALL and FLATTEN, plus how GROUPBY works with lists. Free workbook included.

How to Find Hardcoded Numbers in Excel Formulas

Go To Special won’t find numbers hidden inside formulas. Use FORMULATEXT with REGEXTEST and conditional formatting to highlight them.

AI Prompts for Excel Data Analysis: How to Get Results You Can Trust

Sort, remove duplicates, done? On large data, Power Query can quietly keep the wrong record and never warn you. Here’s why it happens and the one-line fix. Free workbook included.

Python in Excel Foundations

Keep the Latest Record in Power Query (Why Remove Duplicates Keeps the Wrong One)

Sort, remove duplicates, done? On large data, Power Query can quietly keep the wrong record and never warn you. Here’s why it happens and the one-line fix. Free workbook included.

Free Guide!

The ONE Critical Excel Skill You Need

This free Excel guide will help you to:

  • Pinpoint the Excel skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill