Businesses need data to be compiled, analyzed, and presented visually to make informed decisions. This course builds on the basic concepts taught in Excel 2016-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 2016-2019 Level 1 or have equivalent experience before registering for this course.

Intended Audience: All audiences.