Join Gini von Courter for an in-depth discussion in this video Display large values compactly, part of Data-Driven Presentations with Excel and PowerPoint 2016.
- [Instructor] There are two more pieces of formatting…I'd like to do to this particular table.…The first is to change the formatting on our numbers.…For example, we've sold over 18,000 units…of mini solar panels in the Pacific,…21 almost 22,000 in the Atlantic, 20,716.…These large yet round numbers…are often difficult for people to compare.…While this is giving us a very precise number,…it is often better to have numbers…that are easier for people to hold in their head.…
18, 22, and 21…rather than 18,546, 21,975, and so on.…Let me show you how we can format all of these numbers.…First, let's select them…and the keystroke on those is using the arrow keys…while holding Control and Shift.…And now rather than choosing the general format,…I'd like to choose a custom format…so click more number formats…and I'd like to create a number format.…
There are a whole range of formats that involve numbers,…number, currency, accounting, percentage, and so on.…I'm going to begin with simply the number format…and this is a sample.…
- 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.