Excel
Excel Level 2: Intermediate Functions & Features
Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.
CPE Eligible - 6.5 CPE credit hours. Visit /cpe for details.CPE page →
Course objective
Students will learn to sort and filter data, perform complex calculations and functions, and analyze data using PivotTables and charts.
Prerequisites
To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing spreadsheets in Excel. Knowledge of formulas and functions is also necessary (Sum, Min, Max, Average, If, and applying absolute referencing) to be successful in this class. Students can obtain this level of skill through our Level 1 course.
Course outline
Calculating Data with Advanced Functions
- Nesting Functions
- Use SUMIFS, COUNTIFS and AVERAGEIFS In Formulas
- Use New Functions MINIFS and MAXIFS
Organizing Worksheet Data with Tables
- Create and Modify Tables
- Format Tables
- Sort and Filter Data
- Calculate Data Using Table Functions
Using Lookup Functions
- Create and Use Named Ranges
- Manage Named Ranges
- VLOOKUP
- HLOOKUP
Presenting Data Using Charts
- Create and Modify Charts
- Recommended Charts
- New 365 Charts
- Incorporate Shapes in Charts
- Create Trendlines
Analyzing Data Using PivotTables and PivotCharts
- Create a PivotTable
- Filter Data Using Slicers
- Filter Data Using a Timeline
- Analyze Data Using PivotCharts
Customizing and Enhancing Workbooks
- Customize the Excel Environment
- Manage Themes
- Use Quick Analysis Tools