Microsoft Excel: Master Power Query Diploma

StudyHub

Add to wishlist

Duration / Course length: Upto 2 Hours Start now
Accredited by: CPD Qualification Standards
Certificates:
Sample certificate
Course delivery: This course is delivered in video format

Course details

Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you break free of your worries.

Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed.

The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis ;

The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot.

Learning Outcomes:

Acquire proficiency in using Excel Power Query for efficient data management.
Master the art of transforming raw data into actionable insights.
Learn advanced techniques for data manipulation and analysis.
Develop the ability to streamline complex data processes.
Enhance your analytical thinking and problem-solving skills.

COURSE CURRICULUM

Power Query Intro and Excel version
Excel Power Query – Introduction
Excel Power Query – Query Editor Ribbon
Transform Data – Trim in Excel Power Query
Transform Data – Format Dates and Values in Excel Power Query
Transform Data – Parsing URLs in Excel Power Query
Transform Data – Split Text Fields in Excel Power Query
Transform Data – Group By in Excel Power Query
Transform Data – Unpivoting Columns in Excel Power Query
Transform Data – Pivoting Columns in Excel Power Query
Transform Data – Split Columns into Other Columns in Excel Power Query
Transform Data – Filtering Rows in Excel Power Query
Transform Data – Sorting Columns in Excel Power Query
Transform Data – Transform and Add Columns in Excel Power Query
From Folder – Import From Folder in Excel Power Query
From Folder – Doing Auto Cleanup in Excel Power Query
From Folder – Extract Data from Forms in Excel Power Query
From Workbook – Extract Multiple Criteria in Excel Power Query From Workbook – Extract Multiple Worksheets in Excel Power Query
Joins – Intro to Joins
Joins – Merging
Joins – Full Outer Join
Joins – Right Anti Join
Power Query – Convert Reports into Pivot Tables
Modulo

Why study this course

Unlimited access to the course for a lifetime.
Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.
Structured lesson planning in line with industry standards.
Immerse yourself in innovative and captivating course materials and activities.
Assessments designed to evaluate advanced cognitive abilities and skill proficiency.
Flexibility to complete the Course at your own pace, on your own schedule.
Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.
Unlock career resources for CV improvement, interview readiness, and job success.

Certification

Upon course completion, a written assignment test is available. Pass the test to obtain a PDF certificate for 24 AED. Original hard copy certificates are available for an additional 38 AED. Updated on 05 April, 2024

Eligibility / Requirements

This Microsoft Excel: Master Power Query in 120 Minutes! does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.

Job roles this course is suitable for:

Data Analyst , Financial Analyst , Data Scientist , Market Research Analyst , Supply Chain Analyst

About StudyHub

Who Are We?

Studyhub is a premier online learning platform which aims to help individuals worldwide to realise their educational dreams. For 5 years, we have been dedicated to providing a comprehensive selection of high-quality courses designed to suit the needs of learners of all ages, backgrounds, and experience levels. We have over 1000 professionally made courses to support your career growth. More than 20000 students have chosen us as their learning platform. Born out of a passion for education and technological innovation, Studyhub has grown to become a hub for knowledge, skills acquisition, and career advancement. Our team of expert educators, industry professionals, and passionate individuals are committed to promoting a culture of effective learning. We believe in the transformative power of education, and our mission is to make the world a better place with the help of proper education.

Whether you're a student looking to enhance your academic performance or a professional seeking to expand your skillset, Studyhub is here to guide you on your learning path. Join our community today and embark on an exciting educational journey with us. Success awaits you!

Why Studyhub?

When you choose to study with Studyhub, you're investing in more than just a course—you're investing in your future. Our extensive collection of courses covers a wide array of subjects, each made with attention to detail and a clear focus on real-world applicability. We understand the dynamic nature of the global job market, and our courses reflect the most in-demand skills and knowledge areas. With us, you are not just learning; you are advancing towards your dreams.

Chance to get extensive training from industry expert instructors
Study anytime from anywhere at your own pace
Upskill and enhance your earning potential by completing a course and getting a CPD accredited certificate.
Satisfaction guaranteed

416 students have enrolled with StudyHub through Laimoon

See all StudyHub courses

Pay & enrol now