Excel 2019 PivotTables - Beyond the Basics

Course Overview

This course provides students with the information necessary to create and modify a PivotTable. Students will learn how to calculate, format, and filter within a PivotTable. Information is also included regarding PowerPivot, used for advanced analysis of a large dataset.

Who Should Attend

Moderate-advanced exposure to Excel is recommended for this course. Students do not need to have prior experience regarding PivotTables specifically, however the course does require moderate knowledge of Excel, since there is information regarding: conditional formatting, calculations, and filtering tools.

Course Objectives

The course is designed to provide students with information regarding PivotTables and PowerPivot. Students will learn to analyze and format data through the Pivot environment, as well as become accustom to the terminology and verbiage.

Course Outline

1 - Lessons

  • * Analyzing Data with PivotTables
  • * Working with Calculated Fields and Items
  • * Using Conditional Formatting in a PivotTable
  • * Creating Filter Pages in a PivotTable
  • * Working with the PowerPivot Add-In
  • * Linking Two Tables Using PowerPivot

Price: $49.95

Class times are listed Central time.

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time Where How
10/26/2020 8:00AM - 9:00AM Online LIVE LNL
11/06/2020 1:00PM - 2:00PM Online LIVE LNL
11/20/2020 8:00AM - 9:00AM Online LIVE LNL
12/08/2020 8:00AM - 9:00AM Online LIVE LNL
12/28/2020 1:00PM - 2:00PM Online LIVE LNL

Class times are listed Central time

This class is part of our LearnNow Pass. Click here for more details.