Description
Excel Level 3 is a one-day instructor-led class that provides an in-depth and hands-on experience using Microsoft Excel’s more advanced functions and formulas to perform complex calculations. Data manipulation is a key competency today making this level a must-take for any Excel user. Upon successful completion of this course participants will be able to manipulate large data sets more quickly and easily using a variety of advanced functions and formulas. With the ability to summarize data efficiently using the consolidate and subtotals features.
Logical & Lookup Functions
- IF, AND, OR, NOT, IFS
- Nesting
- VLOOKUP, HLOOKUP, XLOOKUP
Date/Time & Text Functions
- TODAY, NOW, YEAR, MONTH, WEEKDAY, EOMONTH, EDATE, WORKDAY, NETWORKDAYS
- Time Calculations
Text Functions
- CONCATENATE, TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID, FIND, LENGTH
- Flash Fill
Reference Functions
- MATCH, INDEX, OFFSET, CHOOSE
Statistical & Financial Functions
- SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS
- PMT
Advanced Formulas
- Formula Auditing
- IFERROR
- Formula Options
- Watch Window
Summarizing Data
- Consolidating Data
- Generating Subtotals