Inserting PivotTables in Excel 2019 for Windows

IN THIS COURSE

• 1.  Creating a PivotTable in Excel 2019 for Windows
  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
• 2.  Editing your PivotTable in Excel 2019 for Windows
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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