How do I revert back to the old pivot table layout?

If you open your Excel 2007 in order to create a Pivot Table, you will no doubt be faced with the new layout (pictured above).

If you feel more comfortable using Excel's familiar pivot table layout, you can alter your settings to show the older style pivot table drag and drop box (pictured below).

To enable the previous version's look, select Pivot Table Tools> Pivot Table Options > Options. When the options box opens, click on the Display tab. Place a check into the box next to Classic Pivot Table Layout.

Now you have all the new functionality with an old faithful look and feel.

How do I create pivot tables in Excel 2007?

Pivot tables are an excellent way of organising large amounts of data, customised to suit your present needs. The pivot table layout is a little different in Excel 2007, but you'll soon find it has really improved and pivot tables are easier to use than ever before. Example from John Walkenbach's Excel 2007 Bible.

I'll include specific written instructions at a later time. For now, the best way to show you just how pivot tables are created is via the above video demonstration.