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
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 - Intermediate
