Pivot Tables! Bill’s favorite subject.  So the story goes like this:

“Tom’s co-workers created a monster today. They have 15,000 Rows of Formulas that are pulling Data forward from a Query, but filling the extra Rows with “”. So, when Tom tries to create a Pivot Table, it is seeing the “” as Text and causing the Pivot Table to Count instead of Sum.”

Normally, you would use a Ctrl+T Table, but the use of “” won’t allow that to work. So – pretending like this is Excel 2002 and dusting off the =OFFSET Function for Episode #1748, Bill creates a Dynamic Range. Bill says, “…I really thought I would never have to do this again, but Tom’s co-workers forced me into it.”


"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.

And if you need to know more about Microsoft Excel 2013 in depth…

"Excel 2013 InDepth" - by Bill Jelen

Microsoft 2013 InDepth” – by Bill Jelen has that information. Excel 2013 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone working with Excel 2013. Excel expert and MVP Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: the types of challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2013.

“The Learn Excel from MrExcel Podcast Series”

Visit us: MrExcel.com for all of your Microsoft Excel Needs!