Excel Insights eBook
24 Experts Reveal the Best Parts of Excel
Your Instructor
Author of more than 60 books about Microsoft Excel and publisher of many other Microsoft Office books. He is usually on the road doing live Excel seminars. He has over 2,000 Excel videos on YouTube and is a Microsoft Certified Trainer. He's known as Mr Excel for a good reason.
Learn favorite techniques from this group of twenty-four Excel MVPs. The Excel MVPs are friends and competitors who each pulled out their favorite tricks to impress you and their fellow MVPs. Included in the book:
- Leila Gharani: Smart Uses of Custom Number Formatting
- Gašper Kamenšek: Ctrl + Enter
- Wyn Hopkins: Auto-Magically Master INDEX MATCH (and Other Formulas)
- Mynda Treacy: Relative Named Ranges – When Named Ranges Go Walkabout
- John MacDougall: An Introduction to Excel’s New Data Types
- Liam Bastick: A Look to the Future – Dynamic Arrays
- Tim Heng: XLOOKUP Debuts in Excel
- Jon Acampora: Why the Love / Hate for Pie Charts?
- Jon Peltier: Intermediate Charting in Excel
- Dave Paradi: Creating Charts for Presentations
- Roger Govier: Advanced Filter
- Frederic le Guen: Power Query: Manipulate Your Data Like a Pro
- Ken Puls: Combine All Files in a Folder
- Mike Girvin: Power Query M Code Approximate Match Lookup Formula
- Bill Jelen: The Power Behind the Boringest Sentence in Excel
- Henk Vlootman: Understanding Context in Power Pivot
- Oz du Soleil: Thinking Through the Modelling of a Seating Chart
- Tony de Jonker: Financial Modelling
- Hervé Thiriez: Creative Excel Model Development
- Ian Huitson: An Introduction to Simulation in Excel
- Jan Karel Pieterse: Staying out of Trouble
- Charles Williams: Make Your Own VBA Worksheet Functions
- Mathieu Guindon: An Overview of Modern VBA Best Practices
- Ingeborg Hawighorst: served as editor for the book
You are buying the e-book. Immediately after purchase, you can download the book in three formats: PDF, Mobi (for your Kindle) or ePub (for iPad and other devices).
Hear the Figures: Each figure includes Alt Text for people using screen readers.
Course Curriculum
Excel Insights eBook Downloads
Available in
days
days
after you enroll
Frequently Asked Questions
How do I get my eBook after purchase?
Immediately after payment you can download the eBook in any of 3 DRM-Free versions: PDF, ePUB or Mobi. Please ensure that your devices are compatible with the eBook before you purchase.
Are refunds available for the eBook?
All eBook sales are final, and as such non-refundable.