UdemyExcelPaid courseAll LevelsCertificate

Microsoft Excel 2010: Advanced Training (Udemy.com)

Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training

4.4

2,521 reviews

Created by: Infinite Skills

Last updated January 2017

Our take

Based on the ratings of 2,521 students and a sample of their written reviews. No course pays to be reviewed.

This is Infinite Skills' follow-up to their beginner Excel 2010 course, built for people who already know their way around a spreadsheet and want to go further. Across 136 lectures and 8.3 hours, the instructor works through nested IF statements, AVERAGEIF and SUMIF, VLOOKUP and HLOOKUP, sparklines, pivot tables and charts, and recording macros. Working files are included so students can follow along in their own copy of Excel. It's not aimed at anyone who has never opened a spreadsheet before.

Reviewers consistently praise how clearly the lookups and formulas are explained, and one reviewer said VLOOKUP finally clicked for her at work. The step-by-step pacing and included files get repeated credit. The complaints cluster in a few spots: a handful of reviewers call the content intermediate rather than advanced, the macros lecture skips creating a macro with buttons, and a few working files were misnamed. One reviewer needed a few lectures to adjust to the instructor's accent.

The course was last refreshed in 2017 and still teaches Excel 2010, so anyone on a current Office subscription will notice outdated menus and missing modern features. At 4.4 stars across 2,521 ratings it holds up well for what it promises: a calm, example-heavy tour of intermediate-to-advanced formulas and pivot tables. Worth it for shoring up specific skills like lookups and pivot tables, less so for anyone chasing Excel's newest tools.

Best forExcel users past the basics who want lookups, pivot tables, and macros explained slowly

Skip it ifYou're on a current Excel version and want screens and features that match it

Pros

Clear walkthroughs of VLOOKUP, HLOOKUP, and nested IF formulas that reviewers say stuck
Downloadable working files let students practice alongside every lesson
Breaks pivot tables, sparklines, and macros into small, easy-to-follow steps
136 lectures across 8.3 hours cover a wide spread of intermediate-to-advanced tools

Cons

Built on Excel 2010 and last updated in 2017, so it looks dated next to current versions
Several reviewers call it intermediate rather than truly advanced material
The macros lecture skips button-based macro creation some students wanted

This course is very well explained. but would not recommend this to a beginner but to someone who is more familiar with excel and wants to take their knowledge to the next level.

German Correa, a student

Labeled "All Levels" but really suits students who already know basic Excel and named ranges.

What you will learn

Learn Advanced Microsoft Excel 2010 from a professional trainer from your own desk.
136 lectures (8.5 hours of content) teaching you lookups, advanced IF statements, Macros, Sparklines, and much more!
Suitable advanced Excel users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

How it compares

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

Rating4.4 out of 5higher than 25% of them
Reviews2,521#98 of 356 by number of reviews
Length8.3 hourslonger than 63% of them
Last updatedJanuary 2017earlier than 90% of them

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 88 / 100

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this Excel course.

This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software.

Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

This advanced Excel video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same Excel files the author trains you with.

All Levels

Time: 8.3h

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.

Get the Udemy discount

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

Instructor Details

Infinite Skills

4.4 Rating
2,521 Reviews

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.