Working with Data in PivotTables in Excel Microsoft 365 for Windows
Excel Microsoft 365 (Windows)
| Intermediate
- 8 videos | 29m 48s
- Includes Assessment
- Earns a Badge
Explore ways to analyze data for trends by using a PivotTable in Excel for Office 365, in this 8-video course, which demonstrates how to organize fields, add extra levels of detail to data, and to insert multiple value fields in a single table. You will observe how to use a data model to pull data from multiple tables and build a relational data source inside a workbook. This course demonstrates how to pull data from external sources, for example, an Access database, and analyze it in a PivotTable. You will learn to insert calculated fields that use already inserted data in the PivotTable. You will also learn how to change a summary calculation or apply a comparison in a PivotTable, and how to visualize data rank as a percentage or as a difference. You will learn how to create a new PivotChart or convert already inserted data in a PivotTable. Finally, you to use PivotTable options to change how null data values and errors are displayed.
WHAT YOU WILL LEARN
-
Use a pivottable to find trends and drill into data
Use the data model to work with data from multiple tables
Import existing database tables into the data model and use them in a pivottable
Add calculated items and calculated fields to a pivottable -
Use the value tools to and summary and comparison calculations
Visualize data from a pivottable in a pivotchart
Customize and format a pivotchart
Configure and customize a pivottable's display and control settings
IN THIS COURSE
-
4m 10sOnce 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 41sIf 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
-
3. Analyzing your database tables in a PivotTable in Excel Microsoft 365 for Windows3m 56sIn 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
-
4. Using calculations in your PivotTable in Excel Microsoft 365 for Windows3m 22sIn 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
-
5. Comparing values in a PivotTable in Excel Microsoft 365 for Windows3m 16sYou 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
-
6. Inserting a PivotChart in Excel Microsoft 365 for Windows4m 5sData 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
-
7. Modifying your PivotChart in Excel Microsoft 365 for Windows2m 55sAll 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
-
8. Configuring your PivotTable in Excel Microsoft 365 for Windows3m 24sYour 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.
