Excel Insights by 24 Excel MVPs (eBook)

Written by MVPs. Edited by MVPs. This book shares a wide variety of advanced and new techniques. Bonus videos on Data Presentation included.

Get Access

The Excel MVPs have a wealth of knowledge and passion for Excel. This book shares a wide variety of advanced and new techniques.

Brian Jones, Former Head of Product, Excel

This is NOT like a normal book used to learn Excel.

This Expert Excel Techniques eBook is a selection of self-contained articles covering hot topics such as

Rich Data Types
Collaboration
Dynamic Arrays
Xlookup and other brand new functions
Charting Tricks
Data Analysis / PivotTables
Financial Modeling
Number Formatting
Power Pivot
Power Query
VBA Tips

All of these topics are covered by 24 Excel MVPs on 280 pages.

And you can download the Excel files used to follow along.

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.

Feel free to dive in this Expert Excel Techniques eBook and become immersed in the contagious enthusiasm for the world’s most popular spreadsheet software.

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

🎁 Join Now To Get This Special Bonus

Get the 7 part video series with Leila: Professional Presentations with One Simple Trick

This is part of a presentation Leila gave for Bulgaria Excel Days where she covered 3 Methods and 1 simple but overlooked trick that will help you create professional reports.

The Workbook used is included in the package.

Here Is What’s Included