Excel Insights by 24 Excel MVPs e-Book

SKU: 380
Qty: - +
   - OR -   

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.

Currently there are no reviews for this product. Share your opinion with others, be the first to write a review.

Add Your Review

Your Name:
Email Address:
Note: HTML is not translated! Your email address will not be shared with anyone.
Your Rating: 5
Your Name:
Your Email:
Friends Name:
Friends Email:
Related Products
Excel Insights by 24 Excel MVPs Print Edition
SKU: 381
A Microsoft MVP guide to the best parts of Excel

"Ctrl+Shift+Enter" by Mike "ExcelIsFun" Girvin [eBook ]
SKU: 263
"Ctrl+Shift+Enter" by Mike "ExcelIsFun" Girvin [eBook]

M is for (Data) Monkey e-Book
SKU: 323
You'll go bananas as you replace tedious data cleansing with Power Query. This is the e-book version of the definitive book on Power Query for Excel.

Introduction to Financial Modelling - Print Edition
SKU: 372
How to Excel at being a Lazy (that mean's efficient!) modeller. This 328-page book was originally published in Australia. It was such an informative Excel book, we've reprinted it for the US & UK markets. This is the print edition of the book.

Excel Data Cleansing Straight To The Point - eBook
SKU: 369
A 47-page guide to cleaning Excel data. This book covers traditional data cleansing methods like Text to Columns, Conditional Formatting, Remove Duplicates and Power Query.
$4.95 $3.95

Power Excel with MrExcel - 2019 Edition [eBook]
SKU: 377
This is the e-Book edition of Bill Jelen's best selling book. Updated to include features released through early 2019. Updates include Dynamic Arrays (SORT, FILTER, UNIQUE), Geography Data Types, Stock Data Types, and Column from Examples in Power Query.
$24.95 $15.95