Excel Level 2 – Intermediate

Objectives:

In this course, you will create advanced formulas, analyze data with functions and PivotTables, work with tables, visualize data with charts, use graphical objects and enhance workbooks.

​

Unit 1 Creating Advanced Formulas:

You will learn how to:

• Use range names in formulas and functions

• Use specialized functions.

​

Unit 2 Analyzing Data with Logical and Lookup Functions:

Priority Management will show you how to:

• Analyze data by using text, logical, lookup, date, and financial functions.

 

Unit 3 Organizing Worksheet Data with Tables:

You will learn how to:

• Create, format, and modify tables

• Use structured references, as well as the subtotal and database functions.

 

Unit 4 Visualizing Data with Charts:

You will learn how to:

• Create charts

• Modify and format existing charts

• Create a trendline and advanced charts.

 

Unit 5 Analyzing Data with PivotTables, Slicers, and PivotCharts:

You will learn how to:

• Create a PivotTable

• Filter data using slicers

• Analyze data using PivotCharts

 

Unit 6 Working with Graphical Objects:

You will learn how to:

• Insert, modify, layer, and group graphical objects

• Incorporate SmartArt into workbooks.

 

Unit 7 Enhancing Workbooks:

You will learn how to:

• Customize workbooks

• Manage themes

• Protect files

• Prepare a workbook for multiple audiences.