Excel Power Query Crash Course

Simpliv

Course

Online

£ 10 VAT inc.

The best Other Education courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

When the daunting task of 'cleaning up data' comes across your desk, are you using the amazing features of Excel's Power Query? This is a somewhat new feature, it first made its entrance in Excel 2010, and now is a standard part of Excel 2016 and 2019. In this crash course, you will learn how to find Power Query, load data into it, begin the process of transforming your redundant tasks (one last time!), and then how to Save and Load the Query to Excel to finish your reports.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

How to begin a Power Query
How to Extract data from your Source files into the Power Query
How to Transform the data (clean it up)
View a few examples of the Transform process
Learn the power of the Query Settings and the Advanced Editor
How to Load the data and Save the Excel file
And finally, how to re-open and edit the Power Query Settings

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Excel
  • MS Excel

Course programme

Introduction To The Course 12 lectures 37:46 Lesson 01 - Introduction to Power Query Lesson 02 - Get Data and Screen Overview Lesson 03 - How To Change Source Lesson 04 - How To Fix Mistakes Lesson 05 - Introduction To Conditional Columns Lesson 06 - Edit Query Settings Lesson 07 - Close And Load To Save Lesson 08 - 10 Conditions in One Step Lesson 09 - Format Numbers And Dates Lesson 10 - Example of a Conditional Columns Lesson 11 - Advanced Editor Lesson 12 - Final Overview Introduction To The Course 12 lectures 37:46 Lesson 01 - Introduction to Power Query Lesson 02 - Get Data and Screen Overview Lesson 03 - How To Change Source Lesson 04 - How To Fix Mistakes Lesson 05 - Introduction To Conditional Columns Lesson 06 - Edit Query Settings Lesson 07 - Close And Load To Save Lesson 08 - 10 Conditions in One Step Lesson 09 - Format Numbers And Dates Lesson 10 - Example of a Conditional Columns Lesson 11 - Advanced Editor Lesson 12 - Final Overview Lesson 01 - Introduction to Power Query Lesson 01 - Introduction to Power Query Lesson 01 - Introduction to Power Query Lesson 01 - Introduction to Power Query Lesson 02 - Get Data and Screen Overview Lesson 02 - Get Data and Screen Overview Lesson 02 - Get Data and Screen Overview Lesson 02 - Get Data and Screen Overview Lesson 03 - How To Change Source Lesson 03 - How To Change Source Lesson 03 - How To Change Source Lesson 03 - How To Change Source Lesson 04 - How To Fix Mistakes Lesson 04 - How To Fix Mistakes Lesson 04 - How To Fix Mistakes Lesson 04 - How To Fix Mistakes Lesson 05 - Introduction To Conditional Columns Lesson 05 - Introduction To Conditional Columns Lesson 05 - Introduction To Conditional Columns Lesson 05 - Introduction To Conditional Columns Lesson 06 - Edit Query Settings Lesson 06 - Edit Query Settings Lesson 06 - Edit Query Settings Lesson 06 - Edit Query Settings Lesson 07 - Close And Load To Save Lesson 07 - Close And Load To Save Lesson 07 - Close And Load To Save Lesson 07 - Close And Load To Save Lesson 08 - 10 Conditions in One Step Lesson 08 - 10 Conditions in One Step Lesson 08 - 10 Conditions in One Step Lesson 08 - 10 Conditions in One Step Lesson 09 - Format Numbers And Dates Lesson 09 - Format Numbers And Dates Lesson 09 - Format Numbers And Dates Lesson 09 - Format Numbers And Dates Lesson 10 - Example of a Conditional Columns Lesson 10 - Example of a Conditional Columns Lesson 10 - Example of a Conditional Columns Lesson 10 - Example of a Conditional Columns Lesson 11 - Advanced Editor Lesson 11 - Advanced Editor Lesson 11 - Advanced Editor Lesson 11 - Advanced Editor Lesson 12 - Final Overview Lesson 12 - Final Overview Lesson 12 - Final Overview Lesson 12 - Final Overview

Additional information

This is an advanced level course for Excel users that find themselves repeating data-clean-up tasks

See related categories

Excel Power Query Crash Course

£ 10 VAT inc.

The best Other Education courses

See all

See all