-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Microsoft Excel: Master Power Query in 120 Minutes!
Microsoft Excel: Master Power Query in 120 Minutes!
£29 ex Vat
Take This Course OR
1 Year Access 
Intermediate
32 Students -
2 hours, 25 minutes
get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer
Learning Outcome
- Learn about the fundamentals of power query and the query editor ribbon.
- Know how to trim in excel power query.
- Understand how to format dates and values in excel power query.
- Parse URLs in excel power query.
- Understand split text fields.
- Learn to unpivot columns.
- Learn about “Group by” in power query.
Description
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 need.to 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 needs.
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.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of:
- Online study materials
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Will i receive a certificate of completion?
Upon successful completion, you will qualify for the uk and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your pdf certificate at a cost of £9 and hardcopy certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your cv with key skills and an accredited qualification attesting to your knowledge.
The microsoft excel: master power query in 120 minutes! Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the english language, numeracy and it, and to be over the age of 16.
Requirements
Our microsoft excel: master power query in 120 minutes! Course is fully compatible with any kind of device. Whether you are using windows computer, mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
Course Curriculum
| Microsoft Excel: Master Power Query in 120 Minutes! | |||
| Power Query Intro and Excel version | 00:03:00 | ||
| Excel Power Query – Introduction | 00:03:00 | ||
| Excel Power Query – Query Editor Ribbon | 00:09:00 | ||
| Transform Data – Trim in Excel Power Query | 00:05:00 | ||
| Transform Data – Format Dates and Values in Excel Power Query | 00:02:00 | ||
| Transform Data – Parsing URLs in Excel Power Query | 00:05:00 | ||
| Transform Data – Split Text Fields in Excel Power Query | 00:10:00 | ||
| Transform Data – Group By in Excel Power Query | 00:03:00 | ||
| Transform Data – Unpivoting Columns in Excel Power Query | 00:05:00 | ||
| Transform Data – Pivoting Columns in Excel Power Query | 00:02:00 | ||
| Transform Data – Split Columns into Other Columns in Excel Power Query | 00:04:00 | ||
| Transform Data – Filtering Rows in Excel Power Query | 00:05:00 | ||
| Transform Data – Sorting Columns in Excel Power Query | 00:02:00 | ||
| Transform Data – Transform and Add Columns in Excel Power Query | 00:07:00 | ||
| From Folder – Import From Folder in Excel Power Query | 00:07:00 | ||
| From Folder – Doing Auto Cleanup in Excel Power Query | 00:13:00 | ||
| From Folder – Extract Data from Forms in Excel Power Query | 00:13:00 | ||
| From Workbook – Extract Multiple Criteria in Excel Power Query | 00:05:00 | ||
| From Workbook – Extract Multiple Worksheets in Excel Power Query | 00:04:00 | ||
| Joins – Intro to Joins | 00:04:00 | ||
| Joins – Merging | 00:08:00 | ||
| Joins – Full Outer Join | 00:06:00 | ||
| Joins – Right Anti Join | 00:09:00 | ||
| Power Query – Convert Reports into Pivot Tables | 00:05:00 | ||
| Modulo | 00:06:00 | ||
| Order Your Certificate | |||
| Order Your Certificate Now | 00:00:00 | ||
COPYRIGHT © 2022 One Education
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add