Inserting PivotTables
Excel 2019 (Windows)
| Intermediate
- 11 Videos | 31m 25s
- Includes Assessment
- Earns a Badge
- CPE
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 PivotTableedit a PivotTableformat a PivotTablecopy and move a PivotTablesort data in a PivotTablefilter data in a PivotTable
-
use label and value filtersgroup data in a PivotTableinsert a slicer into a PivotTablecustomize a slicer in a PivotTableadd a timeline to a PivotTable
IN THIS COURSE
-
1.Creating a PivotTable4m 17sUP NEXT
-
2.Editing your PivotTable3m 9s
-
3.Formatting your PivotTable2m 33s
-
4.Copying & reusing your PivotTable2m 45s
-
5.Sorting data in your PivotTable2m 16s
-
6.Filtering your table data2m 47s
-
7.Using label & value filters3m 11s
-
8.Grouping data in your PivotTable2m 52s
-
9.Inserting a slicer in your PivotTable2m 10s
-
10.Customizing your slicer3m 5s
-
11.Using the Timeline2m 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.