Excel Insights

A Microsoft MVP Guide to the Best Parts of Excel

Publisher:Packt Publishing Limited

By: MrExcel's Holy Macro! Books and 24 Excel MVPs

Paid access

|Mar 2025

E-Book €10.99Institutions €105.95

Description

Unlock the full potential of Excel with advanced tips and techniques covering everything from formulas to VBA.

Key Features

Advanced Excel features, from custom formatting to dynamic arrays
Data analysis and visualization with Power Query and charts
Detailed explanation of VBA for task automation and efficiency

Book Description

Dive into the world of advanced Excel techniques designed to elevate your data analysis skills. Start with mastering custom number formatting, efficient data entry, and powerful formulas like INDEX MATCH. Explore Excel's evolving features, including dynamic arrays and new data types, ensuring you stay at the forefront of the latest tools.

The course then guides you through creating impactful charts for presentations and advanced filtering techniques. You’ll also discover the transformative power of Power Query, allowing you to manipulate and combine data with ease. With chapters on financial modeling and creative Excel model development, you’ll learn to solve complex problems and develop innovative solutions.

Finally, the course introduces you to VBA, teaching you how to automate tasks and create custom worksheet functions, equipping you with the skills to enhance your workflows. By the end of the course, you’ll have a robust understanding of Excel's advanced features, empowering you to handle any data challenge with confidence and creativity.

What you will learn

Master custom number formatting
Utilize INDEX MATCH effectively
Create dynamic arrays
Build advanced charts
Automate with Power Query
Develop VBA functions

Who this book is for

Ideal for intermediate to advanced Excel users, data analysts, and financial modelers. Readers should have a basic understanding of Excel. Prior experience with Excel formulas, charts, and data management is recommended.

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

Table of contents

Authors

Metrics

PDF ISBN: 978-1-83664-268-8

Publisher: Packt Publishing Limited

Publication date: 2025

Language: English

Pages: 289

Related subjects:

Computer sciences,

Computer sciences, other

Excel Insights

Key Features

Book Description

What you will learn

Who this book is for

Table of Contents

People also read

Publications carousel

More Excel Outside the Box

Excel Outside the Box

Power Excel with MrExcel

Excel Crash Course

Excel

Microsoft 365 Excel: The Only App That Matters

Your Excel Survival Kit

Slaying Excel Dragons

Excel at 40

Excel Power Moves

Paradigm

My account