fbpx

Excel Level 4 – Advanced Functions


Learning Method: Instructor-led Classroom Duration: .5 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
    • HLOOKUP
    • VLOOKUP
    • XLOOKUP
    • INDEX
    • INDIRECT
    • LOOKUP
    • MATCH
    • OFFSET
    • XMATCH
  • Logical
    • AND
    • OR
    • IFNA
    • XOR
    • IFERROR
    • NESTED IF’s, AND, OR
  • Math
    • SUMIF
    • SUMIFS
  • Other
    • AVERAGEIF
    • ROUND
    • ISNUMBER
    • SUBSTITUTE
Site Loader
Facebook
YouTube
LinkedIn