Excel Level 2: Intermediate Functions & Features

Level 2Full Day1 DayVersion 365Official CPE Provider · 6.5 CPE hours

Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.

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

6 lessons · 23 topics

1Calculating Data with Advanced Functions

Nesting Functions
Use SUMIFS, COUNTIFS and AVERAGEIFS In Formulas
Use New Functions MINIFS and MAXIFS

2Organizing Worksheet Data with Tables

Create and Modify Tables
Format Tables
Sort and Filter Data
Calculate Data Using Table Functions

3Using Lookup Functions

Create and Use Named Ranges
Manage Named Ranges
VLOOKUP
HLOOKUP

4Presenting Data Using Charts

Create and Modify Charts
Recommended Charts
New 365 Charts
Incorporate Shapes in Charts
Create Trendlines

5Analyzing Data Using PivotTables and PivotCharts

Create a PivotTable
Filter Data Using Slicers
Filter Data Using a Timeline
Analyze Data Using PivotCharts

6Customizing and Enhancing Workbooks

Customize the Excel Environment
Manage Themes
Use Quick Analysis Tools

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals