Excel Insights: A Microsoft MVP Guide to the Best Parts of Excel
1146368708
Excel Insights: A Microsoft MVP Guide to the Best Parts of Excel
14.99 In Stock
Excel Insights: A Microsoft MVP Guide to the Best Parts of Excel

Excel Insights: A Microsoft MVP Guide to the Best Parts of Excel

by MrExcel's Holy Macro! Books, 24 Excel MVPs
Excel Insights: A Microsoft MVP Guide to the Best Parts of Excel
Add to Wishlist
Excel Insights: A Microsoft MVP Guide to the Best Parts of Excel

Excel Insights: A Microsoft MVP Guide to the Best Parts of Excel

by MrExcel's Holy Macro! Books, 24 Excel MVPs

Product Details

ISBN-13: 9781836642688
Publisher: Packt Publishing
Publication date: 10/01/2024
Sold by: Barnes & Noble
Format: eBook
Pages: 289
File size: 23 MB
Note: This product may take a few minutes to download.

About the Author

Holy Macro! Books has been providing top-quality books on Excel, Power Query, and Power BI since 2002. They have published over 100 titles by 30 authors, including numerous Microsoft MVPs.
Microsoft MVPs are technology experts who have very deep knowledge of Microsoft products. Each year, Microsoft recognizes experts who have shown a passion for sharing that knowledge with the community. This book is written by twenty four Excel MVPs: Jon Acampora, Liam Bastick, Leila Gharani, Mike Girvin, Roger Govier, Frederic le Guen, Mathieu Guindon, Ingeborg Hawighorst, Tim Heng, Wyn Hopkins, Ian Huitson, Bill Jelen, Tony de Jonker, Gašper Kamenšek, John MacDougall, Dave Paradi, Jon Peltier, Jan Karel Pieterse, Ken Puls, Oz du Soleil, Hervé Thiriez, Mynda Treacy, Henk Vlootman, and Charles Williams.

Table of Contents

Table of Contents
  1. Smart Uses of Custom Number Formatting
  2. Ctrl + Enter
  3. Auto-Magically Master INDEX MATCH (and Other Formulas)
  4. Relative Named Ranges – When Named Ranges Go Walkabout
  5. An Introduction to Excel's New Data Types
  6. A Look to the Future – Dynamic Arrays
  7. XLOOKUP Debuts in Excel
  8. Why the Love / Hate for Pie Charts?
  9. Intermediate Charting in Excel
  10. Creating Charts for Presentations
  11. Advanced Filter
  12. Power Query: Manipulate Your Data Like a Pro
  13. Combine All Files in a Folder
  14. Power Query M Code Approximate Match Lookup Formula
  15. The Power Behind the Boringest Sentence in Excel
  16. Understanding Context in Power Pivot
  17. Thinking Through the Modelling of a Seating Chart
  18. Financial Modelling
  19. Creative Excel Model Development
  20. An Introduction to Simulation in Excel
  21. Staying out of Trouble
  22. Make Your Own VBA Worksheet Functions
  23. An Overview of Modern VBA Best Practices
  24. About the MVPs
From the B&N Reads Blog
Page 1 of

Related Subjects

Computers
Applications & Software
Spreadsheets
Computers
Applications & Software
Spreadsheets

Customer Reviews