Get The
AI CERTs
LMS App
Unlock exclusive app-only features
Download App
×
Skip to main content
Microsoft Excel - Intermediate
0%
Previous
Course data
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
Next
Side panel
Categories
All categories
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
Home
Store
Store
Contact Us
Watch Demo
Log in
Categories
Collapse
Expand
All categories
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
Home
Store
Store
Contact Us
Watch Demo
Course info
Microsoft Excel - Intermediate
