Pivot Table Report

In just one hour

… you can learn how to create an Excel Pivot Table Summary Report that will allow you to:

• • Summarize
  • Analyze
  • Present the Information in your data collection!

Pivot Tables are the most powerful tool in Excel. Amazingly, they are also one of the easiest tools to use – once you know how to use them. And, after you watch my one-hour Pivot Table Tutorial Video, you will know how to create and modify any Pivot Table!

I created this Pivot Table Summary Report with about 10 clicks of the mouse – and I did not have to write a single formula to do so!

Topics Covered on Recording

I have created individual chapters on the recordings. You can either watch the video from start to finish or go to these individual lessons:

1. How to create a Pivot Table in your version of Excel (Excel 2003, Excel 2007 or 2010)
2. What’s New with each version of Excel Pivot Tables
3. How to Filter Excel Pivot Table Fields
4. How to Change the Data Source for your Pivot Table and how to Refresh Pivot Table Reports
5. How to Change the Summary Calculation for Pivot Tables – e.g. Percentage of Total, Year-over-year, etc.
6. How to Create Calculated (Virtual) Fields for Pivot Table Reports
7. How to Group Pivot Table Fields – e.g. to Create a Year, Quarter and Month Report from a list of daily transactions!
8. How to Generate and Filter Pivot Charts

All of this for only $9.95

• Download Excel 2003 Version of one-hour Pivot Table Tutorial Video
  • Instructional Manual – 2003 – Summarize, Analyze, Present with Pivot Tables Excel 2003
• Download Excel 2007 Version of one-hour Pivot Table Tutorial Video
  • Instructional Manual – Summarize, Analyze, Present with Pivot Tables Excel 2007
• Download Excel 2010 Version of one-hour Pivot Table Tutorial Video
  • Instructional Manual – PDF for Summarize, Analyze, Present with Pivot Tables Excel 2010
• Get Excel Practice Files for Pivot Table Videos – Available on my Windows Live! Sky Drive

Download Recordings from WebEx by Cisco

I host my video recordings on my WebEx by Cisco site – http://thecompanyrocks.webex.comWhen you download the recordings, they play using Cisco’s proprietory ARF file format. I recomment that you download the – FREE – ARF recorder plug-in. Once you open the recording, you can quickly convert it another popular video format – for example:

• MP4 (MPEG4) – Works with Quick Time
• WMV (Windows Media File)
• SWF (Flash File Format)