If you would like to learn how to create Pivot Tables in Excel and are looking for a good Pivot Table course or tutorial then a great Pivot Table course I would highly recommend is The Magic of PivotTables by Ken Puls who runs the website Excel Guru.
What are Pivot Tables?
Pivot Tables are a powerful feature in Excel that can be used to very quickly summarize your raw data set with ease. It can summarise just the specific sections of the data you want to see and analyse. You can very easily change the Pivot Table in seconds if you want to see different information by removing and adding pivot items. You can sort, average, count and sum the data in a Pivot Table. As well a creating a summary table from the raw data set you can also visualise the information from the Pivot Table by a creating a Pivot Chart.
Pivot Tables are an advanced feature in Excel but in fact are very easy to create once you know how. If you take The Magic of PivotTables course you will see how easy they are to create and how powerful they really are!
Who is the Excel Guru?
Ken Puls is a very experienced Excel expert who has been using Excel for a significant number of years. He is a certified Management Accountant and has also been awarded the prestigious Microsoft Most Valuable Professional award in 2006 which he still holds to this day.
He is the co-author of RibbonX – Customizing the Office 2007 Ribbon. This book teaches you how to change the user interface in the Excel ribbon.
He has also worked as a freelance Microsoft Office Developer and completed many consulting projects mainly in Excel, but also with Access, Word and Outlook. He now concentrates on sharing his vast knowledge of Excel and teaches people how to get the most from it.
It is safe to say he knows a thing or too about Excel!
Who Should Take the Magic of PivotTables Course?
This course is for people who want to expand their Excel skills and want to add Pivot Tables to their list of Excel armoury. Pivot Tables are an extremely powerful feature in Excel and once you have learnt how to create them you will wonder why you never learnt them before. It will save you tons of time!
If you are in a job where you work with data but it takes you a long time to manipulate and analyse the data and you want to do this more quickly and efficiently then this course is definitely for you.
If you find you are analysing data manually or using Excel formulas to dissect certain parts of your data then this course will be of great benefit to you as it will save you hours and hours of work.
The Magic of PivotTables is also designed for people who have a limited knowledge of Pivot Tables and know the very basics but would like to know what else you can do with them.
What is Included in the Magic of PivotTables Training Course?
1) A one hour training video
- Demonstrated in Excel 2010
- Recorded and distributed in 1024*768 resolution
2) Copies of all sample files used in the creation of the video
- Distributed in xlsx file format
- Saved at key points in the process
3) A comprehensive e-Book
- 38 fully illustrated and searchable pages in PDF format
- Lists all steps required to replicate the course content
4) 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
By the end of the one hour Magic of PivotTables video course, you will learn the basics of PivotTables, including:
- What makes a good Pivot Table data source
- The method to turn a list into an Excel table
- The steps required to create Pivot Tables from Excel tables
- How to add, move and remove data from the Pivot Table
- Methods for grouping dates
- The way to change number formats
- How to perform calculations in the Pivot Table
- Ways to use report filters and Slicers to slice and dice your data
- The ease of using the Pivot Table Drill-Down feature
Why I recommend the Magic of PivotTables
The course uses real life examples and real knowledge which means that you can apply what you have learnt in your daily work straight away. The video tutorials and written documentation are very clear and easy to understand and enables you to get the very best learning experience.
Once you have taken this course you will understand the power of Pivot Tables and how easy they are to create. The videos are all in high resolution so are crystal clear so you can follow along very easily.
You will also get samples of the files used so once you have finished The Magic of Pivot Tables course you can refer back to the files. Often when you have completed a course you can forget what you have learnt after a month. Having these sample files enables you to keep practicing after you have finished the course so you will not forget what you have learnt. You also get a 38 page ebook which is a great reference guide after the course is finished. This ebook is structured in easy to follow steps which replicate the course. Again another example to not forget what you have learnt after the course.
As you can see from the course content it is very thorough and teaches you all you need to know about Pivot Tables, from what the data should be structured like in order to create the best Pivot Tables, to using slicers to drill down on the information.
Ken also offers a 100% money back guarantee for 30 days. If for any reason you are not completely satisfied with the course then you can contact him directly by email and he will give you a refund. You really do not have anything to lose and everything to gain!
Pivot Tables are essential if you want to quickly summarise large data sets. If you are a beginner in Excel and work with data in your day job then it is essential that you know how to create Pivot Tables. If you are looking for a Pivot Tables course then The Magic of PivotTables is a great course and you will learn everything you need to know about Pivot Tables.
To purchase the course please click on the link below.