New Excel Navigation Pane + 26 Navigation tricks

Excel just launched a new Navigation Pane, so you can search through sheet names and various items within them (ranges, tables, PivotTables, charts, pictures etc.). I go through 26 navigation tricks including the navigation pane including shortcuts, formulas, tables, sheet names, and so much more. Did you know all of these?

Example files can be found here: www.xlconsulting-asia.com/youtube-files

To subscribe to Solve & Excel's monthly newsletter with Excel enhancements and more, click here: https://solveandexcel.ca/excel_news/

00:00 - 1. Navigation pane
00:50 - 2. Search in navigation pane
01:56 - 3. Go to last/first page
02:01 - 4. Get list of sheet names
02:12 - 5. File location
02:22 - 6. File online location
02:45 - 7. Ctrl Pg down
03:04 - 8. Jump to cell shortcuts
04:00 - 9. Filter to selected value
04:22 - 10. Go to special
06:00 - 11. Name box
06:31 - 12. Grouping
07:03 - 13. Navigate to command
07:29 - 14. Navigate to comment
07:40 - 15. Go to notes
07:53 - 16. Find word in workbook
08:15 - 17. Outliers
09:04 - 18. Duplicates
09:33 - 19. Trace precedents
10:13 - 20. Hyperlinks
11:06 - 21. Hyperlink function
11:52 - 22. Selection Pane
12:19 - 23. Select objects
12:34 - 24. Invalid data
13:17 - 25. Queries navigation
13:30 - 26. Table references