Excel Insights
A Microsoft MVP Guide to the Best Parts of Excel
Published on 1. April 2020
289 pages
978-1-61547-153-9 (ISBN)
Description
Unlock the power of Excel with insights from leading experts! This comprehensive guide, curated by twenty-four Excel MVPs, delivers a treasure trove of tips, techniques, and shortcuts to elevate your spreadsheet skills. Whether you're a finance professional, data analyst, or simply an Excel enthusiast, this guide offers practical solutions to common challenges and innovative approaches to data manipulation. Dive into topics like custom number formatting, INDEX MATCH mastery, Power Query, dynamic arrays, and VBA. Learn how to create dynamic reports, automate tasks, and visualize data with impact. Transform your Excel skills and boost your productivity with this essential resource, designed to help you impress your boss and advance your career.
More details
Other editions
Additional editions
Book
04/2020
Holy Macro! Books
€32.60
Shipment within 3-4 weeks
Content
- Intro
- Smart Uses of Custom Number Formatting
- Ctrl + Enter
- Auto-Magically Master INDEX MATCH (and Other Formulas)
- Relative Named Ranges - When Named Ranges Go Walkabout
- An Introduction to Excel's New Data Types
- A Look to the Future - Dynamic Arrays
- XLOOKUP Debuts in Excel
- Why the Love / Hate for Pie Charts?
- Intermediate Charting in Excel
- Creating Charts for Presentations
- Advanced Filter
- Power Query: Manipulate Your Data Like a Pro
- Combine All Files in a Folder
- Power Query M Code Approximate Match Lookup Formula
- The Power Behind the Boringest Sentence in Excel
- Understanding Context in Power Pivot
- Thinking Through the Modelling of a Seating Chart
- Financial Modelling
- Creative Excel Model Development
- An Introduction to Simulation in Excel
- Staying out of Trouble
- Make Your Own VBA Worksheet Functions
- An Overview of Modern VBA Best Practices
- About the MVPs
- Index
