From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Make dynamic presentations with rapid expand/collapse detail features in outlining

Make dynamic presentations with rapid expand/collapse detail features in outlining - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Make dynamic presentations with rapid expand/collapse detail features in outlining

“

- [Instructor] Excel has an outlining capability 2 and it's particularly useful during presentations. 3 You might also encounter outlining 4 if you work with Excel's subtotal feature. 5 On this worksheet, I've got some budget projections 6 for the year 2022, 7 and I'd like to start my presentation 8 to a group of analysts without showing them all this detail. 9 And manually ahead of time, 10 I certainly could hide columns B, C, and D, 11 and the other monthly columns as well, 12 to show only the quarterly totals, 13 and I might also want to hide those expenses. 14 But during the presentation, 15 I want to reveal some of those numbers. 16 I don't want to have to go through 17 the Excel command sequences 18 for hiding and unhiding columns and rows. 19 With the outlining capability, 20 we'll show you how that's much easier and simpler. 21 In this worksheet are a number of formulas in column E 22 that tabulate data…

Contents