Get The
AI CERTs
LMS App
Unlock exclusive app-only features
Download App
×
Salta al contenido principal
Microsoft Excel - Advance
0%
Anterior
Datos del curso
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
Siguiente
Panel lateral
Categories
Todas las categorías
AI CERTs
AI CERTs- LAN
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
AI CERTs-Spanish
ANAB
MS ELearning
Other Category
Other Category - LAN
Eduman
MS Elearning - Russel
V3 - Russel
AICERTs- Extended E-Learnin...
Russian Course
Qazaq Course
AI CERTs - Arabic
AI CERTs - French
Agent X
AI CERTs - Bengali
AI CERTs - Portuguese
ATP
AI CERTs - Chinese
AI CERTs - Azerbaijani
AI CERTs - Turkish
AI CERTs - German
AI CERTs - Indonesian
CFF
Self Paced Vimeo
AI CERTs - Italic
Test
Página Principal
Store
Store
Store
Contact Us
Watch Demo
Español - Internacional (es)
English (en)
Español - Internacional (es)
Acceder
Categories
Colapsar
Expandir
Todas las categorías
AI CERTs
AI CERTs- LAN
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
AI CERTs-Spanish
ANAB
MS ELearning
Other Category
Other Category - LAN
Eduman
MS Elearning - Russel
V3 - Russel
AICERTs- Extended E-Learnin...
Russian Course
Qazaq Course
AI CERTs - Arabic
AI CERTs - French
Agent X
AI CERTs - Bengali
AI CERTs - Portuguese
ATP
AI CERTs - Chinese
AI CERTs - Azerbaijani
AI CERTs - Turkish
AI CERTs - German
AI CERTs - Indonesian
CFF
Self Paced Vimeo
AI CERTs - Italic
Test
Página Principal
Store
Store
Store
Contact Us
Watch Demo
Información del curso
Microsoft Excel - Advance
