Scheduled dates
No public dates scheduled yet
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 outline
Calculating with Advanced Functions
- SUMIFS, COUNTIFS, AVERAGEIFS
- XLOOKUP and VLOOKUP
- Named Ranges
- IF function – IFS
- Nesting functions
Presenting Data Using Charts
- Create and Modify Charts
- Recommended Charts
- New 365 Charts
- Incorporate Shapes in Charts
- Create Trendlines
Collaborating with Others
- Protect Workbooks, Sheets, Cells
- Share a Workbook
- Review Tracked Revisions
Analyzing Data Using PivotTables
- Create a PivotTable
- Filter Data Using Slicers
- Filter Data Using a Timeline
- Analyze Data Using Pivot Charts
Data Tools
- Group and Outline Data
- Add Subtotals to a Worksheet
- Create and Apply Advanced Filters
Analysis Tools and Add-Ins
- Conditional Formatting
- Create Sparklines
- Perform What-If Analysis
- Solver