Inserting PivotTables

Excel 2019 (Windows)
  • 11 Videos | 31m 25s
  • 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 Managing Data
Likes 75 Likes 75  
COURSE Adding Data to Presentations
Likes 25 Likes 25  
COURSE Creating & Saving Workbooks
Likes 74 Likes 74  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Using Basic Formulas
Likes 704 Likes 704  
COURSE Working with Excel Tables
Likes 206 Likes 206  
COURSE Using Basic Formulas
Likes 146 Likes 146