Accounting Course Online

Michael from Shanghai asks about missing data in a pivot table. If some customers have data from every month and other customers have data from only a few months, the pivot table will change shape as you select new customers from the filter. Episode 970 will show you the hidden setting to prevent this problem.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Duration : 0:2:24

Coercing Dates - 1019 - Learn Excel from MrExcel Podcast

Technorati Tags: accounting, business, Excel, mrexcel, pivot, spreadsheets, table, technology, tutorial