Excel Insights

Table of Contents

1. Smart Uses of Custom Number Formatting
2. Ctrl + Enter
3. Auto-Magically Master INDEX MATCH (and Other Formulas)
4. Relative Named Ranges – When Named Ranges Go Walkabout
5. An Introduction to Excel's New Data Types
6. A Look to the Future – Dynamic Arrays
7. XLOOKUP Debuts in Excel
8. Why the Love / Hate for Pie Charts?
9. Intermediate Charting in Excel
10. Creating Charts for Presentations
11. Advanced Filter
12. Power Query: Manipulate Your Data Like a Pro
13. Combine All Files in a Folder
14. Power Query M Code Approximate Match Lookup Formula
15. The Power Behind the Boringest Sentence in Excel
16. Understanding Context in Power Pivot
17. Thinking Through the Modelling of a Seating Chart
18. Financial Modelling
19. Creative Excel Model Development
20. An Introduction to Simulation in Excel
21. Staying out of Trouble
22. Make Your Own VBA Worksheet Functions
23. An Overview of Modern VBA Best Practices
24. About the MVPs