What's Included In This Course
PivotTables enable you to take massive amounts of data and quickly summarise and analyse it with just a few clicks of your mouse.
This power means you can create reports extremely quickly, and respond to the inevitible report change requests without dread.
Our Xtreme Excel PivotTable course makes mastering PivotTables easy with video tutorials delivered in bite size chunks (average is 3 minutes long). We’ll have you pivoting your data in no time.
- Comprehensive syllabus covering every aspect of PivotTables – It’s the most extensive PivotTable training available, leaving no menu unturned. Every feature is covered in detail and then applied to real life scenarios.
- You will learn how to:
- Suitable for all levels – From someone who has picked up Microsoft Excel for their first time, to someone who uses it around 2-3 hours a day, as well as long time Excel users who want to go deep in to learning all the commands, tricks and visual analytical reports that Pivot Tables have to offer.
- Scared of PivotTables – if you’ve tried to learn PivotTables before but have struggled then this course is for you. I start from the very beginning and have broken it down into small steps to allow you time to practice as you go, which helps to cement your understanding. Once you get up to speed you’ll see they’re actually very easy to use… much easier than formulas
- PivotTable Intermediate – if you’re familiar with PivotTables but would like to tackle some of the more advanced topics like Calculated Fields, Show Values As, Conditional Formatting with PivotTables, Grouping, Slicers etc. then you can skip the topics you already know and go straight to the more advanced lessons.
- Update your Skills – PivotTables are a must have Excel skill. If your resume is missing PivotTables then you’re going to find it that bit harder to convince a prospective employer of your Excel abilities.
- Handle Big Data – if you work with big data, or even large data then PivotTables are going to make your life easier. They’re far more efficient than formulas and are handy for quickly getting a feel for new data and what patterns exist.
- Prices are +GST for Australian customers.
- If you purchase the Online + Download option, course videos will be available for download after the 30 day Money Back Guarantee period ends.
- Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
- Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
- You can request a refund provided that no more than 30% of the course videos have been watched.
Reviews & Instructors
Have a look to who is teaching this course and what are the learners views, it's always good to know what you think about this course.