Booking Information
Once you have booked your course, you will receive a
confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland
Portal within the Kubicle site
About this course
Pivot tables allow you to boost the speed at which you analyze your data. They can be complex to understand at first, but once you’ve mastered them, they’ll offer significant improvements on the amount of time you spend completing tasks.
In this course, you’ll learn how to build, format, sort and filter pivot tables to speed up your analysis. You’ll also discover how to troubleshoot some of the most common issues that arise.
After completing the 12 lessons, you’ll understand just how useful pivot tables are, and how to use them to display your findings in an interactive way.
Lessons
This Kubicle course contains 12 lessons, 3 exercises, and 1 exam. It covers the following topics:
- Preparing Your Data for Pivot Tables
- Build Your First Pivot Table
- Formatting Pivot Tables
- Changing Pivot Table Output Values
- Grouping Date Columns
- Updating Pivot Tables with New Data
- Pivot Table Subtotals
- Sorting Pivot Table Data
- Apply Filters to Pivot Tables
- Pivot Table Slicers
- Build Charts from a Pivot Table
- Pivot Table Data in Formulas
Learning Outcomes
Once you have completed this course, you will know how to create Pivot Tables for any dataset. You will know how to format your Pivot Table results, refresh Pivot Tables with new data, sort and filter these results, and even create charts from your Pivot Table results.
- Create Pivot Tables from your Excel data
- Format the values and cells in a Pivot Table
- Adjust the values displayed in a Pivot Table
- Group the date columns in a Pivot Table
- Add subtotals to a Pivot Table
- Sort, filter, and slice your Pivot Tables
- Build Pivot Charts from a Pivot Table
- Update your Pivot Table to include new data
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.