How to Create a Summary Report from an Excel Table

One of my viewers asked for my help in creating an Executive Summary Report – because her manager will not allow her to use a Pivot Table. Here are the tips and techniques that I demonstrate in this lesson:

1) Use Excel’s Advanced Filter to Extract a list of unique customer names from a filed with over 4,000 records.
2) Convert a normal range of data cells into an Excel 2007 / 2010 Table (as a List in Excel 2003) – so that range references will update automatically when you append records.
3) Create Named Ranges of Cells that you can use in Formulas & Functions.
4) Use the SUMIF,…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *