• 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 Skill Up

4.8(9)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 2 hours 26 minutes

  • All levels

Description

Experience Microsoft Excel like never before with our comprehensive 120-minute course, Microsoft Excel: Master Power Query in 120 Minutes. Advanced data manipulation techniques are introduced in the first module, which covers the fundamentals of Power Query in Microsoft Excel. The ability to effectively transform data in Microsoft Excel is a crucial skill for every data analyst, and it will be covered in this course. This is a major topic covered in Module 2.

The middle modules, 'From Folder' and 'From Workbook,' guide you through integrating multiple data sources in Microsoft Excel. This knowledge is crucial for handling real-world data scenarios where information is scattered across different files and formats. Module 05, 'Joins,' takes you deeper into Microsoft Excel's capabilities, teaching you to merge data from various sources seamlessly.

The last module solidifies your understanding of Power Query in Microsoft Excel, enabling you to tackle challenging data projects. By the time this course ends, you will be able to manipulate and analyse data like an expert because of your newfound expertise with Microsoft Excel.

Learning outcome
  • Grasp the fundamentals of Power Query in Microsoft Excel.

  • Transform data effectively using Microsoft Excel.

  • Integrate data from folders using Microsoft Excel tools.

  • Merge information from multiple workbooks in Microsoft Excel.

  • Master various joins in Microsoft Excel for comprehensive data analysis.

  • Develop advanced Power Query skills in Microsoft Excel.

  • Enhance data handling and analytical skills in Microsoft Excel.

Why should I take this course?
  • Become proficient in Power Query, a vital Microsoft Excel feature.

  • Learn data transformation techniques in Microsoft Excel for better analysis.

  • Master integrating diverse data sources in Microsoft Excel.

  • Gain expertise in advanced data manipulation using Microsoft Excel.

  • Boost your career prospects with Microsoft Excel skills.

Career Path
  • Data Analyst

  • Financial Analyst

  • Business Intelligence Developer

  • Research Analyst

  • Marketing Analyst

  • Operations Manager

  • Project Coordinator

Requirements
  • No formal qualifications required, anyone from any academic background can take this course.

  • Access to a computer or digital device with internet connectivity.

Course Curriculum

Module 01: Introduction

โ–ถ

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

Module 02: Transform Data

โ–ถ

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

Module 03: From Folder

โ–ถ

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

Module 04: From Workbook

โ–ถ

From Workbook - Extract Multiple Criteria in Excel Power Query

๐Ÿ• 00:05:00

โ–ถ

From Workbook - Extract Multiple Worksheets in Excel Power Query

๐Ÿ• 00:04:00

Module 05: Joins

โ–ถ

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

Module 06: Power Query

โ–ถ

Power Query - Convert Reports into Pivot Tables

๐Ÿ• 00:05:00

โ–ถ

Modulo

๐Ÿ• 00:06:00

About The Provider

Skill Up
Skill Up
4.8(9)

Skill Up presents a rigorous online education experience, helping you obtain industry-relevant skills certified by the worldโ€™s...

Read more about Skill Up

Tags

Reviews