Inserting PivotTables

Excel 2019 (Windows)    |    Intermediate
  • 11 Videos | 47m 55s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 132 Likes 132
Excel includes powerful tools to summarize, sort, count, and chart data. In this 11-video course, you will learn how to create, edit, and format pivot tables, sort, filter, and group data, and work with slicers and timelines. Key concepts covered in this course include how to create and insert a PivotTable; how to edit the source data and field setup in a PivotTable; how to use predefined styles and formatting tools to change the appearance of a PivotTable; and how to copy and move a PivotTable within a workbook. Next, learn how to use sort tools to change the display of data; how to use filter tools to show and hide data; and how to use label and value filters to analyze data. Finally, learn how to use group tools to sort and analyze related data and use a slicer to filter data; examine how to customize the behavior and appearance of a slicer; and observe how to customize the behavior and appearance of a slicer.

WHAT YOU WILL LEARN

  • create a PivotTable
    edit a PivotTable
    format a PivotTable
    copy and move a PivotTable
    sort data in a PivotTable
    filter data in a PivotTable
  • use label and value filters
    group data in a PivotTable
    insert a slicer into a PivotTable
    customize a slicer in a PivotTable
    add a timeline to a PivotTable

IN THIS COURSE

  • Playable
    1. 
    Creating a PivotTable
    4m 17s
    UP NEXT
  • Playable
    2. 
    Editing your PivotTable
    3m 9s
  • Locked
    3. 
    Formatting your PivotTable
    2m 33s
    FREE ACCESS
  • Locked
    4. 
    Copying & reusing your PivotTable
    2m 45s
    FREE ACCESS
  • Locked
    5. 
    Sorting data in your PivotTable
    2m 16s
    FREE ACCESS
  • Locked
    6. 
    Filtering your table data
    2m 47s
    FREE ACCESS
  • Locked
    7. 
    Using label & value filters
    3m 11s
    FREE ACCESS
  • Locked
    8. 
    Grouping data in your PivotTable
    2m 52s
    FREE ACCESS
  • Locked
    9. 
    Inserting a slicer in your PivotTable
    2m 10s
    FREE ACCESS
  • Locked
    10. 
    Customizing your slicer
    3m 5s
    FREE ACCESS
  • Locked
    11. 
    Using the Timeline
    2m 20s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Working with Data in PivotTables
Likes 46 Likes 46  
COURSE Getting Started
Likes 561 Likes 561  
BOOK Microsoft Excel Functions and Formulas: With Excel 2019 / Office 365, Fifth Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Inserting & Manipulating Data
Likes 886 Likes 886  
COURSE Getting Started with Excel for Office 365
Likes 1408 Likes 1408  
COURSE Using Basic Formulas
Likes 704 Likes 704