Skip to main content
Microsoft Excel - Advance
0%
Previous
Course data
Module 1
1.1 Introduction to Advance Excel 2021 Features
Module 2
2.1 Dynamic Arrays
2.2 Introduction to Spills and Arrays
2.3 Extract and Count Unique Entries
2.4 Unique vs Distinct
2.5 Unique with Multiple Criteria
2.6 Extract Unique Values by Column
2.7 The Sort Function
2.8 The SORTBY Function
2.9 Horizontal SORTBY
2.10 SEQUENCE and Unstacking Records
2.11 Using RANDARRAY and RENDBETWEEN to Randomize Data
2.12 Using XLOOKUP to perform complex Lookups
2.13 Using XMATCH
Module 3
3.1 Two-Way Lookups
3.2 Using the CHOOSE Function
3.3 Using the SWITCH Function
Module 4
4.1 Using MEDIAN, MODE.SNGL, and MODE.MULT
4.2 Ranking Data Using RANK.EQ and RANK.AVG
4.3 The COUNTBLANK Function
Module 5
5.1 Rounding Values - ROUND, ROUNDUP, and ROUNDDOWN
5.2 Specialized Rounding
5.3 Using the AGGREGATE Function
Next
Side panel
Categories
Search
Search categories
All categories
AI CERTs
AI CERTs- LAN
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
ANAB
AI CERTs-Spanish
MS ELearning
Other Category
Other Category - LAN
Eduman
MS Elearning - Russel
V3 - Russel
AICERTs- Extended E-Learnin...
Russian Course
Qazaq Course
Home
Store
Store
Store
Store
Contact Us
Watch Demo
Search
Search
Search
Search
Close
Toggle search input
Log in
Email
Email
Password
Password
Forgot your password?
Log in
Categories
Collapse
Expand
All categories
AI CERTs
AI CERTs- LAN
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
ANAB
AI CERTs-Spanish
MS ELearning
Other Category
Other Category - LAN
Eduman
MS Elearning - Russel
V3 - Russel
AICERTs- Extended E-Learnin...
Russian Course
Qazaq Course
Home
Store
Store
Store
Store
Contact Us
Watch Demo
Course info
Microsoft Excel - Advance
