Businesses need data to be compiled, analyzed, and presented visually to make informed decisions. This course builds on the basic concepts taught in Excel 2019 Level 1 and provides advanced tools for analyzing and presenting data. You’ll learn to manage workbooks, build complex functions, use data analysis tools, present data in a chart, and collaborate with others.

Performance Objectives: Upon completion of this course, you should be able to:

• Use named ranges in formulas.
• Use logic, date, and text functions.
• Analyze data with table functions.
• Create and modify charts.
• Use PivotTables to summarize and rearrange large amounts of data in a list.
• Use PivotCharts to present data.
• Use custom conditional formatting.
• Use Quick Analysis features to conveniently analyze data.

Prerequisite: We recommend you complete Excel 2019 Level 1 or have equivalent experience before registering for this course.

Intended Audience: All audiences.

Sales Tax Notice: Effective October 1, 2025 
In accordance with Washington State law (ESSB 5814), sales tax will be applied to all training services. In addition to the course cost, sales tax will be calculated based on your agency's location and added to your final invoice after the class is completed.