Skip to content

Microsoft Excel Power Query

*Special GIFTs: FREE Time Management Course + Career Guidelines | Free PDF Certificate Included

Course Drive

Summary

Price
£12 inc VAT
Study method
Online, On Demand What's this?
Duration
3.2 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed Courses Certificate of Completion - Free
Additional info
  • Tutor is available to students

Add to basket or enquire

Overview

Our Microsoft Excel Power Query course is designed for professionals who want to thrive in their profession. The course covers all the essential skills and knowledge needed to become specialised in this sector. You will learn real-life knowledge and expertise from the industry experts and practitioners from the Microsoft Excel Power Query course.

The Microsoft Excel Power Query course starts with the basic knowledge of Microsoft Excel Power Query and gradually shares expertise and knowledge. In this course, you will get a complete idea of Microsoft Excel Power Query with key concepts, strategies regarding use of it and in-depth knowledge. The Microsoft Excel Power Query course is completely an online course. You can access this course from any part of the world with just a smart device and the internet.

By the end of this course, you will get complete knowledge and marketable skills. The course also comes with a certificate, which will add extra value to your resume and help you stand out in the job market.

In short, the Microsoft Excel Power Query course is the perfect course to fast-track your career. So, why are you waiting? Enrol in this course today!

Certificates

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Curriculum

2
sections
36
lectures
3h 11m
total

    • 1: 00 - Power Query Intro and Excel version 03:04
    • 2: 01 - Power Query and Query Editor Ribbon 08:38
    • 3: 02 - Trim 05:26
    • 4: 03 - Format Dates and Values 02:15
    • 5: 04 - Parsing URLs 05:25
    • 6: 05 - Split Text Fields 09:34
    • 7: 06 - Group By 02:57
    • 8: 07 - Import From Folder 06:32
    • 9: 08 - Doing Auto Cleanup 06:56
    • 10: 09 - Extract Data from Forms 13:25
    • 11: 10 - Extract - Multiple Criteria 04:39
    • 12: 11 - Extract Multiple Worksheets 04:03
    • 13: 12 - Unpivoting Columns 05:19
    • 14: 13 - Pivoting Columns 02:18
    • 15: 14 - Split Columns into Other Columns 04:04
    • 16: 15 - Filtering Rows 05:03
    • 17: 16 - Sorting Columns 02:20
    • 18: 17 - Transform and Add Columns 06:41
    • 19: 18 - Intro to Joins 03:31
    • 20: 19 -Merging 07:42
    • 21: 20 - Full Outer Join 05:43
    • 22: 21 - Right Anti Join 08:50
    • 23: 22 - Convert Reports into Pivot Tables 05:03
    • 24: 23 - Modulo 05:44

    • 25: 01 - M Introduction 02:41
    • 26: 02 - Enabling M in Power Query 02:18
    • 27: 03 - Simple Expressions 07:35
    • 28: 03b - Simple Expressions - Nested Expressions 02:54
    • 29: 04 - Variables 07:59
    • 30: 05 - Functions 06:05
    • 31: 05b - Functions - Reusable Functions 02:12
    • 32: 05c - Functions - Invoking 00:35
    • 33: 06 - Passing Functions 08:11
    • 34: 06b - Passing Functions - keyword each 02:40
    • 35: 07 - Finding the list of M functions 02:28
    • 36: 08 - Using M Functions 09:58

Course media

Description

You will be able to do the following after completing this course:
  • Become more productive at using Excel Power Query, which will SAVE YOU HOURS daily & eliminate stress at work!
  • Increase your Excel & Power Query skills and knowledge within hours, which will get you noticed by Top Management & prospective employers!
  • Learn the various Data Analytical tools within Excel to easily find & clean your data such as Text to Columns, Remove Duplicates, Find & Replace, Go to Special, Text to Columns, Sort &
  • Filter plus much more
  • Discover the Power of Excel Tables to give colour and analytical Power to your boring lists
  • Understand in what situations you need to use Excel Formulas v Excel Analytical Tools
  • We teach you how to use Excel Power Query with confidence that will lead to greater opportunities like a higher salary and promotions!
  • Use Text, Lookup & Logical Formulas & Functions to pull data out & reorganize it to your desired outcome
  • Use Conditional Formatting to find hidden and hard-to-find data
  • Learn the various techniques within Power Query/Get & Transform to shape your data & consolidate reports without the need to use Formulas or Macros
Why Choose the Microsoft Excel Power Query course?
  • Conducted by industry experts
  • Get Instant E-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified professionals
  • Self-paced learning and laptop, tablet, and smartphone-friendly
  • Tutor Support

Who is this course for?

  • People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
  • People who want to change career and apply for a new job
  • If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Requirements

No prior Power Query knowledge is required

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Business administration courses, Microsoft courses, Online courses