Skip to content
Write a review
UdemyExcelPaid courseIntermediate levelCertificate

Microsoft Excel 2021/365: Intermediate Level Training (Udemy.com)

Get more out of Microsoft Excel 2021/365 with our intermediate training course!

4.5
177 reviews

Created by: Simon Sez IT

Last updated March 2024

icon
What you will learn

  • Designing better spreadsheets and controlling user input
  • How to use logical functions to make better business decisions
  • Constructing functional and flexible lookup formulas
  • How to use Excel tables to structure data and make it easy to update
  • Extracting unique values from a list
  • Sorting and filtering data using advanced features and new Excel formulas
  • Working with date and time functions
  • Extracting data using text functions
  • Importing data and cleaning it up before analysis
  • Analyzing data using PivotTables
  • Representing data visually with PivotCharts
  • Adding interactions to PivotTables and PivotCharts
  • Creating an interactive dashboard to present high-level metrics
  • Auditing formulas and troubleshooting common Excel errors
  • How to control user input with data validation
  • Using WhatIf analysis tools to see how changing inputs affect outcomes.

How it compares

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

  • Rating4.5 out of 5higher than 39% of them
  • Reviews177#308 of 356 by number of reviews
  • Length11.4 hourslonger than 76% of them
  • Last updatedMarch 2024more recently than 51% of them

icon
Course Description

***Exercise and demo files included***


In this second installment of our Excel 2021 course series, you can expand your Excel foundation beyond what you’ve learned in the beginners’ course and take your skills up another notch.


During this course, you will create intermediate-level formulas, prepare data for analysis using PivotTables and PivotCharts, make use of WhatIf analysis tools, learn how to use validation rules to control data input, and explore the fundamentals of spreadsheet design.


And we are just getting started!


You will also get to discover all the new features and functions available in Excel 2021, the latest standalone version of Microsoft Excel.

Explore the exciting world of dynamic array functions and learn how to use XLOOKUP, XMATCH, FILTER, and so much more.


This Excel 2021 Intermediate course is designed for those with beginner-level knowledge of Excel who are looking to take advantage of the application’s more advanced features. It’s also suitable for individuals who have beginner to intermediate skills using an older version of Excel.


The only prerequisites for this course are beginner-level knowledge of Excel and a working copy of Excel 2021.


This course covers:

  • Designing better spreadsheets and controlling user input

  • How to use logical functions to make better business decisions

  • Constructing functional and flexible lookup formulas

  • How to use Excel tables to structure data and make it easy to update

  • Extracting unique values from a list

  • Sorting and filtering data using advanced features and new Excel formulas

  • Working with date and time functions

  • Extracting data using text functions

  • Importing data and cleaning it up before analysis

  • Analyzing data using PivotTables

  • Representing data visually with PivotCharts

  • Adding interactions to PivotTables and PivotCharts

  • Creating an interactive dashboard to present high-level metrics

  • Auditing formulas and troubleshooting common Excel errors

  • How to control user input with data validation

  • Using WhatIf analysis tools to see how changing inputs affect outcomes.


This course includes:

  1. 9+ hours of video tutorials

  2. 84 individual video lectures

  3. Course and exercise files to follow along

  4. Certificate of completion
Read More Intermediate Intermediate Level product length iconTime: 11.4h

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.

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.

icon
Instructor Details

Simon Sez IT

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 12,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 1 million Udemy students in over 190 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

Read More

icon
More courses by Simon Sez IT

$19.99

$14.99

$109.99

$174.99

$84.99

$84.99

All courses by Simon Sez IT

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.5

177 ratings on Udemy

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

Write a review

By Kaushik Biswas on 10/28/2025

Please have the option of zooming in/out on the video..Otherwise the course and the teaching is perfect.

By Glen A Tulloch on 9/11/2023

Very good match. This will allow me to spend my time doing other things using these short cuts to create and modify my Excel documents.

By Ofure on 8/29/2023

The course was very helpful and very detailed. However, there was no lecture to follow along with for 1 or 2 of the excel files

By Jason Flynn on 7/26/2023

I finally got the kind of tutorials I needed to become proficient at Excel!

By Rhys on 7/17/2023

This is a really good, in depth and content rich course. The instructor is very knowledgeable and a good teacher. The only drawback is that the exercises need to be more challenging and marked in a style similar to the quiz

By Suyog Katti on 6/27/2023

YES, it's a good course to learn more.

By Vickie Davis on 5/23/2023

Just talked about different thing and did help understanding what will happen.

By William Biermann on 4/25/2023

Extreamly helpfull for future use of excel to make tables and reports.

By Sidney Moshou on 4/25/2023

I really enjoyed the course; it was a real eye opener as I thought I understood Exel...

By George Peffer on 4/22/2023

Great match for me, it allows me to be better informed my audience on the data I want them to share with them.

Showing all 10 reviews on CourseDuck

Read all 177 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

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

Overall Score : 90 / 100

Microsoft Excel 2021/365: Intermediate Level Training
Visit course on Udemy Write a review
  • Video Duration: icon 11.4h
  • Price: $69.99
  • Provider: icon Udemy
  • Updated: icon March 2024
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com