
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

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 you didn’t build. Trace Precedents, Watch Window, Go To Special and 5 more tools show where every number comes from. Free practice file.

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

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 from a folder into one table with Power Query. Download the practice files and follow along step by step.

Use PowerPoint Morph to zoom into a picture, spotlight one person and animate a timeline. Download the free PowerPoint template with all three examples.
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.
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.
Go To Special won’t find numbers hidden inside formulas. Use FORMULATEXT with REGEXTEST and conditional formatting to highlight them.
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.
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.

This free Excel guide will help you to: