- Courses
- Microsoft Excel
- Excel Power Query Introduction
Excel Power Query Introduction Training Course
Excel Power Query Introduction
This one-day course is ideal for anyone looking to simplify data cleaning and transformation in Excel. You'll discover how to filter, reshape, and consolidate data from multiple sources to create streamlined workflows and extract valuable insights for your team.
Not sure this is the right level? Compare all Microsoft Excel training courses.
- 1 day
- Virtual or on-site
- Private team training
Trusted by teams at
Course overview
Unlock the hidden potential of your data with this Excel Power Query Introduction course. In just one day, you’ll discover how to streamline your workflows, clean messy datasets, and turn raw data into meaningful insights, all without venturing into complex formulas or coding.
Perfect for Excel users with a basic grasp of tables and pivot tables, this course demystifies Power Query—an essential tool for anyone handling large datasets. If you're handling filtering, merging various sources, or creating calculated columns, you’ll gain practical skills to make everything more efficient.
Who it's for
- Excel users working with data
- Professionals responsible for data cleaning
- Anyone needing streamlined Excel reporting
What you need before you start
- Basic Excel knowledge
What you'll learn
What you will be able to do by the end of the course.
- Import and refresh data from various sources
- Filter and clean text, numeric, and date columns
- Rename, split, and reorder columns in Power Query
- Remove spaces and special characters from datasets
- Merge and append data from multiple sources
- Create calculated fields using Power Query
- Automate and consolidate data aggregation tasks
Course outline
6 modules across 1 day.
1Power Query Basics2 topics+
- What is Power Query?
- Exploring the Power Query Interface
2Importing Data2 topics+
- Importing Data from Various Sources
- Refreshing Imported Data
3Data Transformation Techniques4 topics+
- Filtering and Sorting Data
- Cleaning Text, Numeric, and Date Columns
- Renaming, Splitting, and Reordering Columns
- Removing Spaces and Special Characters
4Advanced Data Manipulation2 topics+
- Creating Calculated Fields
- Merging and Appending Data
5Introduction to M Language2 topics+
- Basics of the M Formula Language
- Creating Simple Power Query Formulas
6Aggregating Excel Worksheets2 topics+
- Consolidating Data from Multiple Worksheets
- Automating Worksheet Aggregation
Get a quote
Run Excel Power Query Introduction for your team
Delivered for your organisation alone, on a date you choose, online or at your offices.
Or call 0333 305 8855
What happens next
- 1We reply with available dates and a price for your team
- 2You pick a date that suits your team — we work around you
- 3We tailor the examples and exercises to the work your team does
- 4We confirm the delivery details and next steps in writing
Booked with a 100% money-back guarantee
Every course we run is covered. Book with confidence — if it isn’t right, you aren’t left out of pocket.
Why Future Savvy
Practical training, backed properly
Rated 4.72/5
From 696 reviews by learners and clients.
Money-back guarantee
A 100% money-back guarantee, for peace of mind.
Up to six learners
Small enough that every delegate gets trainer time on their own work.
Trainers who do the job
Practitioners who use these tools on real work, not career instructors.
Support after the course
Email your trainer when you hit something back at your desk.
What delegates say
Independently verified reviews, alongside quotes collected from delegates after their course.
I had a good experience with this Microsoft Excel training course! Mark the trainer was exceptionally knowledgeable, patient, and engaging, taking the time to explain complex functions and formulas in a way that was easy to understand. The pace of the class was well-managed, and there was plenty of opportunity to ask questions without feeling rushed. I left the session feeling much more confident, efficient, and equipped with time-saving shortcuts. Highly recommended for anyone looking to upgrade their spreadsheet skills!
good value for money, I understood notions that were very not clear to me. Thanks to Mark.
Very good communication and an excellent tutor.
Very happy with Mark's training ethos and training he provided.
Excellent course and really well presented. Starting from basic knowledge the course guided you through step by step and was well paced for all.
Really enjoyed the course. Tutor was knowledgeable, friendly and gave real-world, practical advice to get the most out of the training.
The trainer really tailored the course to our needs, encouraged us to ask questions, and was knowledgeable and really helpful.
The trainer was very patient and did not mind having to explain things a few times to make sure we were all on the same page, was very helpful for someone like myself who sometimes misses details on the first go around
Excellent trainer, the format of the training was fantastic and I got a lot from the course.
This was, by far, one of the best training courses I have had the pleasure of attending. The trainer was extremely knowledgeable and delivered a great course!
This was the first time I have joined an excel course and I found it very informative and very helpful.
I liked how the trainer tailored the training around what our needs and roles are.
A great pace for somebody just starting and never an issue with questions, and always had a good way of answering.
From knowing nothing to what I know now and in less than a day I would highly recommend as it was extremely useful, and has made my understanding of MP a 100x better. Thank you the trainer for the great lesson!
Excellent course, definitely the best 'power' course I have attended. The trainer was enthusiastic about the material and kept it relevant to our needs
The trainer was really knowledgeable and extremely helpful in helping us to build our own reports.
It was very productive as a working session. I learnt a lot.
His careful delivery of the course really made the difference not only in its usefulness but in how well we, as learners, will retain and apply this new information.
Verified reviews are published on our Reviews.io profile, where anyone can read every one of them.
Frequently asked questions
Who should attend this Excel Power Query Introduction course?+
This course is designed for Excel users who regularly work with data, whether that's for reporting, analysis, or cleaning up spreadsheets. If you manage data in Excel and would like your day to run a little more smoothly, this session is for you.
Do I need advanced Excel knowledge to benefit from this course?+
Not at all. A basic understanding of Excel tables and pivot tables is handy, but we do not expect you to be an expert. Everything is explained step by step.
What practical skills will I learn?+
You’ll learn how to import, clean, transform, and consolidate data using Power Query, all within Excel. By the end of the course, you’ll have the confidence to automate repetitive tasks and reduce manual data wrangling.
Is Power Query available in my version of Excel?+
Power Query is available in Excel 2010 and newer versions. If you’re using anything recent, you’re good to go. If you’re not sure, we can help you check.
Can I bring my own datasets to the training?+
Certainly. If you have specific data challenges, bring a sample (with sensitive information removed) and we’ll help you see how Power Query could help.
Will the course cover any coding or advanced formulas?+
There’s no need to be afraid of code. The course is focused on Power Query’s visual tools. We’ll introduce you to the basics of M language, but nothing overly technical or intimidating.
What difference will this make to my organisation?+
Your team will become far more efficient at handling and cleaning data, freeing up time for more valuable work and reducing the risk of human error. Less hair-pulling, more insight.
Training where your team works
Microsoft Excel training by location
See local delivery details, nearby course options and practical information for your area.
