Inserting PivotTables

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
    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 Illustrating Documents
Likes 83 Likes 83  
COURSE Manipulating PivotTable data in Excel 365
COURSE Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE Getting to Know Macros in Excel
Likes 210 Likes 210  
COURSE Referencing Data
Likes 123 Likes 123