Category: Pivot Table

Compare Weekdays in Fiscal Year Summary http://blog.contextures.com/ 0

Compare Weekdays in Fiscal Year Summary

In the retail businesses, some days of the week are busier than others. So, if you’re looking at year over year sales, it’s not too helpful to compare sales for a specific calendar date,...

Pivot Table Fill Colour Disappears 6

Pivot Table Fill Colour Disappears

Microsoft just announced the winner of their Excel World Champ data visualization contest. Congratulations to Ghazanfar Abidi, from Canada! I found his website today, and learned something new from his latest blog post –...

Remove Excel Pivot Fields With Macros 10

Remove Excel Pivot Fields With Macros

If you’re rearranging a complex pivot table, it can take a while to manually remove each field. To make the job easier, you can remove Excel pivot fields with macros. There’s a sample macro...

how to plan a pivot table 4

How to Plan a Pivot Table in Excel

Setting up a pivot table is a bit like news reporting – you can give a quick summary of the Who, What, When, Where and How (Much) of your data. After you’ve been using...

Excel Pivot Table Show Details 1

Pivot Table Show Details Sheets

When you double-click on a pivot table value cell, Excel creates a new sheet, with a list of all the records that make up that total value. The double-click runs Excel’s Pivot Table Show...

unpivot excel data 4

Quick Ways to Unpivot Excel Data

Before you can build a flexible pivot table, you might need to rearrange the data. For example, if the data has a separate column for each month’s sales, that won’t work well in a...

How to Create a Pivot Table Style 0

How to Create a Pivot Table Style

You don’t have to stick with the default formats for your pivot tables. You can create a pivot table style with your own colours, and other formatting options that you like. Here’s how to...