Join Dennis Taylor for an in-depth discussion in this video Set up data for outlines, part of Excel 2016: Advanced Formatting Techniques.
- Excel has a powerful tool called Outlining…and it's ideal for certain kinds of presentations.…On this worksheet called OutlineData here,…its Budget Projections for the year 2017,…goes out to column R and down to row 34.…Column E and also column I, column M, column Q…have summary type of information in them.…There's a formula that's calculated…in the data from the left.…By this fact alone, we have the capability…of using an outlining feature.…
The gist of this outlining feature is to suggest…that at times we want collapse data.…We don't want to see detail all the time.…Just give me the big picture.…Show me the totals or the subtotals, not all the detail.…And we do this sometimes thinking of collapsing…the vertical information like we see here in columns.…Sometimes possibly collapsing…some of the horizontal information we're seeing in rows.…And it sounds as if we've got something complex ahead…of us here in order to make this feature work.…
But all we really need to have in a worksheet like this is,…in an organized way, have some totals.…
Author
Dennis Taylor
Released
2/18/2016- Controlling fonts, borders, and cell color
- Adjusting horizontal and vertical cell alignment
- Creating angled text
- Adjusting numeric formatting
- Building custom date and numeric formats
- Creating value-based formatting
- Working with tables
- Using styles and themes
- Adjusting row heights and column widths
- Hiding and unhiding sheets
- Copying formats
- Formatting text with Justify
- Displaying data as outlines
- Formatting images and sparklines
- Creating picture links
- Formatting column and row titles
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome43s
-
-
1. Control Fonts, Borders, and Cell Color
-
2. Alignment Tools
-
3. Adjust Numeric Formats Quickly
-
Build custom numeric formats6m 59s
-
Build custom date formats4m 33s
-
4. Accentuate Dynamic Data with Conditional Formatting
-
5. Tables, Styles, and Themes
-
Work with tables9m 10s
-
-
6. Row, Column, and Sheet Adjustments
-
7. Other Worksheet Formatting Tools
-
8. Display Data as an Outline
-
Set up data for outlines5m 59s
-
-
9. Format Images
-
Format picture styles3m 25s
-
-
10. Specialized Power-Formatting Techniques
-
Create picture links6m 2s
-
Format column and row titles2m 36s
-
Conclusion
-
Next steps41s
-
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: Set up data for outlines