Today, in Duel 142, we start back in Excel 2003 to create an Average by each Category that will work before AVERAGEIF came along in Excel 2007. Bill and Mike offer a Pivot Table, and two different Formula solutions in Episode #1780.

"Ctrl+Shift+Enter" by Mike 'ExcelIsFun' Girvin

Although elusive, Array Formulas can be used to solve everyday Excel problems. If you need to figure out how many times your birthday fell on a Friday, an Array Formula can solve that. If you need to return a Unique List of Sales Reps from a Database, an Array Formula can solve that. Now, at your own pace, you can learn the methods, the tricks, the dos and the don’ts that will allow you to “Command The Power of the ‘Array Formula’ in Microsoft Excel“! “Ctrl+Shift+Enter: Mastering Excel Array Formulas” by Mike ‘ExcelIsFun’ Girvin tells all!

And be sure to get the latest on All of Excel’s available Pivot Table features with…

"Pivot Table Data Crunching Excel 2013" by Bill Jelen

Pivot Table Data Crunching Excel 2013“, by Bill Jelen. Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control!

Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.