You can greatly extend the capability of Excel tables by creating pivot tables and pivot charts, which allow you to rearrange and summarize your data quickly.
- [Instructor] Excel tables let you store…and summarize your data in a flexible and efficient manor.…You can greatly extend the capability of Excel tables…by creating pivot tables and pivot charts.…Which allow you to rearrange and summarize…your data quickly.…In this movie I will show you how to create…pivot tables and pivot charts.…My sample file is the create pivot Excel workbook.…Which you can find in the chapter one folder…of your exercise files collection.…Excel tables are the best way to store data…for use in pivot tables.…One reason for that is that your data is well organized,…and you know that it's in columns or rows as they should be,…and also one other aspect of working with an Excel table…is that if you add or remove rows of data,…then the pivot table will reflect that…the next time it's updated.…
If you work with a standard data range,…which is entirely possible,…you would need to go in and update…the data source definition.…The range of cells that contain the data.…With Excel tables, the next time you refresh,…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Managing data using Excel tables
- Managing PivotTables and PivotCharts
- Summarizing table and PivotTable data
- Defining conditional formats
- Creating sparklines
- Sketching your dashboard layout
- Creating and managing cell links
- Linking cell contents to a shape
- Linking to a PivotTable cell
- Extending your dashboard using hidden rows