Excel Insights by 24 Excel MVPs (eBook)
Written by MVPs. Edited by MVPs. Read by Millions.
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, Excel Group Program Manager, Microsoft
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
- 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 are covered in 280 pages
You can download the Excel files used.
7 part video series: 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.
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 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
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).
StartProfessional Data Presentation with Just One Trick
StartWhat Most People Don't Do (10:30)
StartThe Trick Revealed (2:37)
StartThe Simple Rule (13:51)
StartVisualizing Change with Dynamic Thresholds (4:41)
StartOptimize Layout & Color (5:31)
StartPresenting with Pivot Tables (10:08)
StartKey Takeaways (1:01)