Excel Pivot Table Job Trend - Long Term Growth, Recessionary Impact
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 job skill.
Excel 2007 20 Pivot Table Examples
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.
Pivot Table Video for Excel 2007
For a good summary of how to set up a basic pivot table with Excel 2007 check out this video.
Pivot Table Analysis in Excel 2007 versus Excel 2003
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.
Grouping Dates in a Pivot Table Video Tutorial
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.
Use Pivot Tables to Summarize Dates
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 Year, Quarter and Month
Can you imagine trying to use Excel Subtotals to summarize a long column sales, listed by date? It would be a nightmare! Pivot Tables, on the other hand, can give you this summary with a few mouse clicks!
Add Running Totals to an Excel Pivot Table
Check out this short but easy to follow pivot table tutorial on how to add running totals to an excel pivot table.
Better than Pivot Tables?
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 to understand than long lists of numbers.
Tom Mainelli
I spend an inordinate amount of time working in huge Excel spreadsheets that represent data about the worldwide PC monitor market. Excel’s pivot tables and charts are useful, but sometimes I still struggle to find the trends buried in all those numbers.
So I did what any geek would do: I looked for an app that could help me. I found Tableau Software, which recently launched version 4.0 of its Desktop and Server analytical software clients. Put simply, you point Tableau at your data file, and it creates an interface that lets you drag and drop elements of the data to create visual representations that can be easier to understand than Excel’s own pivot tables and charts.
Panorama Updates Data Analysis Software for Google Apps
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
5:00 PM EDT Tue. Sep. 16, 2008
Panorama Software is offering a new release of its hosted data analysis software for Google (NSDQ:GOOG) Apps and Google Docs, further expanding the growth of business intelligence technology into the realm of cloud computing.The upgraded Panorama Analytics for Google Docs offers an improved user interface based on Adobe (NSDQ:ADBE)’s Flash technology and support for a greater number of business and consumer users. The service is now available in the “featured list” of Google Docs Gadget List.
Most business intelligence products today are on-premise reporting and analysis tools. But as more applications go the software-as-a-service route, including Google’s advertising-supported Google Apps, BI software vendors are trying to follow suite.
In March, Panorama debuted a pivot table solution for analyzing data in the Google Docs spreadsheet in much the same way information workers can use the Microsoft Excel spreadsheet as a front-end data analysis tool. Beyond the improved user interface, the new Panorama Analytics for Google Docs also offers more capability for analyzing large volumes of corporate data.
Excel Pivot Tables Explained
For some good tips on how to create a pivot table check out Stephen Well’s article from Personal Computer World.
Explore how Excel’s Pivot Table can help you to make sense of your data
Whether you call it a table, list or flat-file database, a series of records all neatly split into the same fields forces a disciplined order upon a mass of related data. But it doesn’t necessarily help you to analyse it.
That’s where an Excel Pivot Table is so useful. It allows you to look at the same information in many different ways. You can not only group and summarise the data, but also add depth to it. You can tell Excel which of the fields in the list are to be arranged in rows and columns. You can also designate a page field that seems to arrange items in a stack of pages. You can add a calculated field and twist all the data around, hence the Pivot.
