top of page

Public workshops are available, and private group training sessions are available for all our courses.

PriorityTech Logo
Excel Logo

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.

bottom of page