Join Gini von Courter for an in-depth discussion in this video Restore missing data, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] A lot of the data that we work with in Excel…is tabular data, database data.…Lists of customers.…Information about memberships.…In this case, what we have is a sales report,…and when we're looking at tabular data,…what distinguishes it is that we have columns…that organize the information and we have rows,…and each row is what would be a record in a database…or in a list.…Excel has some special tools that it attaches to tables,…and it has some requirements for how tables are constructed.…
For example, we have a table here that's a summary table,…and if I click any cell in that table and choose…Format As Table and choose any format,…it doesn't really matter, what I'd like to show you…is two things.…One is a dialog box that opens and says that…the data for my table is here.…Now notice that I didn't select this table ahead of time,…I simply chose one cell in the table,…and I would encourage you to do that as a best practice.…I know that there are folks who say what you'd like to do…is select the whole table.…
- Identify the theme used by the default paste option.
- Recall what is embedded when you copy an Excel table and then embed the table in a PowerPoint presentation.
- Recognize the actions that may compromise data or yield incorrect results if a data table is missing descriptive labels.
- Recall the benefits of using a slicer over using a filter.
- Name a great way to illustrate the timeline and progress of a project.
- Explain what PivotTables do to tabular data.