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® 2019: Getting Started with PivotTables and PivotCharts (PVPC)

Choose CPE Format:

Self-Study SELECT STARTING AT $79 (On Demand)

Downloadable PDF

Credits: 4

Qualifies For:

$79
Buy Now

Textbook

Credits: 4

Qualifies For:

$139
Buy Now
Reviews Not Available.

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.

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

  • Customer Rating
    Reviews Not Available.
  • Field of Study
    Technology
  • Level
    Intermediate
  • Credits
    4.0
  • Qualifies for

    CPE

Overview

This course 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
• Identify ways to modify a PivotChart using Pivot Field buttons, a shortcut menu, the Field List, and buttons on the PivotChart Tools Design tab

Designed for:

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

Prerequisite:

Experience working with Excel 2019 in the Windows operating system environment

Advanced Preparation:

None

Interested in bringing this course into your firm?

PRIVATE WEBINARS AND LIVE ON-SITE COURSES ARE AVAILABLE. LEARN MORE.
loading

Loading...

Loading...

Thank You!

YOU HAVE ADDED THE FOLLOWING TO YOUR CART:

GO BACK
CHECK OUT NOW

Loading...

Thank You!

Thank You! Your request has been submitted.



Get more with an unlimited CPE subscription

Unlimited Plus

     

  • Unlimited access to ALL live CPE webinars, including premium courses

  • Unlimited 24/7 access to on-demand webcasts and self-study PDF courses

  • Includes select gamified CPE courses from Surgent Interactive

  • Access for a year from date of purchase

  • Auto-renew locks in your price for next year (can cancel any time)

  • Does NOT include select+ courses

$899

 BUY NOW 

Unlimited Webinars

  • Unlimited access to all non-premium live CPE webinars

  • Includes 1, 2, 3, 4 and 8 CPE sessions

  • Access for a year from purchase date

  • Auto-renew locks in your price for next year (can cancel any time)

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses and select* courses

$749

 BUY NOW 

 


Unlimited Self-Study

  • Unlimited 24/7 access to 250+ downloadable PDF courses

  • Courses range from 1-20 credits

  • Access for a year from date of purchase

  • Auto-renew locks in your price for next year (can cancel any time)

  • Provides online grading & CPE certificates by email

  • Does NOT include Premium courses and select^ courses

$549

 BUY NOW 

 


+Excludes: ETDE, AFTR, ETTX, Certification Courses, and select Surgent Interactive games (MTT2, MTT4, MTT5, MTT6, MTT7, SAU1, SAU2, SAU4, SAU5, SAU6, BDV1, and RPA1)

*Excludes Premium Webinars & Ethics for Delaware (ETDE)

^Excludes: ETDE, ETTX, AFTR, Certificate Courses, and Interactive Games

 

Explore additional courses by topic

  • Accounting and Auditing CPE courses

    Accounting &
    Auditing

  • Business and Industry CPE courses

    Business &
    Industry

  • Ethics CPE courses

    Ethics

  • Financial Planning CPE courses

    Financial
    Planning

  • Fraud and Forensics CPE courses

    Fraud &
    Forensics

  • Government and Non-Profit CPE courses

    Government/
    Non-Profit

  • Personal Development CPE courses

    Personal
    Development

  • Practice Management CPE courses

    Practice
    Management

  • Taxes CPE courses

    Taxes

  • Tech CPE courses

    Tech

 

Qualifies for

CFP CFP® Board-approved CE for Certified Financial Planners


CMA IMA-approved CE for Certified Management Accountants

CPE NASBA-approved CPE for Certified Public Accountants


CTEC California Tax Education Council-approved CE

IRS IRS-approved CE for Enrolled Agents and the AFSP


YB GAO-fulfilling Yellow Book audit requirements

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.