Learn Excel – “Dynamic Range for a Pivot Table” – Podcast #1748
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. 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…
“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!
Entry filed under: 2013, Bill Jelen. Tags: accounting, Annoying Co-Workers, Bill Jelen, Blank Cells, business, COUNT, Data, Data Analysis, Dynamic Range, Excel, Excel 2010, Excel 2013, formula, Function, Inventory, Investing, Learn Excel, Learn Excel from MrExcel, Microsoft Excel, MrExcel, Number Crunching, Numbers, Office, Offset, Operation, Pivot Table, Query, software, Spreadsheet, SUM, technology, tutorial, Workbook, Worksheet.