Skip to content
#4 in Office ProductivityUdemyExcelPaid courseAll LevelsCertificate

Microsoft Excel 2016 Beginners & Intermediate Excel Training (Udemy.com)

Excel for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you

Created by: 365 Careers

Last updated January 2026

Our take

Based on the ratings of 25,971 students, a sample of their written reviews and the syllabus, as the course stood in January 2026. No course pays to be reviewed.

A short 365 Careers course, about three and a half hours across 74 lectures, that takes a complete beginner through Excel basics, best-practice tips, keyboard shortcuts, the core functions, charts, and finishes with building a Profit & Loss statement from scratch. The title says Excel 2016, and the requirements list 2010 to 2016, but the content was last refreshed in January 2026. It suits students and junior finance or business staff who need to be competent quickly, not people chasing every advanced feature.

Reviewers like the bite-size videos and say the lessons are easy to follow and remember. One reviewer singles out the IF functions and keyboard shortcuts as the parts they will actually use at school or work, and others mention the shortcuts and time-saving tricks. The teaching gets credit for explaining concepts clearly, with downloadable Excel files to work alongside. The complaints are consistent: it moves quickly. One two-star review asks the instructor to slow down or freeze the screen, another says their head was spinning, and one found the test material covered more than they could hold onto even with detailed notes. Expect to pause and rewind.

With nearly 26,000 reviews and a 4.6 average, this is a well-trodden path, and the vast majority of ratings are four or five stars. It is a short course, and the same list includes a beginner-to-advanced Excel title that aims further, which is either a selling point or a limitation depending on the goal. Pick it for the essentials plus one real finance-flavored project in an afternoon. Anyone after Copilot or AI features will find the neighboring courses cover them.

Best forStudents and junior finance or business staff who want Excel essentials fast, with one real P&L project at the end.
Skip it ifYou already know VLOOKUP and pivot tables, or you want Copilot and AI features covered alongside Excel.

Pros

  • Short, bite-size lectures that reviewers say are easy to follow and remember
  • Ends with building a full P&L statement from scratch, a real finance task
  • Covers IF functions, shortcuts and charts; one reviewer says the shortcuts will help at school and work
  • Refreshed in January 2026 with downloadable Excel files and five quizzes

Cons

  • Moves fast; reviewers say they had to pause and rewind, or retake it, to keep up
  • Only about 3.4 hours, so it stops well short of advanced Excel despite the All Levels label
  • Title and requirements are pinned to Excel 2010 through 2016; newer versions are not mentioned
I enjoy the bite size videos. They are easy to follow and remember.
Matome Phaleng, a student

Marketed as all levels, but it really suits beginners and light intermediates; confident Excel users will find little new.

icon
What you will learn

  • Work comfortably with Microsoft Excel 2016 and many of its advanced features
  • Learn what is new in Excel 2016
  • Be much quicker at carrying out regular tasks
  • Become your team's go-to-guy when it comes to Excel
  • Use sophisticated functions that will improve the quality of your work

Course content

9 sections · 74 lectures · 3.4 hours of video 5 quizzes, 1 assignment, 4 articles

  1. 1Welcome! Course Introduction 1 free preview3 lectures · 1 quiz · 6 min
  2. 2A Quick Introduction to the Basics of Excel 2 free previews10 lectures · 1 quiz · 33 min
  3. 3Assignment 11 quiz
  4. 4Excel Best Practices: Useful Tips & Tools 1 free preview19 lectures · 1 quiz · 35 min
  5. 5Keyboard Shortcuts in Excel1 lecture · 5 min
  6. 6Excel Functions 1 free preview16 lectures · 1 quiz · 53 min
  7. 7Create Professional Charts in Microsoft Excel 20167 lectures · 16 min
  8. 8Build a Complete P&L from Scratch 2 free previews16 lectures · 1 quiz · 43 min
  9. 9Practical Exercise - SUMIFS2 lectures · 9 min

Who it is for

The instructor says it suits

  • Beginner, Intermediate and Advanced users who want to be proficient in Excel

What you need before you start

  • Install Microsoft 2016, 2013 or 2010
  • No previous knowledge is required!
  • Great for students who want to learn at their own pace

