Excel PivotTables: It’s a polarizing term. People who use PivotTables absolutely love them. For those who don’t, the term is mysterious and encourages the fear of powerful features that are the domain of geeks and Excel junkies, and out of reach to the common man. But nothing could be further from the truth.Why You Should Take This Course:
If you’ve never created, or don’t regularly use PivotTables in your work, let me show you that you are missing out on one of the most useful, impressive and easy-to-use tools in Microsoft Excel.
Excel PivotTables are an amazingly powerful feature that can be used to very quickly summarize and slice and dice data with ease. And contrary to many users’ fears, they are actually VERY easy to use once you’ve been shown how.
So why don’t you let me do just that? In this one hour video training course, I will teach you how to build your first PivotTables. You’ll see first hand just how easy they are to create, how fast they work, and how easy it is to change them to display your data the way you want to see it.
Excel PivotTables are an amazingly powerful feature that can be used to very quickly summarize and slice and dice data with ease. And contrary to many users’ fears, they are actually VERY easy to use once you’ve been shown how.
So why don’t you let me do just that? In this one hour video training course, I will teach you how to build your first PivotTables. You’ll see first hand just how easy they are to create, how fast they work, and how easy it is to change them to display your data the way you want to see it.
Stop struggling! Learn from the Excel Guru!
The Magic Of PivotTables (2007)
“The Magic of PivotTables (2007)” training package comes with:
- A one hour training video
- Demonstrated in Excel 2010 (see note below)
- Recorded and distributed in 1024*768 resolution
- Copies of all sample files used in the creation of the video
- Distributed in xlsx file format
- Saved at key points in the process
- A comprehensive e-Book
- 37 fully illustrated and searchable pages in PDF format
- Lists all steps required to replicate the course content applicable to Excel 2007
- A list of resources to get more advanced material and help once you’re through the basics
- A 30 day, 100% money back satisfaction guarantee
- IMMEDIATE delivery via download link
A Note On The Video
The video for this course is shot in Excel 2010, not Excel 2007. With the exception of having a File Tab instead of an Office Button, however, the user interface and steps to create the PivotTables between these two versions are almost identical. (Any discrepancies are covered in the e-Book included with the course package.)
The benefits of this approach are that you can see what can be done with Excel 2007, as well as Excel 2010, including the new Slicers features. So when you eventually do get upgraded to Excel 2010, you'll already have a leg up on that cool new feature!
The benefits of this approach are that you can see what can be done with Excel 2007, as well as Excel 2010, including the new Slicers features. So when you eventually do get upgraded to Excel 2010, you'll already have a leg up on that cool new feature!
Course Content
By the end of the one hour “Magic of PivotTables (2007)” video course, you will learn the basics of PivotTables, including:
Packed with insights, this Video course is guaranteed to give you the basics that you need to be up and running with PivotTables in your daily work, and will also guarantee that you never look at your data in quite the same way again.
- What makes a good PivotTable data source,
- The method to turn a list into an Excel table,
- The steps required to create PivotTables from Excel tables,
- How to add, move and remove data from the PivotTable,
- Methods for grouping dates,
- The way to change number formats,
- How to perform calculations in the PivotTable,
- Ways to use report filters to slice and dice your data, and
- The ease of using the PivotTable Drill-Down feature.
Packed with insights, this Video course is guaranteed to give you the basics that you need to be up and running with PivotTables in your daily work, and will also guarantee that you never look at your data in quite the same way again.
The ExcelGuru Philosophy
I’ve been to Excel courses, and I understand just how little they often convey… and I find it maddening. I have a huge passion for sharing my knowledge, as you can see from my personal profile page.
Every course I’ve ever taught is geared to give the participants real knowledge that they can take away and use in their daily work, and this course is no different. From this very info page through the video through the written documentation, it was developed to make certain that you get the very best learning experience possible for the way YOU learn. Whether by reading, listening, watching or doing, I have provided the material for your preferred learning style. I do not consider my products a success unless they have been effective for you!
Every course I’ve ever taught is geared to give the participants real knowledge that they can take away and use in their daily work, and this course is no different. From this very info page through the video through the written documentation, it was developed to make certain that you get the very best learning experience possible for the way YOU learn. Whether by reading, listening, watching or doing, I have provided the material for your preferred learning style. I do not consider my products a success unless they have been effective for you!
Guarantee
I am offering a 100% money back guarantee for 30 days. This allows you to try my products risk free and find out for yourself. If, for any reason, you are not completely satisfied with the training package, email me for a full refund.
Quick And Painless Purchase Process
Upon approval of your payment, you will be directed to a web page with 3 download links. (The video, example files and e-Book.) You will also receive an email from Excelguru Learning Services (webstore@excelguru.ca) with a link to the download page.
If you do not receive this email, check that it has not been filtered out as spam, then contact me.
To account for possible connection problems, the download link remains valid for a period of 5 days (120 hours) or for up to 5 downloads, whichever comes first. If you need to download the material after this, contact me to obtain a new link.
Note that the five allowed download attempts do not entitle you to five copies of the material. The pricing below is based on one user only. For multi user installations, please contact me for pricing.
If you do not receive this email, check that it has not been filtered out as spam, then contact me.
To account for possible connection problems, the download link remains valid for a period of 5 days (120 hours) or for up to 5 downloads, whichever comes first. If you need to download the material after this, contact me to obtain a new link.
Note that the five allowed download attempts do not entitle you to five copies of the material. The pricing below is based on one user only. For multi user installations, please contact me for pricing.
So What Are You Waiting For?
“The Magic of PivotTables (2007)” video training course package is only $69 USD!
Testimonials
This course was originally taught as a one hour webcast for the Certified Management Accountants of BC Upper Island Chapter. It was only after the overwhelming positive feedback I received that I decided to re-record the material and release it on my site. Here are just a couple of the comments I received:
Originally Posted by J McGarvey
Originally Posted by Steve John - Operations Accountant, K2 Stone
Originally Posted by Bill Jelen - MrExcel.com
Originally Posted by Doreen Gatt, CMA
Originally Posted by Jose Gonzalez
Originally Posted by J McGarvey
Originally Posted by Steve John - Operations Accountant, K2 Stone
Originally Posted by Bill Jelen - MrExcel.com
Originally Posted by Doreen Gatt, CMA
Originally Posted by Jose Gonzalez
Rate this article