Become an Excel Guru

Everything you need to up-skill yourself or your team in Excel.

Welcome to Become an Excel Guru, where you are going to learn everything you need to know to become an Excel expert. For the last ten years I've been using Excel to build advanced tools and applications in the investment banking and financial services industries.

So, you probably already know the basics of Excel and you use it in your job on a daily basis, and you're looking to learn more about Excel - but how much more?

Excel has a huge variety of tools and functionality, from the simple - like sum and average formulas - to more advanced tools like pivot tables and automation. But the scope of stuff to learn if you want to know EVERYTHING is enormous - for example, there are over 400 different functions you can use. Do you want to learn them all? Didn't think so!

You've probably been looking at 'intermediate' or 'advanced' level courses - but who decides what constitutes those skill levels? Is it just a case of knowing what all the buttons do or is there something deeper?

From over a decade of using, developing and training Excel I've learned that actually, you don't need to know it all to be an expert.

There is a collection of different tools that I believe are most important for day to day business use, like functions or charts, and then there are a few more advanced tools which can really set you apart from the rest, like summarising data using pivot tables, and using visual basic, Excel's automation toolkit.

My goal in this course is to teach you Excel to an advanced level but without confusing you and overwhelming you with information. I'm not just going to teach you what the buttons do - you are going to learn that of course, but more importantly you will learn how to use it correctly, and I'll make it easy for you to do it over and over again.

I've split the course into four key modules, which follow a logical progression from raw data to end results:

Module 1: The first module covers working with data in Excel, where you'll learn all about how to structure your data, clean it and enrich it using formulas and how to use some fundamental Excel tools like adding styles and dropdown options to cells.

Module 2: The second module is about analysing your data, and most of this module is a deep dive on pivot tables - Excel's easy to use drag and drop data summary tool. We'll cover all kinds of ways to slice and dice your data and really uncover the key trends and insights.

Module 3: This module covers presenting your analysis, with the key focus being on learning how to create great looking management reports and dashboards. You don't have to be a data analyst to reap the benefits of this type of knowledge. Being able to present great analysis in a succinct and informative dashboard is a skill that can really take your career to another level.

Module 4: Finally we'll cover automation in Excel using Microsoft's coding language, VBA. It’s not as techy as you might think, and it's one of the easiest coding languages you can possibly learn. This module will set you on the road to being able to automate away repetitive and boring tasks you do in Excel, and can even help you create totally customized buttons and tools in your spreadsheets for your job or your clients.

I think you'll get a huge amount of value from this course and you will come away with a deep understanding of how to use Excel correctly and with ease. No more throwing the mouse across the room or banging your head against the wall - this will take you to the next level.

I wanted to make my course different to other courses by encouraging ongoing learning. That's why I created a private Facebook group for my students. So, in addition to the course you'll get lifetime access to my 'Excel Mentor' Private Facebook community - with weekly tips and challenges to keep your Excel knowledge fresh and sharp. There's a great community of fellow students in the group to engage with and share your Excel tips and questions

Your Instructor


Hi, I'm Martyn. I created my courses to help you to get better at Excel and to get your next promotion, job or raise. My courses are a little different to most - you'll learn the most powerful functionality in Excel through in depth online courses, ongoing learning through case studies and exercises, as well as a fantastic online student community to share your experiences of breaking through the career ladder with better skills.

I am also the founder of Effective MI, a dashboard development & process improvement company. We help companies understand their business through data discovery, KPI development and powerful management reporting tools.

If you want to stop drifting and start learning Excel, you are in the right place. Welcome!

Class Curriculum

  Course Introduction
Available in days
days after you enroll

Frequently Asked Questions

Does the course show me how to build Excel Dashboards?
Yes, we have several lessons which include a time tested method for creating great dashboards over and over again.
Does the course teach about macros and automation?
Yes! There's a whole module on Automation which will help build your skills in VBA coding in Excel.
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
Can I just buy a portion of the program?
No. This is an all in one course, not a series of unconnected tactics.
What if I try the course, and I decide it isn’t right for me?
I stand by this course with a 100% money-back guarantee. With over 12,000 students,, I know the course works, so I can take on the risk myself. Try the entire course and decide if it’s right for you. However — and this is important — only join if you intend to follow the entire course. This course is not simply to consume information. It’s designed to drastically up skill you in Excel. If you ask for a refund, we will require you to show us you completed the work.
Do you have a payment plan?
Yes, we do. With our payment plan, Become an Excel Guru costs less than the price of an apple every day.
Can I Go through the course on my own schedule? What if I fall behind?
Don't worry — all of my courses come with lifetime access so you can take a break from the material if you’re out of town, on vacation, or just swamped for a few days. Interruptions happen, and your course will ALWAYS be here for you when you're ready.
Is this course right if I want to get a job in Excel development
All of my courses are designed to improve your Excel skills and enhance your career prospects. Becoming great at Excel isn't something that happens overnight, it takes practice and real world problem solving - just like learning a language. If you take my courses and engage with the private Facebook community challenges that I post, you will be well on the way to being ready for an Excel development role. Take the course, and build on your skills through experience to get the best results.
I can already use Excel, will this do anything for me?
I often ask potential students - 'show me how you would analyse 10,000 rows of badly organised data in Excel'. Could you join data sets, enhance the data with formulas, and analysis it using charts and pivot tables? Could you do it fast and without errors? For most, the answer is no, and that's what sets apart a great Excel user from just a good one. If you already know the basics, head straight for my 'Become an Excel Guru' course for the more advanced functionality.
Is this suitable for my version of Excel?
This course is suitable for Excel 2010, 2013 and 2016 for windows only. It is not suitable for Excel for Mac.

Get started now!