Join Dennis Taylor for an in-depth discussion in this video Use Outlining tools to quickly expand and collapse data for dynamic presentations, part of Excel Tips Weekly.
- [Instructor] Excel has an outlining feature…that's valuable, not only when you're working…with the data yourself, but also while making presentations.…And both of these features are found on the Data tab…in the ribbon off to the right.…One of them is called Subtotal,…you might be familiar with it.…The other two entries above relate to this feature as well.…As we look at this data here,…there's a lot of information on the screen.…I'm going to zoom back a bit,…and ultimately we will see all twelve months.…The numbers will be substantially smaller at that point.…That's a lot of information.…
Now, as you probably would guess after looking…at it a little bit, and clicking here and there,…there are some formulas here.…We've got tabulations in column E.…Here's a simple sum function being used,…and we see it over in column I,…and also over to the right.…Now, if you were making a presentation of this data,…one thought might be, why not show just the quarters?…So what we could do manually is drag across columns B, C, D,…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
Freeze Panes and Split New5m 30s
- 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.