Microsoft Excel - Beginner to Advanced (Udemy.com)

Learn Pivot Tables, Formulas, Charts, Data Analysis, Dashboards, VBA, Macros & More for Excel 2010, 2013 or Excel 2016

Created by: Martyn Blythin

Produced in 2021

icon
What you will learn

  • Learn the most useful functions in Excel used in business
  • Learn to analyse large data sets with Pivot Tables
  • Learn to wow your boss with great looking management dashboards
  • Learn how to automate away boring repetitive tasks using VBA & Macros
  • Access to a Professional Trainer with 12+ years of Excel Training
  • Get your CV/Resume ready to impress on your next job application

icon
Quality Score

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

Overall Score : 90 / 100

icon
Course Description

Just imagine what it would feel like if using Excel was effortless - if you could create charts, functions, and analyse data with ease. Becoming great at Excel isn't about learning what every button and every formula does - it's about learning methods you can use over and over again to effortlessly clean, enrich and analyse data.
I bet your a bit like me, you've tried learning through trial and error, but it takes a long time and involves a lot of mistakes along the way! I've been using Excel for over 15 years and there's still a few functions I've never used. The good news is that you can become great at Excel in just a few hours by learning the right tools and approaches to use. How would it feel to have those skills on your resume and at your next job interview?
So, you want to learn Excel but you don't want to overwhelm yourself with stuff you're never going to use and you need the skills for your job, or the next job you hope to get. As I see it, you have three options. First, you could take a classroom based course and try to learn it all in a day, but from experience I know many people who have just been overwhelmed with the amount of information and the pace of learning. Second, you could do absolutely nothing, stay exactly where you are right now with your Excel skills. Or third, you could give this a try, work it alongside your current job and be genuinely good at Excel within a week or two.
We designed this course using feedback received from over 25,000 students over years who told us they wanted opportunities to test their Excel skills. This course has it all, including:
  • Downloadable challenges to test your knowledge.
  • Multiple choice quizzes at the end of each module.
  • Each lesson has a downloadable Excel file containing the examples used.
  • Cheat sheets for functions & keyboard shortcuts that you can have at your desk for reference.
  • Ask me any Excel question on the course message boards.
  • A certificate of completion at the end of the course.
The course covers all levels, from beginner to advanced, so you don't have to worry about if the course is right for you, and you don't have to buy multiple courses for each level of your Excel knowledge! The course is split into 6 core modules:
  • Module 1: Master The Basics
  • Module 2: Your Data Gameplan
  • Module 3: Your Functions Toolkit
  • Module 4: Your Data Analysis Strategy
  • Module 5: Your Dashboard Playbook
  • Module 6: Your Excel Automation Machine
The course also comes with everything you'd expect from a great online course, including:
  • Lifetime access to the material
  • Unlimited free updates to the course
  • 30 day money back guarantee
If you're prepared to give this a try, then we're certain you will see the results as early as the first day you try it.

Here is what students said about this Excel course:
"Love the tips. Best practices quite relevant and to be kept in mind. Also, there are quizzes to test your understanding of the previous lessons as well as links to the lectures for the answers that you missed. I love this course. Highly recommended!"
- Mary J. de Guzman

"This is a really great course. He started at what I would definitely consider an intermediate level--and I even learned some things during that part--and then took us well into the advanced usage of Excel, as promised. Martyn was also very responsive, answering in-depth questions I had, even when they were beyond the scope of the course."
- Randy Crane

"Thoroughly enjoyed the course as it was very well paced. Bite-sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. Martyn also reverts back quickly if you have a question or suggestion."
- Kaushal VyasWho this course is for:
  • This course will take your Excel skills from beginner to advanced level
  • This Microsoft Excel courses will take you through 4 of Microsoft Excel topics (Data, Analysis, Presentation & Automation).

icon
Instructor Details

placeholder

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..
If you want to stop drifting and start learning Excel, you are in the right place. Welcome!

icon
More courses by Martyn Blythin

Microsoft Excel - Getting Started With The Basics

$11.99

icon
Reviews

4.5

96 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

Material was as described, presented in simple, direct language with good examples.

This course was helpful as to usage of every day project. I really got a lot our of it.

I do have a lot of experience in Excel, but there were many thing which i have learned were so damn time save thanks to this tutorial , every aspect are show in details. good job.

I enjoyed this course, found it clear and broad; however, I had hoped for a more advanced course with more detail about VBA and dashboards. Regardless, this gave a great overview of some intermediate to advanced functionality.

Not instructor's fault as I knew most of this already.... If you work in an office where you can ask someone or are will to search on MS Help, most of this is available.... the data analysis, formula choices and graphing section is where I'll save my honest, useful feedback as an engineer who really needs this.

Course is clear and very well structured, the only suggestion is to zoom in the video shot for students to view more easily.

The teacher is great!. I am spaniard and I could understand perfectly his english.

A very to the point and informative course, highly recommended .

Thoroughly enjoyed the course as it was very well paced. Bite sized yet providing clear concise detailed instructions that I could follow the activities in a separate local spreadsheet and learn by doing. Good clarity in speech and good examples help. Martyn also reverts back quickly if you have a question or suggestion.

The content is just what i'm looking for. However, it is not made easy to actually learn this content. This could be improved significantly by: a)making the data available to play with alongside the video b) exercises set to help embed the knowledge c) more 'real life' problems to be solved

Very, VERY good crash course on more advanced functionality one can get out of Excel.

The more automation that you can add in the better for the course. However, this is an excellent brush up on skills or to grow a solid base of skills in excel.