Inserting PivotTables

Excel Microsoft 365 (Windows)    |    Intermediate
  • 11 Videos | 34m 5s
  • Includes Assessment
  • Earns a Badge
Likes 238 Likes 238
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 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

IN THIS COURSE

  • Playable
    1. 
    Creating a PivotTable
    4m 33s
    UP NEXT
  • Playable
    2. 
    Editing your PivotTable
    3m 31s
  • Locked
    3. 
    Formatting your PivotTable
    2m 46s
    FREE ACCESS
  • Locked
    4. 
    Copying & reusing your PivotTable
    3m 22s
    FREE ACCESS
  • Locked
    5. 
    Sorting data in your PivotTable
    2m 22s
    FREE ACCESS
  • Locked
    6. 
    Filtering your table data
    3m 2s
    FREE ACCESS
  • Locked
    7. 
    Using label & value filters
    3m 26s
    FREE ACCESS
  • Locked
    8. 
    Grouping data in your PivotTable
    3m 6s
    FREE ACCESS
  • Locked
    9. 
    Inserting a slicer in your PivotTable
    2m 21s
    FREE ACCESS
  • Locked
    10. 
    Customizing your slicer
    3m 9s
    FREE ACCESS
  • Locked
    11. 
    Using the Timeline
    2m 28s
    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 Formatting cells and ranges in Excel 365
Likes 5 Likes 5  
COURSE Getting started in Excel 365
Likes 1 Likes 1  
COURSE Ten common tools in Excel 365
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Getting to Know Macros in Excel
Likes 210 Likes 210  
COURSE Inserting PivotTables
Likes 231 Likes 231  
COURSE Getting Started
Likes 809 Likes 809