fbpx

Excel 4 – Advanced Functions


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
Site Loader
Facebook
YouTube
LinkedIn
/* var _ctct_m = "d452c33da950900a678d1ac1fe8b4a0a"; */