Booking with a Training Ticket
Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed
Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification
Course Overview
Power Pivot is an Excel add-in that provides some of the most powerful
features for accountants. With its own DAX functions, it can be used to perform
multiple calculations and complicated data analysis, enabling you to create
sophisticated data models.
This course, goes beyond the basics, to enable you to become more comfortable
with Power Pivot Models, using Pivot tables and charts, as well as carrying out
calculations and time intelligence functions. It is recommended that you have a
good understanding of Excel’s standard pivot tables and charts before taking
this course. If you are a beginner with excel, you will find that this course
goes well alongside Data Analysis for Accountants: Getting Started.
This course will enable you to:
- Familiarise yourself with the user interface of Power
Pivot
- Use different tools to set up relationships in Power
Pivot
- Use Power Pivot to quickly insert pivot tables,
charts, form multiple tables and analyse data
- Work easily with calculations and data models across
multiple tables of data using DAX
- Understand the basics of DAX, including time intelligence functions that
aren’t found in Excel
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
LOADING...