Join Gini von Courter for an in-depth discussion in this video Changing a table to a range, part of Data-Driven Presentations with Excel and PowerPoint 2013.
You may occasionally choose to take a data table…and return it to the range that it was.…The primary reason you might do this is that you want…to use a command like subtotals that's not available in the table.…If I go to the data tab, and I wanted to subtotal That's not available.…It's turned off.…And the reason is, it's not compatible with formatted tables.…So if…that were the case, I can say okay, here's what I'm going to do.…I'm going to right-click on the table.…
I'm going to go to Table and choose Convert To Range.…Now when I do this, what it's going to do is change it to a range.…But it didn't say unformat the table.…All of my formatting still here, and now I could…go back to the home tab and manually change it.…But there's an easier way. Let's undo this and…start again.…It's once again a table, I'm going to go to the Table Tools Design tab…and I'm going to get rid of my total row because I really don't want it afterwards.…
And I'm not going to say OK. Let's choose a table style…that's simple, that has no style at all. Now I could have also chosen this one.…
Author
Gini von Courter
Released
10/17/2013- Using Excel themes
- Formatting tables
- Highlighting data with conditional formatting
- Creating pie, column, and combination charts
- Creating PivotTables
- Pasting and linking charts and tables
- Creating SmartArt diagrams
- Animating charts, tables, and SmartArt
- Finalizing your presentation
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 2s
-
Using the exercise files2m 16s
-
-
1. Data-Driven Presentations: The Basics
-
2. Formatting Excel Tables for Presentations
-
Setting table options3m 53s
-
Changing a table to a range2m 47s
-
Dividing large numbers3m 12s
-
3. Highlighting Data with Conditional Formatting
-
Using data bars4m 46s
-
Using icon sets4m 50s
-
Editing a conditional format8m 26s
-
4. Using Charts to Illustrate Data
-
Choosing the right chart7m 3s
-
Creating a pie chart2m 52s
-
Creating a column chart4m 34s
-
Creating a 100% chart3m 54s
-
Creating a combination chart2m 27s
-
-
5. Summarizing with PivotTables and PivotCharts
-
Creating a PivotChart4m 59s
-
6. Taking Excel to PowerPoint
-
Linking data and objects8m 42s
-
7. Using SmartArt in Data-Driven Presentations
-
Creating a SmartArt diagram3m 37s
-
-
8. Animating Charts and Data
-
Animating charts8m 11s
-
Removing animation1m 7s
-
Modifying animation order1m 16s
-
Animating SmartArt8m 11s
-
-
9. Finalizing Your Presentation
-
Conclusion
-
Next steps1m 49s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Changing a table to a range