Resources

Excel is an essential part of so many jobs these days.  When used well, Excel can automate repetitive tasks, transform raw data into insightful information, solve problems and predict future outcomes.  

I have been asked many times how I become so good at Excel.  My answer is always the same: books and online courses.  This is why I recommend them as a way to learn.  If I could go back and speak to my younger self, I would advise investing in my Excel learning much earlier; it would have shortcut so many stages in my career (and saved me a ton of time).  Please don’t be like me and wait to invest in yourself, take the opportunity to develop your skills today.

Online courses and books are great because you can learn at own pace and repeat difficult topics.

With so many Excel options available, where do you start?  I’ve created this page to list what I believe to be the best books and instantly available online course.

Disclosure: Some of the links on this site are affiliate links, meaning at no additional cost to you, I may receive commissions for purchases made through those links.  Please only purchase the products if you believe they will add value for you.

 

General Excel

Excel Bible

This is the complete resource for learning Excel.  An excellent book choice for all users from beginners to experts.

It covers formulas, charts, data analysis techniques and VBA.

Guerrilla Data Analysis

This book includes examples and case studies that teach users the techniques and tricks for analyzing data in Excel.

 Topics include data quality, validation, matching lists of data, data consolidation, pivot tables and tables. 

Ctrl + Shift + Enter

This book covers advanced formula concepts.

If you think you are a formula expert, this book will teach you things you never thought possible.

Excel Expert Course

ExcelExpertCourse

With over 14 hours of tutorials, this course will teach you to be an Excel expert.  The course is structured so that you can pick and choose individual modules to learn the skills you need as and when you need them.

Excel for Accountants

Being an accountant myself, I can appreciate the approach this course takes to teaching Excel.  Jeff Lenning, the course creator, has trained thousands of accountants to use Excel better (and save time).

These courses provide a certificate for CPE credits.

My Excel Online Academy

You can dip into this online training to learn particular areas when required, or follow the complete structured learning programme, which includes over 300 videos.

Charts, Dashboards and Visualizations

Effective Data Visualization

Should you include a legend?  What colors? Do we need the gridlines? Most Excel users don’t really know.  

This book answers those questions and provides the principles and methods to communicate with engaging visuals.

Dashboards for Excel

A great resource for building Excel dashboards using formulas and VBA.

The techniques involved are transferable to all aspects of Excel.  The book works through a case study which creates a robust framework for creating any Excel tools.

Visually Effective Dashboards

The ability to turn significant amounts of data into meaningful visualizations is one of the best skills an Excel user can have.

This course teaches actionable Excel Tips to create eye-catching Excel Dashboards.

Power Query & Power Pivot

Power Query Course

If you’re looking for a straight Power Query course, then the course from My Online Training Hub is a great option.

With 5 hours of tutorials, it covers all the essential aspects you need to be up and running quickly.

Intro to Power Query, Power Pivot & DAX

Get up and running with Excel’s new data modeling & business intelligence tools.

The course covers the most important aspects of each tool by using a case study with a large and realistic data set. What you learn can be directly applied to your business situation.

M is for (Data) Monkey

Power Pivot and Power BI

Macros / VBA

Excel Power Programming with VBA

Most of what I know about VBA comes from working through a previous edition of this book.

And of all the Excel books I own, it is this one which I go back to most often.

The Complete Excel VBA Course for Beginners

Alan Murray has been training people to use Excel for over 15 years, both in person and online.

Thousands of users have been through this beginner VBA course, which consistently receives excellent user reviews.

Unlock Excel VBA and Excel Macros

With over 22 hours of videos, this is one of the most comprehensive VBA courses available. 

Going from beginner through to advanced topics, this course will benefit users of all levels.