Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

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

Overview

This advanced Excel training course aims to help learners fast-track their Excel skills to an expert level by introducing new dynamic array functions, advanced Excel formulas, and functions like XLOOKUP and XMATCH. The course covers topics such as dealing with spills in arrays, sorting functions, advanced filtering, creating lookup formulas, using statistical functions, and more. The teaching method includes practical exercises with downloadable files for hands-on practice. This course is intended for individuals looking to enhance their Excel proficiency and master advanced Excel features and functions.

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

Start your review of Microsoft Excel Advanced Excel Training Course

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.