Inserting PivotTables in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 11 videos | 31m 25s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 853 users Rating 4.5 of 853 users (853)
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 pivottable
    Edit a pivottable
    Format a pivottable
    Copy and move a pivottable
    Sort data in a pivottable
    Filter data in a pivottable
  • Use label and value filters
    Group data in a pivottable
    Insert a slicer into a pivottable
    Customize a slicer in a pivottable
    Add a timeline to a pivottable

IN THIS COURSE

  • 4m 17s
    A PivotTable can be used to reanalyze data that has been inserted into your table. Excel's PivotTable tool is extremely flexible and can be modified in a variety of different ways to extract previously-unseen patterns and trends in your data. FREE ACCESS
  • 3m 9s
    Excel's PivotTables are extremely customizable. You can change the different fields that have been added and change the calculations that are performed. You can also update your PivotTable to ensure that it uses the most recent data from the original table. FREE ACCESS
  • Locked
    3.  Formatting your PivotTable in Excel 2019 for Windows
    2m 33s
    If you want to improve the appearance of your PivotTable, you can change its formatting settings. In Excel, you can change your PivotTable's style, color settings, and even the font that is used for your data values and field names. FREE ACCESS
  • Locked
    4.  Copying & reusing your PivotTable in Excel 2019 for Windows
    2m 45s
    Once you have created your PivotTable, you can move it, copy it, and reuse it. Once you have created a copy of your PivotTable, you can modify it as you see fit. FREE ACCESS
  • Locked
    5.  Sorting data in your PivotTable in Excel 2019 for Windows
    2m 16s
    Excel's PivotTables can be used to sort the data values you are analyzing. You can use the automatic sorting tools, drag and drop labels, and sort your data by value. FREE ACCESS
  • Locked
    6.  Filtering your table data in Excel 2019 for Windows
    2m 47s
    The values in your PivotTable can be filtered in many different ways, depending on the data that you are working with. You can use the standard filter tools to show or hide particular values, select and hide groups of values, and even define a field that will serve as the table's filter when setting up your PivotTable. FREE ACCESS
  • Locked
    7.  Using label & value filters in Excel 2019 for Windows
    3m 11s
    When filtering data, you can choose between label and value filters. Label filters allow you to show and hide data based on the label associated with data values, while value filters can be used to analyze the actual values associated with your table's entries. FREE ACCESS
  • Locked
    8.  Grouping data in your PivotTable in Excel 2019 for Windows
    2m 52s
    Another useful way of sorting and organizing your data in your Excel PivotTable is to create data groups. You can, for example, group your data by month, year or category. You can also choose to temporarily hide data that is not required, helping you to concentrate on what matters in your table. FREE ACCESS
  • Locked
    9.  Inserting a slicer in your PivotTable in Excel 2019 for Windows
    2m 10s
    A slicer is a special filter tool offered by Excel. It can be used to adjust the data that is visible in your PivotTable. It can also allow you to identify quickly the data filters that are currently applied. You can also use multiple slicers to gradually filter out the data that is not required for the task at hand. FREE ACCESS
  • Locked
    10.  Customizing your slicer in Excel 2019 for Windows
    3m 5s
    If you use PivotTables and in particular slicers on a frequent basis, then you may find it useful to know how to customize these tools. In Excel, you can change your slicer's style and appearance using a variety of different formatting tools. FREE ACCESS
  • Locked
    11.  Using the Timeline in Excel 2019 for Windows
    2m 20s
    The Timeline tool is a great way of working with dates in your PivotTable. It's dynamic, and like a slicer, gives you a clear visual of how you are working with your data and what will be displayed. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 487 users Rating 4.5 of 487 users (487)
Rating 4.6 of 213 users Rating 4.6 of 213 users (213)
Rating 4.4 of 1076 users Rating 4.4 of 1076 users (1076)