Creating PivotTables & PivotCharts in Excel 2016 for Windows

IN THIS COURSE

• 1.  Creating a PivotTable in Excel 2016 for Windows
  3m 52s
  A PivotTable can be used to reanalyze data that has been inserted into your table. Excel 2016's PivotTable 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.  Creating a PivotTable with multiple data tables in Excel 2016 for Windows
  4m 24s
  A new feature introduced in Excel 2016 is the ability to create PivotTables that combine values from a variety of different data sources within your workbook. This allows you to reuse data found in distinct tables in your spreadsheet file, like you would with a database. To do this, however, you will need to know how to create relationships between your tables. FREE ACCESS
• 3.  Editing your PivotTable in Excel 2016 for Windows
  3m 37s
  Excel 2016'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
• 4.  Formatting your PivotTable in Excel 2016 for Windows
  5m 18s
  If you want to improve the appearance of your PivotTable, you can change its formatting settings. In Excel 2016, 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
• 5.  Copying & reusing your PivotTable in Excel 2016 for Windows
  4m 40s
  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. You can copy and paste your PivotTables as much as you want in Excel 2016. FREE ACCESS
• 6.  Inserting a calculation in your PivotTable in Excel 2016 for Windows
  4m 20s
  As well as standard data fields, your Excel 2016 PivotTables can also be modified to display calculated fields. These are fields that are created using existing data and a calculation method. In this way, you can create new data fields in your PivotTable without having to modify your original data table. FREE ACCESS
• 7.  Sorting data in your PivotTable in Excel 2016 for Windows
  2m 55s
  Excel 2016's PivotTables can be used to cross-reference different data values. You can also use the fields that you have inserted to sort your data values. You can even add a special filter field, which is based on different criteria and can be used to control the data that is being visualized in your PivotTable. FREE ACCESS
• 8.  Filtering your table data in Excel 2016 for Windows
  4m 50s
  In Excel 2016, it's easy to filter your data. The filtering tool will display your data in a table view with drop-down columns allowing you to choose to filter from among any of the data values that appear in each column. FREE ACCESS
• 9.  Grouping data in your PivotTable in Excel 2016 for Windows
  4m 48s
  Another useful way of sorting and organizing your data in your Excel 2016 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
• 10.  Inserting a slicer in your PivotTable in Excel 2016 for Windows
  4m 24s
  A slicer is a special filter tool offered by Excel 2016. 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
• 11.  Customizing your slicer in Excel 2016 for Windows
  3m 43s
  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 2016, you can change your slicer's style and appearance using a variety of different formatting tools. FREE ACCESS
• 12.  Comparing values in a PivotTable in Excel 2016 for Windows
  3m 32s
  In Excel 2016, you can change the way in which you compare the values in your PivotTable. You can visualize your values in percentages, as a difference, and you can even sort and recalculate your data in chronological order. FREE ACCESS
• 13.  Inserting a PivotChart in Excel 2016 for Windows
  3m 43s
  A PivotChart is a visual representation of the data contained in your PivotChart. This makes it extremely flexible and easy to modify. You can use the PivotChart tool in Excel 2016 to push the analysis of your original data even further. FREE ACCESS
• 14.  Modifying your PivotChart in Excel 2016 for Windows
  4m 56s
  PivotCharts are extremely customizable. In Excel 2016, you can change a number of different elements in your chart, including its style, color theme, and its label settings. FREE ACCESS
• 15.  Analyzing your database tables in a PivotChart in Excel 2016 for Windows
  6m 39s
  If you have already created a database in Access, you can import your data tables into Excel 2016. This is a great time saver, as it means you can not only take advantage of the data that has already been collected, but also reuse the existing relationships that have already been added to your tables. Once you have imported your database tables, you can use Excel 2016 to visualize any existing relationships, and begin building your reports. FREE ACCESS