Excel Fast Forward (Session 2): Advanced Levels 2 & 3

Full Day1 DayVersion 365Official CPE Provider

Advanced Excel without the wait - Levels 2 and 3 combined into one faster-paced, hands-on session for confident users ready to level up. Available for private/group training only.

Course Objective

Students will cover the key topics from Excel Levels 2 and 3 at a faster pace, working with advanced functions, charts, PivotTables with slicers and timelines, and data tools such as advanced filters, what-if analysis, and Solver. (Available for private/group training only).

Prerequisites

To ensure your success, we recommend that you have experience with creating formulas, functions, and charts in Excel. Students can obtain this level of skill through our Excel Level 1 or the Fast Forward Session 1 course. This is a faster-paced class that combines two levels.

Course Outline

6 lessons · 24 topics

1Calculating with Advanced Functions

SUMIFS, COUNTIFS, AVERAGEIFS
XLOOKUP and VLOOKUP
Named Ranges
IF function – IFS
Nesting functions

2Presenting Data Using Charts

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

3Collaborating with Others

Protect Workbooks, Sheets, Cells
Share a Workbook
Review Tracked Revisions

4Analyzing Data Using PivotTables

Create a PivotTable
Filter Data Using Slicers
Filter Data Using a Timeline
Analyze Data Using Pivot Charts

5Data Tools

Group and Outline Data
Add Subtotals to a Worksheet
Create and Apply Advanced Filters

6Analysis Tools and Add-Ins

Conditional Formatting
Create Sparklines
Perform What-If Analysis
Solver

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