Get The
AI CERTs
LMS App
Unlock exclusive app-only features
Download App
×
Salta al contenido principal
Microsoft Excel - Intermediate
0%
Anterior
Datos del curso
Module 1
1.Intermediate MS EXCEL Course Introduction
Module 2
2.1 Improve Readability with Cell Styles
2.2 Controlling Data Input
2.3 Adding Navigation Buttons
Module 3
3.1 Logical Functions
3.2 IF Function
3.3 Nested Ifs
3.4 IFS Function
3.5 Conditional IFS Functions
3.6 Multiple Criteria Formulas
3.7 Error Handling IFERROR IFNA
Module 4
4.1 Looking Up Information with VLOOKUP
4.2 Horizontal Information With HLOOKUP
4.3 Performing Flexible Lookups with INDEX and MATCH
4.4 Using XLOOKUP and XMATCH
4.5 OFFSET Function
4.6 INDIRECT Function
Module 5
5.1 Sorting MultiColumns
5.2 Sorting Using Custom List
5.3 SORT and SORTBY Functions
5.4 Advanced Filter Excel Tutorial
5.5 Filter Function
Module 6
6.1 Understanding Dates and Times
6.2 Custom Date Time Formats
6.3 WORKDAY and WORKDAY INTL Functions
6.4 NETWORKDAYS and NETWORKDAYS INTL
6.5 Dates Difference using DATEDIF
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 - Intermediate
