How to Create a Summary Report from an Excel Table

Опубликовано: 19 Сентябрь 2011
на канале: Danny Rocks

1,569,533

4.7k

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, AVERAGEIF and COUNTIF Functions in the Summary Report.

I invite you to visit my online shopping website - http://shop.thecompanyrocks.com - to view all of my video tutorials.

Danny Rocks
The Company Rocks

Смотрите видео How to Create a Summary Report from an Excel Table онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Danny Rocks 19 Сентябрь 2011, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,569,533 раз и оно понравилось 4.7 тысяч людям.