Course details

Excel Office 365 (Windows): Inserting PivotTables

Excel Office 365 (Windows): Inserting PivotTables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.6

Lesson Objectives

Excel Office 365 (Windows): Inserting PivotTables

  • insert a PivotTable
  • edit the source data and field setup in a PivotTable
  • use predefined styles and formatting tools to change the appearance of a PivotTable
  • copy and move a PivotTable within a workbook
  • use sort tools to change the display of data in a PivotTable
  • use filter tools to show and hide data in a PivotTable
  • use label and value filters to analyze data in a PivotTable
  • use group tools to sort and analyze related data in a PivotTable
  • use a Slicer to filter data in a PivotTable
  • customize the behavior and appearance of a Slicer
  • customize the behavior and appearance of a Slicer
  • Course Number:
    ds_msex365_16_enus

    Expertise Level
    Intermediate