8 0 By Victor Chan In Excel Data Analysis, Excel Pivot TablesPosted February 23, 2012How do I stop Excel from resetting my custom number format when I update my Pivot Table?Excel Pivot Tables are probably the single most powerful built-in [...] READ MORE
9 1 By Victor Chan In Excel Data Analysis, Excel Pivot TablesPosted September 29, 2011Pivot Table Tutorial: How to flatten a cross tab tableWhen you have a cross tab table you might want to flatten it to make it [...] READ MORE