Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Microsoft Excel Advanced Excel Training Course

Simon Sez IT via YouTube

Start learning Write review
TrainSec Ad

Learn EDR Internals: Research & Development From The Masters

Learn More → GetSmarter Ad

AI Adoption - Drive Business Value and Organizational Impact

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Elevate your Microsoft Excel 2021/365 skills to an advanced level with this comprehensive 3.5-hour tutorial. Master dynamic array functions, spill handling, and advanced formulas like XLOOKUP and XMATCH. Learn to differentiate between Unique and Distinct, utilize various sort functions, and implement advanced filtering techniques. Explore creating flexible lookup formulas, employing statistical functions for data ranking, and calculating MEDIAN and MODE. Practice with downloadable exercise files to reinforce your learning. Navigate through topics such as array manipulation, advanced sorting and filtering, lookup functions, data analysis, and specialized rounding techniques. Perfect for those seeking to enhance their Excel proficiency and streamline complex data management tasks.

Syllabus

- Introduction
- Exercise 01
- Dynamic Arrays
- Spill and Arrays
- Extract and Count Unique Entries
- Unique vs. Distinct
- Unique with Multiple Criteria
- Unique Values by Column
- SORT Function
- Horizontal Sort
- SORTBY Function
- Horizontal SORTBY
- Sequence and Unstacking Records
- Filter Function
- Using Filter with Logic Plus Operator
- Using Filter with Logic Asterisk Operator
- Using Filter with Logic Equals Operator
- Using Filter with Logic Minus Operator
- RANDARRAY and RANDBETWEEN
- XLookUp
- XMatch
- Exercise 02
- Two-way Lookups
- CHOOSE Function
- SWITCH Function
- Exercise 03
- Median and Mode
- Using LARGE and SMALL
- Ranking Data
- COUNTBLANK Function
- Exercise 04
- Rounding Values
- Specialized Rounding
- Aggregate Function
- Exercise 05

Taught by

Simon Sez IT

Reviews

4.0 rating, based on 1 Class Central review

Start your review of Microsoft Excel Advanced Excel Training Course

  • Profile image for Lalita Sutar
    Lalita Sutar
    “This Advanced Excel course is very useful. The instructor explains concepts clearly with practical examples. I learned formulas, data analysis, and Excel tools that are helpful for academics and internships. A good course for students who want to improve Excel skills.”
Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.