Join Gini von Courter for an in-depth discussion in this video Highlight high-value cells, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] Charts provide one way…to help your users visualize data.…But for tabular data, conditional formatting…is arguably the best tool we have to highlight…or accentuate some of the data in our spreadsheet.…When we use conditional formatting, it's best if we…start by removing any other formatting…that will really compete with it.…For example, in our table, I'm going to go make some choices…on the design tab, I'm going to get rid of banded rows…so that all of my rows are white.…
That way I don't have the gray formatting of the banded rows…fighting with the conditional formatting…that I'm going to apply.…First thing I'd like to do is choose a range of data…that it's appropriate to compare.…For example, I'd like to look at our best sellers…across two different dimensions.…One is what are the products that are selling well…in terms of the number of units and the other is…what are the locations.…Because I'd like to look at both locations and products,…that data is right here.…
Now remember I'm looking for our heavy hitters,…
- 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.