Join Richard Harrington for an in-depth discussion in this video Working with headers, part of Excel 2013: Working with Charts and Graphs.
- View Offline
- Exercise Files
- Once you have a table created,…it's pretty important to go in…and modify the headers for clarity.…Let's adjust things both from a design layout…as well the conveying of the important information.…To start, I'll take this generically named Column 1…and double-click.…Let's call this Item.…You'll now see that we have the Item;…the definer, if this is a per-trip cost…or a per-night cost;…the Cost for each item; and the Quantity of each.…
And then the basic Subtotal.…Now, one of the things I like about columns…is that they're very easy to resize,…so you can make a little more room there.…Additionally here, as we start to process,…it's very simple to change what happens.…You'll note, for example, under the Table Tools, Design,…that there's some great information here.…Let's turn on the option for a Total Row…across the bottom, and you see it creates a total…by adding up everything in the Subtotal column.…
Now, I don't need these other ones here,…so I'll just right-click and choose Delete.…One of the advantages of these columns…
- Creating a chart
- Picking a chart type
- Displaying data with tables
- Editing data in a chart
- Adding SmartArt graphics
Skill Level Appropriate for all
1. Chart Essentials
2. An Overview of Chart and Graph Types
3. Displaying Data with Tables
4. Working with SmartArt
Adding a SmartArt graphic3m 50s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.