Just Pivot Tables

How to Sort Pivot Tables Video

Pivot Table Guy — Mon, 07 Sep 2009 22:03:50 +0000

Have you ever run into a situation where you can’t seem to sort a row in a pivot table? There is a way to do it but its not obvious at all. The following video shows you how. Bookmark It

Excel Pivot Table Job Trend - Long Term Growth, Recessionary Impact

Pivot Table Guy — Sun, 31 May 2009 16:25:23 +0000

Excel pivot table jobs show solid long term growth but also the impact of the worldwide recession. I thought it would be interesting to graph the job trend compared to all excel jobs. While Excel jobs are flat to declining, pivot tables jobs continue to grow. Having pivot table skills is obviously an increasingly valuable [...]

Excel 2007 20 Pivot Table Examples

Pivot Table Guy — Mon, 25 May 2009 21:17:35 +0000

This pivot table video tutorial from Highline covers 20 pivot table examples. For an excellent overview of many key pivot table concepts check it out. Bookmark It

Pivot Table Video for Excel 2007

Pivot Table Guy — Sun, 01 Mar 2009 15:57:33 +0000

For a good summary of how to set up a basic pivot table with Excel 2007 check out this video. Bookmark It

Pivot Table Analysis in Excel 2007 versus Excel 2003

Pivot Table Guy — Mon, 22 Dec 2008 02:08:31 +0000

The interface for Excel pivot tables changed fairly dramatically from Excel 2003 to Excel 2008. For those of you that are making the move to Excel 2007 pivot tables the following video does a great job of showing the differences between the two versions. Check it out. Bookmark It

Grouping Dates in a Pivot Table Video Tutorial

Pivot Table Guy — Sun, 23 Nov 2008 21:04:01 +0000

If you have ever grouped dates in a pivot table, then you know it can be a little tricky. The howcast video embedded below does a good job of explaining how to group dates in a pivot table. Check it out. Bookmark It

Use Pivot Tables to Summarize Dates

Pivot Table Guy — Tue, 28 Oct 2008 03:04:42 +0000

Summarizing dates in a pivot table can be a little tricky. The pivot table video linked to below from Danny Rocks gives a nice short pivot table tutorial on how to summarize dates. I especially like the fast pace and clear explanations in the pivot table video. Check it out. Use Pivot Tables to Summarize by [...]

Add Running Totals to an Excel Pivot Table

Pivot Table Guy — Mon, 13 Oct 2008 02:29:31 +0000

Check out this short but easy to follow pivot table tutorial on how to add running totals to an excel pivot table. Bookmark It

Better than Pivot Tables?

Pivot Table Guy — Tue, 30 Sep 2008 00:11:08 +0000

For advanced pivot table users, there’s an interesting article over at PC World about a tool by Tableau Software. Its a little pricey, but according to the author for some users it can be worth it. Check it out at the link below. Visualize Your Data in Whole New Ways Tableau’s visual representations of data are easier [...]

Panorama Updates Data Analysis Software for Google Apps

Pivot Table Guy — Wed, 17 Sep 2008 03:53:27 +0000

In March, Panorama released a tool to create pivot tables in Google Docs. As reported in the article below Panorama has released an upgraded version of the Panorama Analytics software that includes the pivot table functionality. Panorama Updates Data Analysis Software for Google Apps By Rick Whiting, ChannelWeb 5:00 PM EDT Tue. Sep. 16, 2008 Panorama Software is [...]