Excel Fast Forward: Advanced Levels 2 & 3

Boot Camp2 DaysVersion 365Official CPE Provider

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