Learning Method: Instructor-led Classroom Duration: 1.0 Day
*Click here to view upcoming Excel Level 4 classes
Overview:
Excel has many tools and functions that help you analyze data to make decisions having large-scale implications on profitability, sales, operations, project management, credit, and so on. In this course, you will use the advanced functions of Microsoft Office Excel to attain a high degree of proficiency as an Excel power user.
Who Should Attend:
This course is designed for advanced Microsoft Office Excel professionals who would like to learn more advanced functions.
At Course Completion:
Upon successful completion of this course, students will be able to use some of the most popular Excel advanced functions.
Prerequisite(s) or equivalent knowledge: Excel Level 1, Excel Level 2, Excel Level 3
Course Outline:
- Lookup & Reference
- LOOKUP
- HLOOKUP
- VLOOKUP
- XLOOKUP
- INDEX
- MATCH
- OFFSET
- XMATCH
- Logical
- AND
- OR
- IFERROR
- IFNA
- XOR
- Nested IF’s, AND, OR
- Math
- SUMIF
- SUMIFS
- AVERAGEIF
- AVERAGEIFS
- Other
- ROUND
- ISNUMBER
- ISTEXT
- SUBSTITUTE
- PROPER
- TRIM
- RIGHT
- TEXT
