Learn Excel Episode 825: Dynamic Pivot

Posted in Companies, Podcasts on August 17, 2008

Joe sends in a tip about converting your pivot table source data to a dynamic range. While this used to mean using the OFFSET function, now it simply means using Ctrl+L (in Excel 2003) or Ctrl+T (in Excel 2007). Episode 825 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Pivot Table, Dynamic Range, List, Table