How To Excel

Courses & eBooks

Become an Excel master with full video Courses and eBooks from Microsoft MVP John MacDougall.

Video Course

This course will take you from raw data to a dynamic and interactive dashboard.

Along the way, you’ll learn the key tools in Excel you need in order to become an expert.

Import and transform raw data with Power Query, build relational data models to analyse multi-table data sets, build Pivot Tables and Pivot Charts to summarize and visualize your data… and much more!


This book will teach you the 51 functions you need to know so you don’t end up wasting your precious time trying to figure out what’s worth learning.

Plus many other hidden formula tips and tricks are included that will help turn you into a formula master!

BONUS: 10 part video course with the first ten functions you need to learn.

Video Course

Pivot Tables allow you to easily summarize large amounts of data and quickly turn it into meaningful insights.

You’ll be able to summarize and visualize your data without complicated formulas or code.

In this step by step guide, you’ll learn the secrets of Excel’s most useful and powerful feature for analyzing your data.


Learn favorite techniques from this group of twenty-four Excel MVPs.

This book covers: Custom Number Formatting, Ctrl + Enter, INDEX MATCH, Named Ranges,  Excel’s New Data Types, Dynamic Arrays,  XLOOKUP, Charts, Advanced Filters, Power Query, Power Pivot, Financial Modelling, VBA…

and so much more!