In Excel 2016, you should use Excel tables to summarize, store, and combine your data for use in dashboards and other presentations.
- [Presenter] Your first step in creating…a dashboard in Microsoft Excel, should be…to store your data in the most efficient…and flexible manner possible.…In Excel 2016, you should use Excel tables…to summarize, store, and combine your data…for use in dashboards and other presentations.…In this movie, I will show you how to lay out your data…so that it can be turned into an Excel table,…and then show you how to create the table itself.…My sample file is the Excel table workbook,…and you can find it in the chapter one folder…of the exercise files collection.…
I have created a data list, and you can see…that is has a couple of characteristics.…The first is that the first row,…which is row one of the worksheet, contains headers.…These headers indicate the data…that is stored within each of the columns.…So we have the year, the quarter the month, to room type,…in this case we're looking at a hotel, and revenue.…Again, each column contains a single type of data,…where each row contains a full set of data.…
So for example, the first row of data,…
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