Join Dennis Taylor for an in-depth discussion in this video Setting up data for outlining, part of Excel 2013: Advanced Formatting Techniques.
- Excel has an outlining capability…that you easily overlook.…It's on the Data tab.…You'll notice the last group is called Outline,…and we see the icons Group,…Ungroup, and Subtotal.…All of these features give us the ability…to quickly collapse and expand a display.…Now, here's a budget projection for 2014.…As we look at the data here,…you can imagine how someone…about to make a presentation would be saying,…"This is way too much data to start off with.…"Let's not show the monthly data."…What you might do manually is,…drag across columns B, C and D,…that's the January, February, March,…and then, holding down the control key,…do this for columns F, G and H,…and J, K, and L,…and N, O, P.…
Right-click and Hide.…That's the more sensible display.…Similarly, we might want to hide the Expenses detail,…hide these rows here.…Right-click and Hide.…And maybe then, if our audience…is presented with this information,…expanded perhaps by zooming in,…it's not so much to absorb all at once.…But if we need to show some of the detail…
Author
Released
12/10/2013- Adjusting fonts, cell borders, and fills
- Aligning text
- Indenting data
- Setting special formats for dates, times, phone numbers, zip codes, and more
- Creating formats based on formulas with conditional formatting
- Applying styles and themes
- Adjusting row heights and column widths
- Adding background images and pictures
- Outlining data
- Printing double-spaced data
Skill Level Advanced
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Appropriate for all -
Excel 2013: Shortcuts
with Curt Frye3h 16m Intermediate -
Excel 2013: Pivot Tables
with Curt Frye4h 20m Intermediate
-
Introduction
-
Welcome47s
-
-
1. Controlling Fonts, Borders, and Cell Color
-
2. Alignment Tools
-
3. Adjusting Numeric Formats Quickly
-
Building custom date formats5m 44s
-
4. Accentuating Dynamic Data with Conditional Formatting
-
5. Tables, Styles, and Themes
-
Working with tables8m 34s
-
-
6. Row, Column, and Sheet Adjustments
-
7. Other Worksheet Formatting Tools
-
8. Displaying Data as an Outline
-
9. Adding Pictures
-
Formatting picture styles3m 12s
-
-
10. Specialized Power Formatting Techniques
-
Conclusion
-
Goodbye29s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Setting up data for outlining