Inserting PivotTables
Excel Microsoft 365 (Windows)
| Intermediate
- 11 Videos | 34m 5s
- Includes Assessment
- Earns a Badge
This 11-video course provides learners with an in-depth exploration of how to use PivotTables in Excel for Office 365. PivotTables are highly customizable and can be used to extract patterns and trends that you may have initially missed in your data. You will learn how to create a PivotTable, and to modify it to change which fields have been inserted, and change the performing calculations. Next, you will learn to improve the appearance of your PivotTable by changing the style, color settings, and the fonts. This course demonstrates how to use the automatic sorting tools, drag and drop labels, and to sort your data by value. You will examine filters in Excel, and how label filters can be used to show and hide data based on the label associated with data values. You will observe how to use slicers to filter and manipulate data in a PivotTable, which provides a clear visual guide to the table's contents. Finally, you will learn to use the Timeline tool to work with dates in your PivotTable.
WHAT YOU WILL LEARN
-
insert a PivotTableedit the source data and field setup in a PivotTableuse predefined styles and formatting tools to change the appearance of a PivotTablecopy and move a PivotTable within a workbookuse sort tools to change the display of data in a PivotTableuse filter tools to show and hide data in a PivotTable
-
use label and value filters to analyze data in a PivotTableuse group tools to sort and analyze related data in a PivotTableuse a Slicer to filter data in a PivotTablecustomize the behavior and appearance of a Slicercustomize the behavior and appearance of a Slicer
IN THIS COURSE
-
1.Creating a PivotTable4m 33sUP NEXT
-
2.Editing your PivotTable3m 31s
-
3.Formatting your PivotTable2m 46s
-
4.Copying & reusing your PivotTable3m 22s
-
5.Sorting data in your PivotTable2m 22s
-
6.Filtering your table data3m 2s
-
7.Using label & value filters3m 26s
-
8.Grouping data in your PivotTable3m 6s
-
9.Inserting a slicer in your PivotTable2m 21s
-
10.Customizing your slicer3m 9s
-
11.Using the Timeline2m 28s
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.