Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel
The Excel MVPs have a wealth of knowledge and passion for Excel. This book shares a wide variety of advanced and new techniques.
- 286 Pages
- Publisher: Holy Macro! Books
- ISBN: 978-1-61547-069-9
- PDF ISBN: 978-1-61547-153-9
Microsoft's Most Valuable Professional (MVP) award recognizes exceptional technical community leaders from around the world who voluntarily share their high quality, real world expertise and application with others. Microsoft MVPs are a highly select group of experts representing technology's best and brightest who share a deep commitment to community and a willingness to help others.
There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.
This is not like a normal book used to learn Excel. This book is a selection of self-contained articles covering hot topics such as rich data types, collaboration, dynamic arrays, XLOOKUP and other brand new functions, as well as charting tricks, data analysis / PivotTables, financial modeling, number formatting, Power Pivot, Power Query and VBA tips.
- 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