From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Showing necessary information with the Outlining feature

Showing necessary information with the Outlining feature - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Showing necessary information with the Outlining feature

“

In the worksheet called Outlining, we're seeing Budget Projections for 2014 and this sheet contains a lot of data. Now imagine if you'd like to display this information for presentation. It contains 12 months, it's got quarterly totals, a lot of information here and perhaps overwhelming, too much for a visual display and what you might want to consider doing ahead of time is hiding, for example, columns B, C and D and showing the first quarter totals and then doing the same kind of thing for the other months as well. You'd like to be able to present the data in a more compact way, not showing all the detail. Similarly, looking at the rows here, maybe you don't want to show that detail or this detail here. You do want to show some of those total rows. We've got expenses down here. You might not want to show that data as well. Now, hiding columns and rows doesn't take that long, but if you're making a presentation, you might want to have the flexibility to quickly expand and collapse…

Contents