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
Get & Transform Data, also known as Power Query, enables you to get data
from any source and transform it into a usable format. As an accountant, you
know that organisations often have a vast quantity of data, often be in many
different forms. Using Get & Transform you can connect, combine and
transform your data, so that it meets your analysis needs.
If you are a novice Get & Transform Data user, this course will take you
to a level where you are comfortable navigating and using the features of this
user interface. Learn how to connect to different sources, including CSV files
and web data, as well as understanding the different data transformations, such
as appending queries, and merging join types. Discover how to make the most of
column and row transformation options in Power Query and use table
transformations to create a table format that you can actually work
with.
This course will enable you to:
- Understand the basics and confidently navigate the Get
& Transform Data features
- Connect different data sources and load them into
Power Pivot, Excel or Power Query
- Append and merge queries for easier analysis and
combine Excel files from a folder
- Use the column and row transformation options in Power
Query
- Change the structure and layout of tables into a format you can work
with
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