8 Hidden Excel Tools to Understand Any Spreadsheet
From Leila Gharani ยท ยท 11 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Inherited a huge Excel file? Here are 8 practical ways to audit the workbook. ๐ฅ Download the practice file: https://www.xelplus.com/audit-excel-workbook/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-audit-workbook&utm_content=audit-excel-workbook#download
Start with Workbook Statistics and the Navigation pane to understand how the file is organized. Use Focus Cell and Freeze Panes to navigate large sheets without getting lost.
Then follow calculations across sheets with Trace Precedents and Trace Dependents. Use the Watch Window to see how KPIs change when you adjust an input, and Go To Special to find hard-coded numbers and inconsistent formulas hiding in a column.
You'll also see why spilled formulas are less vulnerable to accidental changes, and how Copilot can help explain a workbook you didn't build.
๐ 500,000+ enrolled in our courses. Learn the Excel features you use every day with Excel Essentials ๐ https://www.xelplus.com/course/learn-excel-essentials/?utm_source=yt-video&utm_medium=vid-general&utm_campaign=essentials&utm_content=audit-excel-workbook
๐ฅ Training a team? Buy seats and track progress in an admin dashboard: https://www.xelplus.com/business-customers/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=business-seats&utm_content=audit-excel-workbook
**Excel shortcuts:** Ctrl+[ selects precedent cells. Ctrl+] selects dependent cells.
These shortcuts may not work as expected on some European keyboard layouts. If you've found a workaround, share it in the comments.
**Good to know:** Focus Cell and the Navigation pane are available in Microsoft 365. Copilot availability depends on your Microsoft 365 plan and organization settings.
**Chapters:** 00:00 Auditing someone else's Excel file 00:15 Workbook Statistics: what's in the file 00:40 Navigation pane: every sheet in one view 01:05 Focus Cell: see your row and column 01:31 Freeze Panes: keep headers in view 02:19 Trace Precedents: where numbers come from 03:07 Follow references to other sheets 03:46 Shortcut: Ctrl+[ to jump to precedents 04:14 Shortcuts on European keyboards 05:18 Trace Dependents: what a change affects 05:42 Watch Window: track KPIs while you edit 07:24 Name cells for a clearer Watch Window 08:00 Go To Special: find hard-coded numbers 08:55 Filter the flagged cells by color 09:26 Why spilled formulas are safer 09:55 Let Copilot explain the workbook
๐ฌ I gave ChatGPT a messy Excel file. Here's what happened: https://youtu.be/0PzmVXPdkuk
โก๏ธ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
โ๏ธ Get one practical Excel tip every week in our free newsletter, Between the Sheets: https://link.xelplus.com/yt-d-newsletter
๐ฉ Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani
#excel #exceltips #excelaudit