Excel Fast Forward (Session 2): Advanced Levels 2 & 3
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.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
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
- SUMIFS, COUNTIFS, AVERAGEIFS
- XLOOKUP and VLOOKUP
- Named Ranges
- IF function – IFS
- Nesting functions
- Create and Modify Charts
- Recommended Charts
- New 365 Charts
- Incorporate Shapes in Charts
- Create Trendlines
- Protect Workbooks, Sheets, Cells
- Share a Workbook
- Review Tracked Revisions
- Create a PivotTable
- Filter Data Using Slicers
- Filter Data Using a Timeline
- Analyze Data Using Pivot Charts
- Group and Outline Data
- Add Subtotals to a Worksheet
- Create and Apply Advanced Filters
- Conditional Formatting
- Create Sparklines
- Perform What-If Analysis
- Solver