Excel Power Query and Power Pivot
Learn how to work with and connect multiple data sets to effectively analyse and report on data.
Enquire Now
Course overview
Duration: 1 day (6.5 hours)
Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them.
This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability.
Knowledge of working with Excel workbooks and relational databases would be an advantage.
Objectives
By the end of the course you will be able to:
- Import data from multiple data sources
- Edit and transform data before importing
- Add extra columns of data
- Append data
- Merge data from other tables
- Create data models
- Build data relationships
- Build Pivot Tables
- Build Pivot Charts
- Use Slicers and Timeline Filters
Content
Importing data
- Data sources
- Importing data
Transforming data
- Editing your data
- Setting data types
- Removing columns/rows
- Choosing columns to keep
- Setting header rows
- Splitting columns
Appending queries
- Appending data from other tables
Adding text
- Columns from example
- Custom columns
- Conditional columns
Merge queries
- Setting up and using merge queries
- Merging in columns of data
Creating a data model
- The data model
- Multiple data tables
- Connecting tables
- Building relationships
- Relationship types
- Building visuals from multiple tables
Analysing information using pivot tables
- Creating and modifying a Pivot Table
- Recalculating the Pivot Table
- Filtering the Pivot Table
- Searching the Pivot Table
- Drilling down to underlying data
- Customising field names
- Changing field formatting
Pivot charts, slices and timelines
- Creating Pivot Charts
- Adding and using Slicers
Testimonials
Frequently Asked Questions
Who is this Excel Power Query and Power Pivot course designed for?
Do I need prior Excel experience?
What will I learn on this course?
How is the training delivered?
Do you provide support after the training?
What’s the difference between Power Query and Power Pivot?
Get in Touch
Still have questions about this course?
Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.
Enquire NowRelated Courses
Excel Module 2 – Data Analysis and Pivot Tables
Expand your Excel knowledge and learn how to structure and analyse large data sets.
Excel Module 4 – Advanced Formulas and Functions
Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time.
Excel Advanced Statistical Analysis
Use some of the hidden statistical analysis tools within Excel to build complex data models.
Explore More Training Options
Public Training Programme
Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.
Engage with expert instructors and a diverse peer group in an interactive, online learning environment.
Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.
Check Public DatesFull Training Catalogue
We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.
Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.
