couses.ie logo

Basics of Power Query

Online
1.5-3 hours
Free

Course Content

Learn how to extract and transform data using Power Query for Microsoft Excel with this free online course. Power Query is a free add-in tool in Microsoft Excel 2010 and 2013 for Windows, and it has been fully integrated into the 2016 version too. This free online Microsoft Excel tutorial focuses on Power Query's core functions, like data extraction, transformation, and reshaping. You will discover new ways to process data by learning how to connect multiple data sources and perform transformations within the data before creating reports.

Course Details

CollegeAlison
Course ID201750
Course TypeOnline Learning
Course QualificationCPD Certificate
Course Duration1.5-3 hours
Course FeeFree
Entry RequirementsLike all courses on the Alison Free Learning platform this is a free, CPD-accredited course. A Graduate can choose to buy a certificate or diploma upon successful completion of a course, but this is not required or necessary.

At Alison we believe that free education, more than anything, has the power to break through boundaries and transform lives.

Alison is the world’s largest free online empowerment platform for education and skills training, offering over 5000 CPD accredited courses and a range of impactful career development tools. It is a for-profit social enterprise dedicated to making it possible for anyone, to study anything, anywhere, at any time, for free online, at any subject level. Through our mission, we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone.
Career PathWhat You Will Learn In This Free Course
• Discuss the history of the Microsoft Excel Power Query tool
• Explain the process of manipulating data with Power Query in Excel
• Summarize the steps for wrangling data to solve various problems
• Define the concept of M code
• Indicate the process of locating the M code
• Outline the Power Query features and items
• List the stages involved in merging several datasets from various systems
• Describe how to change the sample file
• Summarize the process of combining data from other folders
Course Code3964

Other Courses Offered by "Alison"

Diploma in International Tourism including English Language Studies

Learn about the exciting career opportunities in the modern tourism industry with this free online course.

6-10 hours

Soundtrack Composer Masterclass: Score Films and Video Games

Compose epic music soundtracks scores for film, TV, and video games with this free online course.

4-5 hours

Behavior Change Models for Health Promotion: Intrapersonal Models

In this free online course, you will learn how behavior change models are used to design health promotion programs.

1.5-3 hours

Concierge: Roles, Work Environment and Etiquettes

Master the skills of a concierge and learn their exciting roles across various sectors in this free online course.

1.5-3 hours
Ready to Get Started?
Courses.ie © 2026
© Jazbury Ltd T/A Courses.ie. Reg in Ireland No 293988. All Rights Reserved.
Proudly designed by Wikid
home