Booking Information
Once you have booked your course, the link to the recording will be available in your "My Account" area.
Please be aware that you will have access to this course for 180 days from the date of purchase.
Online courses cannot be booked on behalf of someone else. Access will only be granted to the person completing the online order.
About this Course
The way you visualize your data impacts how your audience will understand what you are telling them. Charts are an easy way to deliver complex information in a simple format. This course will help you master that skill.
Across 13 lessons, you’ll learn the different ways on how charts can be created, which chart to use based on your business need, along with the pros and cons of each option.
By the end of this course, you’ll understand how much easier presenting your data becomes when you have a chart to do the hard work for you.
Who Should Attend?
This is an intermediate course suited to people with a general knowledge of Excel but not necessarily any knowledge of Power Pivot. This course will be of interest to any business professionals, such as accountants, management consultants, and analysts who want to learn to use Power Pivot.
Course Overview
This Kubicle course contains 15 lessons, 3 exercises, and 1 Exam. It covers the following topics:
- Overview and Installation
- Loading Data to the Excel Data Model Part 1
- Loading Data to the Excel Data Model Part 2
- Q&A - Loading Data to Power Pivot
- Data View and Diagram View
- Relationships
- Q&A - Relationships and Viewing Tables
- Calculated Columns
- Measures
- Q&A - Calculated Columns and Measures
- Creating a PivotTable from Power Pivot Data
- Creating a PivotChart from Power Pivot Data
- Adding Slicers to PivotTables and PivotCharts
- Updating the Data Model
- Q&A - PivotTables, PivotCharts, and Refreshing Data
Key Outcomes
- Load data to the Power Pivot data model
- Explore the data model using the Power Pivot interface
- Create relationships between tables in Power Pivot
- Create calculated columns and measures
- Create Pivot Tables and Pivot Charts from Power Pivot data
- Update the data in the data model
Contact Us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930.