Working with Data in PivotTables in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 8 videos | 28m 44s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.3 of 206 users Rating 4.3 of 206 users (206)
Once your Excel PivotTables have been created, you will need to know how to manage and work with the data contained within. In this 8-video course, learners will learn how to analyze, calculate, collaborate, and more with Excel PivotTables. Key concepts covered in this course include how to use a PivotTable to find trends and drill into data, adding extra levels of detail and multiple value fields in a single table; how to use the Data Model to work with data from multiple tables; and how to import existing database tables into the Data Model and use them in a PivotTable. Next, learners will examine how to add Calculated fields that use already inserted data; how to use the Value field settings to work with values for comparison calculations; and how to see data from a PivotTable in a PivotChart then customize and format the PivotChart. Finally, because a PivotTable is highly customizable, you will observe how to configure and customize a PivotTable's display and control settings. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Data in PivotTables Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • Analyze data in a pivottable
    Work with multiple data tables in a pivottable
    Import database tables into the data model and use them in a pivottable
    Use calculations in a pivottable
  • Compare values in a pivottable
    Insert a pivotchart
    Modify a pivotchart
    Configure a pivottable

IN THIS COURSE

  • 3m 57s
    Once you know how to create a PivotTable and add fields, you can begin analyzing your data and looking for trends. See how to organize your fields appropriately, add levels of detail to drill into data, and insert multiple value fields in a single table. FREE ACCESS
  • 4m 24s
    If you want to work with data from different tables, you will need to add them to the Data Model in your workbook. Once this is done, you will need to know how to create, edit, and manage relationships between fields, in order to get the data values working together. FREE ACCESS
  • Locked
    3.  Analyzing your database tables in a PivotTable in Excel 2019 for Windows
    3m 54s
    In Excel, you can pull in data from external sources, such as an Access database, and analyze it in a PivotTable. This allows you to reuse data and take advantage of field relationships that already exist in the database. FREE ACCESS
  • Locked
    4.  Using calculations in your PivotTable in Excel 2019 for Windows
    3m 40s
    In Excel, you can insert calculated items and fields which use data already in the PivotTable. This is useful if the calculations you wish to perform are not in the source data table. FREE ACCESS
  • Locked
    5.  Comparing values in a PivotTable in Excel 2019 for Windows
    3m 5s
    You can adjust how you work with values in your PivotTable, by changing the summary calculation or applying a comparison. When comparing values and totals, you can visualize data ranked, as a percentage, or as a difference. FREE ACCESS
  • Locked
    6.  Inserting a PivotChart in Excel 2019 for Windows
    3m 44s
    Data that has been organized into a PivotTable can be presented more visually in a PivotChart. You can create a PivotChart from scratch, or convert data already in a PivotTable. Once the PivotChart has been created, you can manipulate data using the PivotChart and PivotTable controls. FREE ACCESS
  • Locked
    7.  Modifying your PivotChart in Excel 2019 for Windows
    2m 37s
    All the standard Excel chart tools can be used to modify and format your PivotChart. You can change the chart type without recreating the PivotTable, apply different chart styles and layouts, and customize individual chart elements with the formatting tools. FREE ACCESS
  • Locked
    8.  Configuring your PivotTable in Excel 2019 for Windows
    3m 22s
    Your PivotTable is highly customizable. The PivotTable options can be used to change how null data values and errors are displayed, customize which data controls are active and visible in your table, and even ensure that you are working on the most recent information by telling Excel to refresh the data every time you open your workbook. 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

Course Working with Excel Tables in Excel 2019 for Windows
Rating 4.4 of 1076 users Rating 4.4 of 1076 users (1076)
Course Working with tables in Excel 365
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Course Adding & arranging data in Excel 365
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course PL-300: Power BI for Data Analysis
Rating 4.5 of 1379 users Rating 4.5 of 1379 users (1379)
Course Finding & Analyzing Information with Formulas in Excel 2019 for Windows
Rating 4.5 of 297 users Rating 4.5 of 297 users (297)
Course Working with Different Chart Styles in Excel 2019 for Windows
Rating 4.5 of 446 users Rating 4.5 of 446 users (446)