Filters Reveal Needed Data

Instead of sifting through data-filled spreadsheets, turn on a filter and let the spreadsheet program search for the information you require.

Outlines Isolate Summary Data

This article demonstrates the advantages of using Excel’s outline feature to summarize data without having to hide the detail data.

Working With Multiple Worksheets

How to improve data organization and create useful summaries.

Automate Repetitive Tasks With Macros

Design your own mini-program, or macro, within Excel and run it with a shortcut key.