• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel: Master Power Query in 120 Minutes!

Microsoft Excel: Master Power Query in 120 Minutes!

By Studyhub UK

4.5(3)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 2 hours 25 minutes

  • All levels

Description

Overview

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.

Learning Outcomes:

  1. Acquire proficiency in using Excel Power Query for efficient data management.

  1. Master the art of transforming raw data into actionable insights.

  1. Learn advanced techniques for data manipulation and analysis.

  1. Develop the ability to streamline complex data processes.

  1. Enhance your analytical thinking and problem-solving skills.

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 certification 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
  1. Unlimited access to the course for a lifetime.

  1. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.

  1. Structured lesson planning in line with industry standards.

  1. Immerse yourself in innovative and captivating course materials and activities.

  1. Assessments designed to evaluate advanced cognitive abilities and skill proficiency.

  1. Flexibility to complete the Course at your own pace, on your own schedule.

  1. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.

  1. Unlock career resources for CV improvement, interview readiness, and job success.

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.

Career paths
  1. Data Analyst: £25,000 - £40,000 Per Annum

  1. Business Analyst: £30,000 - £50,000 Per Annum

  1. Financial Analyst: £28,000 - £45,000 Per Annum

  1. Marketing Analyst: £24,000 - £40,000 Per Annum

  1. Operations Analyst: £26,000 - £42,000 Per Annum

  1. Management Consultant: £35,000 - £55,000 Per Annum

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

About The Provider

Studyhub UK
Studyhub UK
London, England
4.5(3)

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...

Read more about Studyhub UK

Tags

Reviews