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? To download example files, enter email here: https://www.xlconsulting-asia.com/socials.html 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