How it compares

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

  • Rating4.6 out of 5higher than 63% of them
  • Reviews25,971#21 of 356 by number of reviews
  • Length3.4 hoursshorter than 72% of them
  • Last updatedJanuary 2026more recently than 72% of them

icon
Quality Score

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

Overall Score : 92 / 100

icon
Course Description

Do you want to learn how to work with Excel?

Even if you don’t have any prior experience?

You want to become very good at Excel?

If so, then this is the right course for you!

*A verifiable certificate of completion is presented to all students who complete this course.*

Microsoft Excel is the greatest productivity software the world has seen so far.

However, it’s essential that you learn how to work with it effectively.

But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?

Microsoft Excel Beginners & Intermediate Excel Training is here for you. One of the best Excel courses online, this training includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will help you grow as a professional.

What makes this course different from the rest of the Excel courses out there?

  • High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)

  • Knowledgeable instructor (3 million Udemy students, working experience in Big 4 Consulting and Coca-Cola)

  • Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)

  • Extensive case studies that will help you reinforce everything that you’ve learned

  • Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer

  • Dynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole course

Why is Microsoft Excel so important?

Every company on the planet uses this software, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.

Here are 5 more reasons why you should take this course and learn Excel:

  • Jobs. A solid understanding of Excel opens the door for a number of career paths

  • Promotions. Top Excel users are promoted very easily inside large corporations

  • Secure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemployment

This course is suitable for people with no previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel charts, and other tools that are often used for the purposes of financial modeling.

Additionally, the course includes practical case studies that will reinforce everything you learn. One of the exercises we will see in the course consists of building a complete Profit & Loss statement from scratch.

This training is highly recommended for university students, entry-level finance, business and marketing professionals who would like to grow faster than their peers.

Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why hesitate to offer such a guarantee when we are confident the training will be immensely valuable to you?

Buy the course today and let's start this journey together!

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

365 Careers

365 Careers is the #1 best-selling provider of business, finance, data science and AI courses on Udemy. The company’s courses have been taken by more than 4,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings.    

Currently, 365 focuses on the following topics on Udemy:    1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA

2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics, Data literacy, Product Management, Pandas, Numpy, Python Programming, Data Strategy

3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing

4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook

icon
More courses by 365 Careers

$139.99

$199.99

$19.99

$19.99

$159.99

$199.99

icon
Reviews

4.6

25,971 ratings on Udemy

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

By Darcey Sawtelle on 7/10/2026

very informative but has a large amount of information to be tested on which I did struggle with even though I took Detailed notes

By Amya DaCosta on 7/9/2026

I appreciated the material in the course. Though, I came in with a general understanding of how to use excel, the course explained things I never would have thought to research. It was very informative to learn about the functions with "if", the clear button and overall, the operations of the ribbon tab. I think the notes I took along with the keyboard shortcuts will help me perform more efficiently when using excel for school or future careers.

By Kenneth Khalo on 6/23/2026

The Excel course was a great learning experience. I learned the basics of Excel, including useful tips and tools, Keyboard shortcuts and various Excel functions.

By Anonymized User on 6/23/2026

Yes, I'm learning but my head is spinning. I will need to take this course over and over to catch everything.

By Matome Phaleng on 5/19/2026

I enjoy the bite size videos. They are easy to follow and remember.

By Wari Renagi on 2/22/2026

In my own experience it has been helpful in my learning journey and off course yes, it's quite difficult to but very rewarding.

By Jack Gooch on 2/10/2026

It has been very informative. I'm glad to learn many of these tricks and shortcuts to save time in Excel and I am hopeful that I will be able to use them in the future.

By Zhixiong Cai on 2/9/2026

The design of this course is unique: brief but to the point, very effective in learning. Thank you!

By Teah Aldridge on 2/4/2026

The course was very informative and easy to follow. It is a lot of information to digest but, for me personally, if I were to have Excel open along side the training to apply what I'm learning I would definitely be able to get things done. From there it's repetition to help it all stick. I enjoyed the printable resources as well! I find having reference material is incredibly helpful as I may remember a concept but not the detailed steps.

By Russell Tendai Chivavaya on 11/27/2025

The course is very insightful - from the basics to a bit complex function. Looking forward to the Advanced version of this. Keep up the Great Work!!

Showing all 10 reviews on CourseDuck

Read all 25,971 reviews on Udemy