A Microsoft MVP Guide to the Best Parts of Excel
A Microsoft MVP Guide to the Best Parts of Excel
Authors: Bill Jelen, Oz du Soleil,
Mike Girvin, Ken Puls, Liam Bastick, and more…
Shop with Confidence
✔ 100% Secure Shopping
✔ No Complex Software or Subscriptions
✔ Secure Digital Delivery with E-Junkie
✔ No Expensive Licenses
✔ 286 Pages
✔ ISBN: 978-1-61547-069-9
✔ PDF ISBN: 978-1-61547-153-9
✔ Instant Download
Exceptional high quality, real world expertise
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.
Table of Contents
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
Frequently Asked Questions – Partner Products
Does the Refund Apply to Partner Products?
The Terms and Conditions of Sale for Partner Products including refunds is in accordance with the Partners Terms and Conditions. Refer to their website.
While Digital Documents Direct makes every attempt to provided detailed, comprehensive information, you are responsible for reviewing, checking and confirming the information provided is suitable for your use.
Is this complicated Software or Subscriptions?
No. This is not complicated software where you need an ongoing subscription or annual fee. It is a one off payment.
Do I need a Paypal account to purchase?
No, you do not need a Paypal account to purchase our products. You can pay with Paypal or use your credit card.
How will my information be used?
Your information will not be used whatsoever without your permission. In other words, your email address will not be sold or spammed.
Will I get on a spam list?
No. We may add you to our newsletter list. However you can ‘opt out’ at any time. Above all, you will not be spammed.
Will I be the victim of identity theft?
No. Paypal and e-Junkie provide a 100% secure system to perform the transaction.
Will the purchase arrive on time?
Yes. As soon as you have paid for your purchase, you will receive a download link via email. However, please remember to also check your ‘Junk Email’ as if you have not received your link immediately, the email could be in your ‘Junk Email Inbox’.
Should you not receive the download link, please contact us immediately and we will get back to you as soon as we can. Please note, the time zone of your country may effect our response time, however we will respond as soon as we can. Our business is located in Australia.
AEST – Australian Eastern Standard Time.
Will I actually get what I ordered?
Yes. We promise to deliver to you and stand by this promise. Further to this, Paypal guarantees your transaction so you can shop with full confidence.
Will unexpected fine print charges be added to my order without my knowledge?
No. There are no further charges. No monthly subscriptions either. You have the right to use the document to your desires within the terms and conditions of the Partner website. Refer to their website for more information.
Will anyone respond if I have problems after buying?
Yes. However, there may be a delay in our response. Depending on your country timezone, we will respond as soon as we can. Please note, we endeavor to respond to your requests within the shortest possible time.
I did not receive a download link after paying
Please do not panic. e-Junkie are both very reliable document delivery systems and it is unlikely this will occur. However, if it does, we will email you the download link as soon as we can.
The website briefly redirected through e-Junkie. Is this safe?
Yes it is safe. When you click on the Proceed to Pay button, you will be redirected briefly through e-Junkie.com to Paypal.com depending on how you choose to pay. Partner products are delivered electronically so you receive them immediately – 24 Hours a day, 7 days a week.
Copyright © 2022
All rights reserved. No part of this website or information may be reproduced or used in any manner without written permission of the copyright owner.