Power Query for Microsoft Excel
Level: Intermediate
Master Power Query for Microsoft Excel
Clean, Transform & Reshape Data with Ease
Automate Repetitive Data Preparation Tasks
Import, Merge & Combine Multiple Data Sources
Welsh Government Funding Accepted
Course Overview
Duration:
1 day (9:30am-3:00pm)
Accredited:
Available upon request
Exams:
N/A
Funding:
ReAct
Type:
Classroom, Onsite, Virtual
Company group booking discount available
Course Overview
Duration:
1 day (9:30am-3:00pm)
Accredited:
Available upon request
Exams:
N/A
Funding:
ReAct
Type:
Classroom, Onsite, Virtual
Company group booking discount available
This one-day Power Query for Excel course is designed for anyone who works with data and wants to automate the process of importing, cleaning and transforming information within Excel. Power Query is a powerful data transformation tool that enables users to connect to multiple data sources, cleanse data efficiently and prepare information for analysis and reporting. Rather than spending hours manually updating spreadsheets, learners will discover how to create repeatable processes that save time, improve accuracy and increase productivity. Throughout the course, delegates will learn how to import data from a variety of sources, perform common data cleansing tasks and apply advanced transformation techniques to prepare data for business reporting and analysis. The course combines practical demonstrations with hands-on exercises, helping learners build confidence in using Power Query for real-world business scenarios.
Target Audience
- Excel users who work with large volumes of data
- Business professionals responsible for reporting and data analysis
- Administrative and support staff who regularly update and manage spreadsheets
- Data analysts looking to automate data preparation tasks
- Anyone wanting to improve efficiency when working with business data in Excel
By the End of This Course, You Will Be Able To:
- Import data from a variety of sources into Excel using Power Query
- Clean and transform data efficiently
- Remove duplicates and unwanted records
- Change data types and standardise information
- Create calculated and conditional columns
- Merge and append datasets from multiple sources
- Split, pivot, unpivot and transpose data
- Apply mathematical, text and date functions within Power Query
- Automate repetitive data preparation tasks
- Create repeatable data transformation processes that improve accuracy and productivity
This one-day Power Query for Excel course is designed for anyone who works with data and wants to automate the process of importing, cleaning and transforming information within Excel. Power Query is a powerful data transformation tool that enables users to connect to multiple data sources, cleanse data efficiently and prepare information for analysis and reporting. Rather than spending hours manually updating spreadsheets, learners will discover how to create repeatable processes that save time, improve accuracy and increase productivity. Throughout the course, delegates will learn how to import data from a variety of sources, perform common data cleansing tasks and apply advanced transformation techniques to prepare data for business reporting and analysis. The course combines practical demonstrations with hands-on exercises, helping learners build confidence in using Power Query for real-world business scenarios.
Target Audience
- Excel users who work with large volumes of data
- Business professionals responsible for reporting and data analysis
- Administrative and support staff who regularly update and manage spreadsheets
- Data analysts looking to automate data preparation tasks
- Anyone wanting to improve efficiency when working with business data in Excel
By the End of This Course, You Will Be Able To:
- Import data from a variety of sources into Excel using Power Query
- Clean and transform data efficiently
- Remove duplicates and unwanted records
- Change data types and standardise information
- Create calculated and conditional columns
- Merge and append datasets from multiple sources
- Split, pivot, unpivot and transpose data
- Apply mathematical, text and date functions within Power Query
- Automate repetitive data preparation tasks
- Create repeatable data transformation processes that improve accuracy and productivity
Power Query for Microsoft Excel
Introducing Power Query
- Importing data from an Excel spreadsheet
- What kind of data can Power Query Import
- What kind of data is best loaded into Power Query
- Uses of Power Query
Basic Data Manipulation
- Selecting which of the imported columns to load
- Removing duplicates rows from the data
- Removing excess rows from the imported data
- Changing the data type of a column
- Renaming a column
- Explaining and using Applied Steps
- Creating a calculated column
- Splitting a column in multiple columns
- Merge columns together
- Transposing and Unpivoting Data
- Adding an index column
- Add Calculated Columns
- Creating a conditional column
Additional Data Sources
- How to load additional data tables
- Manually Entering Data
Maths Functions in Power Automate
- Using aggregates like sum, average, and count etc
- Changing the values in a column using addition, multiplication etc
- Basic Maths Functions in Power Automate
Introduction to Text and Time
- An introduction to text manipulation
- Basic Date and time functions
Power Query for Microsoft Excel
Introducing Power Query
- Importing data from an Excel spreadsheet
- What kind of data can Power Query Import
- What kind of data is best loaded into Power Query
- Uses of Power Query
Basic Data Manipulation
- Selecting which of the imported columns to load
- Removing duplicates rows from the data
- Removing excess rows from the imported data
- Changing the data type of a column
- Renaming a column
- Explaining and using Applied Steps
- Creating a calculated column
- Splitting a column in multiple columns
- Merge columns together
- Transposing and Unpivoting Data
- Adding an index column
- Add Calculated Columns
- Creating a conditional column
Additional Data Sources
- How to load additional data tables
- Manually Entering Data
Maths Functions in Power Automate
- Using aggregates like sum, average, and count etc
- Changing the values in a column using addition, multiplication etc
- Basic Maths Functions in Power Automate
Introduction to Text and Time
- An introduction to text manipulation
- Basic Date and time functions
There is no formal examination or assessment associated with this course. Instead, learners will develop and demonstrate their understanding through a series of practical exercises, hands-on activities and real-world data transformation scenarios completed throughout the training day. These activities are designed to help learners build confidence in importing, cleansing, transforming and combining data using Power Query, while applying the techniques covered during the course to realistic business situations. For learners seeking accredited Microsoft Office or Microsoft Excel qualifications, please contact us to discuss the certification and training options available.
There is no formal examination or assessment associated with this course. Instead, learners will develop and demonstrate their understanding through a series of practical exercises, hands-on activities and real-world data transformation scenarios completed throughout the training day. These activities are designed to help learners build confidence in importing, cleansing, transforming and combining data using Power Query, while applying the techniques covered during the course to realistic business situations. For learners seeking accredited Microsoft Office or Microsoft Excel qualifications, please contact us to discuss the certification and training options available.
- One day of instructor-led training delivered by NILC’s Microsoft-certified trainers
- Practice files and supporting resources used throughout the course
- Course recording provided after the training day (virtual live delivery only)
- NILC course completion certificate
- One day of instructor-led training delivered by NILC’s Microsoft-certified trainers
- Practice files and supporting resources used throughout the course
- Course recording provided after the training day (virtual live delivery only)
- NILC course completion certificate
Learners should have a good working knowledge of Microsoft Excel, including creating and working with spreadsheets, formulas and data tables. Previous experience of Power Query is not required.
Learners should have a good working knowledge of Microsoft Excel, including creating and working with spreadsheets, formulas and data tables. Previous experience of Power Query is not required.
Who is the Power Query for Microsoft Excel course suitable for?
The course is suitable for Excel users who regularly import, clean, combine or prepare data. It is particularly useful for administrators, analysts, finance professionals and anyone who spends significant time manually preparing spreadsheets for reporting or analysis.
Do I need previous Power Query experience?
No. Previous Power Query experience is not required. The course introduces Power Query from the beginning before progressing into more advanced data cleaning and transformation techniques.
What Excel experience should I have before attending?
You should have a good working knowledge of Microsoft Excel and be comfortable creating and working with spreadsheets, formulas and data tables. The course is Intermediate level, so it assumes you already understand the basic features of Excel.
Who is the Power Query for Microsoft Excel course suitable for?
The course is suitable for Excel users who regularly import, clean, combine or prepare data. It is particularly useful for administrators, analysts, finance professionals and anyone who spends significant time manually preparing spreadsheets for reporting or analysis.
Do I need previous Power Query experience?
No. Previous Power Query experience is not required. The course introduces Power Query from the beginning before progressing into more advanced data cleaning and transformation techniques.
What Excel experience should I have before attending?
You should have a good working knowledge of Microsoft Excel and be comfortable creating and working with spreadsheets, formulas and data tables. The course is Intermediate level, so it assumes you already understand the basic features of Excel.
Dates & Prices
No upcoming dates available.
Send course enquiryMicrosoft Excel Bundle
Save £67.50
Course Includes:
Microsoft Excel Introduction
Microsoft Excel Intermediate
Microsoft Excel Advanced
Create your own
Looking to do 2 or more courses? Contact us to create your own bundle
Can't find the course dates, location or delivery type you are looking for?
Fill out the request dates form above and we'll try our best to accommodate or contact us directly.
"*" indicates required fields
How we deliver our courses
Virtual
Our virtual courses allow you to access live instructor-led training from the same expert instructors that deliver our classroom courses, without leaving the comfort of your home or office. All virtual courses are fully interactive, and learners can communicate with their trainer and peers at any time.
Many of our virtual courses are also recorded, so you can recap over the content you learnt as many time as you wish.
Classroom
Our classroom courses allow you to learn and interact face-to-face with our expert instructors in a comfortable and modern training environment. All of our classroom based courses take place at NILC centers, or high quality training facilities, and include all required IT and physical equipment.
We also limit our class sizes to help promote better discussions and to ensure your learning experience is comfortable as possible.
Onsite
Save time and hassle by arranging for one of our expert instructors to come to you. Our onsite courses allow you to learn in a location of your choosing, and you can train as many or as few people as you want – from a single person or team to whole departments. We can also fully customize the course content to the specific requirements of your business or project.
We offer onsite courses throughout the UK and it can be a great team building opportunity for colleagues to come together, bond and discuss.
Online
Our Online Self Paced courses allow you to learn new skills from our expert instructors, in your own time and at your own pace. Our flexible online learning platform allows you to access content on your computer, tablet or mobile device, whether you’re on the move or at home. All our online courses come with immediate access and you can start learning straight away, from any internet enabled compatible device.
We also offer online email support from our expert instructors, so they’re always on hand and happy to help you with any questions which may arise.
Why choose NILC for your training?
Award-Winning Training with Industry-Leading Customer Satisfaction
Trusted Training Partner by Colleges, Government Organisations and Businesses
UK-Based Trainers with Real-World Industry Experience
Family-Run Business with Customer Service at Its Core
Rated Excellent on Trustpilot with 950+ Customer Reviews
Our learners rate us 'Excellent' on Trustpilot
Frequently Asked Questions
The course is suitable for Excel users who regularly import, clean, combine or prepare data. It is particularly useful for administrators, analysts, finance professionals and anyone who spends significant time manually preparing spreadsheets for reporting or analysis.
No. Previous Power Query experience is not required. The course introduces Power Query from the beginning before progressing into more advanced data cleaning and transformation techniques.
You should have a good working knowledge of Microsoft Excel and be comfortable creating and working with spreadsheets, formulas and data tables. The course is Intermediate level, so it assumes you already understand the basic features of Excel.
You will learn how to import, clean and transform data using Power Query. This includes removing unwanted data, changing data types, splitting and merging columns, creating calculated and conditional columns, and pivoting, unpivoting and transposing data.
Yes. One of the main benefits of Power Query is the ability to create repeatable data preparation processes. Once a query has been created, it can be refreshed when the underlying data changes, reducing the need to repeatedly perform the same manual data-cleaning tasks.
Yes. You will learn how to import and work with multiple data tables and combine information using Power Query. This can be particularly useful when working with data spread across different spreadsheets, tables or business reports.
Yes. Data cleansing is a key part of the course. You will learn techniques including removing duplicates and unwanted rows, correcting data types, renaming and splitting columns, and restructuring information into a more suitable format for analysis.
Excel formulas generally calculate or manipulate information within a worksheet, whereas Power Query is primarily designed to import, clean, transform and reshape data before it is analysed. Power Query can be particularly valuable when the same data preparation process needs to be repeated regularly.
Yes. The course combines trainer demonstrations with hands-on exercises and realistic data transformation scenarios. You will practise importing, cleansing, transforming and combining data throughout the training day.
Yes. Eligible learners may be able to access funding through ReAct+. Please contact NILC to discuss your eligibility.
Frequently Asked Questions
The course is suitable for Excel users who regularly import, clean, combine or prepare data. It is particularly useful for administrators, analysts, finance professionals and anyone who spends significant time manually preparing spreadsheets for reporting or analysis.
No. Previous Power Query experience is not required. The course introduces Power Query from the beginning before progressing into more advanced data cleaning and transformation techniques.
You should have a good working knowledge of Microsoft Excel and be comfortable creating and working with spreadsheets, formulas and data tables. The course is Intermediate level, so it assumes you already understand the basic features of Excel.
You will learn how to import, clean and transform data using Power Query. This includes removing unwanted data, changing data types, splitting and merging columns, creating calculated and conditional columns, and pivoting, unpivoting and transposing data.
Yes. One of the main benefits of Power Query is the ability to create repeatable data preparation processes. Once a query has been created, it can be refreshed when the underlying data changes, reducing the need to repeatedly perform the same manual data-cleaning tasks.
Yes. You will learn how to import and work with multiple data tables and combine information using Power Query. This can be particularly useful when working with data spread across different spreadsheets, tables or business reports.
Yes. Data cleansing is a key part of the course. You will learn techniques including removing duplicates and unwanted rows, correcting data types, renaming and splitting columns, and restructuring information into a more suitable format for analysis.
Excel formulas generally calculate or manipulate information within a worksheet, whereas Power Query is primarily designed to import, clean, transform and reshape data before it is analysed. Power Query can be particularly valuable when the same data preparation process needs to be repeated regularly.
Yes. The course combines trainer demonstrations with hands-on exercises and realistic data transformation scenarios. You will practise importing, cleansing, transforming and combining data throughout the training day.
Yes. Eligible learners may be able to access funding through ReAct+. Please contact NILC to discuss your eligibility.
Trusted By
Related Courses
Microsoft Power Apps Intermediate
Level: Intermediate
1 Day (9:30am-4:00pm)
Accredited: Available upon request
Funding: ReAct
Microsoft Excel Advanced
Level: Advanced
1 day (9:30am-3:00pm)
Accredited: Available upon request
Funding: ReAct
Microsoft Power Automate
Level: Foundation, Intermediate
1 Day (9:30am-4:00pm)
Accredited: Available upon request
Funding: ReAct