Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Microsoft® Excel® 365/Excel® 2019: Getting Started with PivotTables and PivotCharts (PVPC)

  • Format Self-Study Download
  • Credits 4.00
  • Level Intermediate
  • Field of Study Computer Software & Applications (Non-Technical) (4)

Overview

Microsoft® Excel® 365/Excel® 2019: Getting Started with PivotTables and PivotCharts is a two-lesson advanced level course that guides you through creating, formatting, and modifying PivotTables and PivotCharts in Excel using step-by-step hands-on activities.



Major Topics:

Use the PivotTable button to create a PivotTable
Use the Recommend PivotTables button to create a PivotTable
Use the Quick Analysis feature to create a PivotTable
Use the Summarize as PivotTable button with the Data Model to create a PivotTable
Format the PivotTable values using a shortcut menu
Change the PivotTable layout using the PivotTable Tools Design tab
Rearrange, hide and show subtotals and grand totals using the PivotTable Tools Design tab
Apply a PivotTable style using the PivotTable Tools Design tab
Refresh a PivotTable using the PivotTable Tools Analyze tab or keyboard shortcut
Filter a PivotTable using the filtering arrows
Modify the PivotTable structure using the Field List
Filter a PivotTable using slicers
Add a calculated field to a PivotTable using the PivotTable Tools Analyze tab
Modify the Value Field Settings using a shortcut menu
Use the PivotChart button to create an embedded PivotChart
Use the standard Excel charting buttons to create a PivotChart
Use a keyboard shortcut to create a PivotChart on its own chart sheet
Create a PivotChart and linked PivotTable simultaneously
Add or remove chart elements using the Chart Elements button
Change the chart style and color scheme using the Chart Styles button
Change the chart layout using the PivotChart Tools Design tab
Select and format individual chart elements using the PivotChart Tools Format tab
Filter the PivotChart using the Pivot Field buttons
Change the chart type and subtype using a shortcut men
Add, remove, and reposition the PivotChart fields using the Field List
Switch the row/column orientation using the PivotChart Tools Design tab


Learning Objectives:

Select different methods to create a PivotTable including the PivotTable button, Recommended PivotTables button, the Quick Analysis feature, and the Summarize with PivotTable button and Data Model,
Recognize multiple ways to format a PivotTable using a shortcut menu and buttons on the PivotTable Tools Design tab,
Identify ways to modify a PivotTable using buttons on the PivotTable Tools Analyze tab, a keyboard shortcut, the filtering arrows, the Field List, slicers, and a shortcut menu,
Select different methods to create a PivotChart including the PivotChart button, standard Excel charting buttons, a keyboard shortcut, and simultaneously with the PivotTable,
Recognize multiple ways to format a PivotChart using the Chart Elements and Chart Styles buttons, buttons on the PivotChart Tools Design and Format tabs, task panes, a shortcut menu, and
Identify ways to modify a PivotChart using Pivot Field buttons, a shortcut menu, the Field List, and buttons on the PivotChart Tools Design tab.


Who should take this course:

Users experienced with using Excel 365 and Excel 2019 who want to grow their Excel skills.

The following Napier & Rivers courses (or equivalent experience working with Excel 365 or Excel 2019 in the Windows operating system environment) are prerequisites for this course: Microsoft® Excel® 365/Excel® 2019: Getting Started with Excel, or Micros

None

No

No

No

QAS Approval Surgent IRS Approval Surgent CFP Approval Surgent CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.