Excel 365 – Insert PivotTable reports

Overview 

This 11-clip course provides students with an in-depth exploration of using pivot tables in Excel for Office 365. Pivot tables are highly customizable and can be used to extract patterns and trends that you may have missed in your data. learn how to create a pivot table and how to modify it to change which fields were inserted and to change the calculations. Then you’ll learn how to improve the look of your pivot table by changing your style, color settings, and fonts. This course demonstrates how to use automatic sorting tools, how to place labels, and how to sort data by value. You will examine the filters in Excel and how label filters can be used to show or hide data based on labels associated with data values. You’ll notice how to use slicers to filter and manipulate data in a pivot table, which provides a clear visual guide to the contents of the table. Finally, you will learn how to use the Timeline tool to work with the data in the pivot table.

Objectives

• Insert a PivotTable
• Edit source data and place fields in a PivotTable
• Use default styles and formatting tools to change the look of a PivotTable
• Copy and move a PivotTable to a workbook
• Use sorting tools to change the display of data in a pivot table
• use of filtering tools to show and hide data in a pivot table
• use of label and value filters to analyze data in a pivot table
• use of tools grouping to sort and analyze related data in a pivot table
• using a slicer to filter data in a pivot table
• customizing the function and appearance of a slicer
• using timeline