If you have little to no Excel experience or looking for a smooth refresher, then our Excel courses are for you. You will learn the essential basic and intermediate formulas and functions of Microsoft Excel via a Fortune 500 case study.
Beginner’s Microsoft Excel
- Workbooks vs. Worksheets
- Cell References
- Formatting
- Basic Math Operations
- Excel Basics
Intermediate Microsoft Excel: Logic Statements
- Cell References
- IF Statements
- Nested IF Statements
- ISNA and IFERROR
Intermediate Microsoft Excel: Aggregate Logic Statements
- Cell References
- SUMIF(s)
- AVERAGEIF(s)
- COUNTIF(s)
Intermediate Microsoft Excel: Vlookup
- Cell References
- Vlookup
- Index & Match
Microsoft Excel: Pivot Tables
- The Pivot Table Quadrant
- Slicers
- Calculated Fields
- Pivot Charts
- Formatting and Sorting
Microsoft Excel: Visualization
- Reviewing different charts and graphs types
- Utilization of Dynamic Charts and Graphs