Inserting PivotTables in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 11 Videos | 31m 25s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 231 Likes 231
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting PivotTables Exercise as well as the associated materials in the Resources section.

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 in Excel 2019 for Windows
    4m 17s
    UP NEXT
  • Playable
    2. 
    Editing your PivotTable in Excel 2019 for Windows
    3m 9s
  • Locked
    3. 
    Formatting your PivotTable in Excel 2019 for Windows
    2m 33s
  • Locked
    4. 
    Copying & reusing your PivotTable in Excel 2019 for Windows
    2m 45s
  • Locked
    5. 
    Sorting data in your PivotTable in Excel 2019 for Windows
    2m 16s
  • Locked
    6. 
    Filtering your table data in Excel 2019 for Windows
    2m 47s
  • Locked
    7. 
    Using label & value filters in Excel 2019 for Windows
    3m 11s
  • Locked
    8. 
    Grouping data in your PivotTable in Excel 2019 for Windows
    2m 52s
  • Locked
    9. 
    Inserting a slicer in your PivotTable in Excel 2019 for Windows
    2m 10s
  • Locked
    10. 
    Customizing your slicer in Excel 2019 for Windows
    3m 5s
  • Locked
    11. 
    Using the Timeline in Excel 2019 for Windows
    2m 20s

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 294 Likes 294  
Likes 1627 Likes 1627