Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Complete Excel Mastery: Microsoft Excel Beginner to Advanced (Udemy.com)

Master Microsoft Excel quickly & easily. Microsoft Excel beginner to Excel pro - Excel 2010, Excel 2013, Excel 2016, 365

Created by: Steve McDonald

Last updated October 2021

icon
What you will learn

  • Feel confident using Excel in the workplace.
  • Be able to create and navigate Excel spreadsheets.
  • Be able to create tables, charts, pivot tables and more.
  • Use all of the most common formulas and functions.
  • Use keyboard shortcuts and productivity hacks to get more done faster.
  • While I can't make promises, my goal is to help you get the raise, promotion, or new job that you deserve.

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.5 out of 5higher than 39% of them
  • Reviews1,553#138 of 356 by number of reviews
  • Length13.3 hourslonger than 82% of them
  • Last updatedOctober 2021earlier than 64% of them

icon
Course Description

Welcome to my BIGGEST, most complete, Microsoft Excel course ever!

Excel is one of the most important skills in today's job market. Having a solid working knowledge of Excel can improve your job performance, help you qualify for raises and promotions, or even help you land that new job that you deserve.

If you need to know Excel, you're in the right place. 

This course walks you through Excel from the very basics of opening Excel all the way to advanced Excel skills used by the pros, like pivot tables and macros.

My goal with this course is to give you the skills you need to get that raise, promotion, or new job you deserve.

This course was created using Excel 2016, but it is good for versions 365, 2019, 2013 and 2010, as well. It was created for use with a PC (personal computer). Mac (Macintosh) users can still benefit from this course, but the course doesn't cover Mac-specific keyboard shortcuts and interface.

We'll start at the very beginning, with opening and saving a worksheet in Excel. 

I'll show you what all the tools do and walk you through each Excel skill that you need to know.

I'll show you how to enter and format your data and how to create charts, tables and pivot tables so you can organize and analyze your data. I'll teach you amazing keyboard shortcuts to make your work faster and more productive. You'll learn how to record macros so you can do a whole series of actions with the just click of a button.

We'll keep going until you're a pro at Excel. When you finish this course, you'll know more than most people who use Excel at their job every day.

Here's some of what you'll learn.

  • Creating spreadsheets in Excel

  • Saving your work where you can find it

  • Working with multiple workbooks in Excel

  • Formatting and printing

  • Importing data from CSV files, Access and the web

  • Creating and using formulas and functions like: Vlookup, Index/Match, If statements and dozens of others

  • Creating charts including: Bar charts, Line charts, Column charts, Pie charts and more

  • Creating tables

  • Sorting and filtering your data

  • Creating pivot tables

  • Creating pivot charts from your pivot tables

  • Fun New features for Excel

  • Keyboard shortcuts to make your work go faster

  • How to record basic macros to automate repetitive tasks

  • A whole lot more

The course comes with a certificate of completion, a full 30-day money back guarantee, and I'm always available to answer questions or share additional resources if you get stuck.

Thanks for checking out my biggest Excel course ever!

I'll see you in there!

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Steve McDonald

Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. 

My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. 

I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand.

I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.

I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.

I'm always happy to help.  I believe in you, and I'm here to support you in your learning process.

icon
More courses by Steve McDonald

$24.99

$12.99

$79.99

Free

Free

$10.99

icon
Reviews

4.5

1,553 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Ann Ebere Odunze on 11/2/2022

Wow!!! This course is an eye opener. I have always prided myself about my supposedly great knowledge in Excel not knowing I hadn't even scratched the surface. This course is worth every penny and time. And the instructor takes it all. Very clear explanations and detailed descriptions.

By Stuart on 3/10/2021

A lot of the shortcuts are different for Excel 365 2016 on Mac. Also a few functions detailed in the courses are completely unavailable on Mac. In the course description it stated you could "get by" with this course for Mac but I feel like that is a bit of a stretch as I have spent a lot of extra time searching for the equivalent Mac shortcuts and functions. Content is great but I would have been better served with a Mac specific course and would have chosen one if it had not been for the fore-mentioned description statement.

By Ayanda Ndlovu on 12/8/2020

I enjoyed taking this course very much! I liked how the lecturer broke down every detail and explained everything in a practical and detailed manner. I would definitely recommend it to anyone who has little knowledge of Excel and those who want to improve their Excel skills.

By Mahfoud toubal on 6/24/2020

this course was great, i learned quite a lot, the instructor spoke clearly and concicely, the complete ribbon overview was a fantastic idea, i think some begginers might find the nested formula section a bit too difficult, seems like it was rushed, but other than that, this course really good.

By Ghanem Bouriba on 2/17/2020

This is the first long course I've ever finished in about a week of continuous learning, so I can testify that the instructor has a very amazing method to explain concept by simplifying or (demystifying) them as he says :), I've reached a very developed mature level of understanding on how to use excel even on things I already said I know, like for ex: some features of savings in file tab. Thank you so much instructor, I hope to see you on LinkedIn too.

By Isaac Sistual on 10/5/2019

yes! I give the course a rating of 4.5 out of 5.0. I recommend it for you to buy it. The price is very affordable. I especially like where the instructor goes through the complete walk-through of all the tabs in the ribbon. I hope thousands more people buy the course.

By Indraneel Mukherjee on 2/15/2019

I started this course with an expectation to master the advanced excel concepts as I have been looking for a course which meant for absolute beginners and by the end of the course, one is all ready to use the concepts in real time scenario. And guess what ?? This course met all my expectations, I am very happy with the way the course has been designed and structured. Thank you, "Steve", for sharing your knowledge with us and helping us in adding new skills in our life.

By Mirza Hyder Baig on 12/9/2018

Thanks man for creating this comprehensive Excel Course....... 1) It covers almost every topic required for professionals working on Excel. 2) Instructor is guiding the ways to use Udemy platform such that even new user can find the best way to learn e.g., the way to download resources, opening of tabs and simultaneously work in the excel sheets and of course best ways of approaching this specific course. 3) Instructor has added draft Excel sheets(in resources) so that students can download and directly work on them while watching the videos. Saved a hell lot of time. 4) Language is clear. 5) Short & sweet lectures without compromising the content. As of now I have completed more than half of the course and I am thoroughly satisfied.

By Raghwendra Singh on 8/18/2018

First the negatives: Midway between the course, the audio becomes hoarse for some lectures and is unpleasant to listen to. Some of material are covered twice. Now the good things: This is the best course I've come across for Excel! The structure is good and you can follow along with provided materials. Even though I knew some of the commands and functions, I learnt something new about them. My favorite sections were the Nested Functions and The Complete Walk-through. Even when he doesn't go into details of some functions he would give a summary which is always helpful. Neglecting the minor inconvenience, this course has earned my five stars.

By Anonymized User on 11/12/2017

A very detailed course that is well presented by Steve the instructor. There are many downloadable Excel files that you can use to work along with the lectures, making it much easier to learn as you progress through the course. Recommended.

Very nice.

yes I'm a beginner and when I tried self teaching without any excel training it was a disaster! LOL

Showing 12 of 102 reviews

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100