Ultimate Excel Course #12 - Get & Transform Data with Power Query | Alan Murray | Skillshare

Ultimate Excel Course #12 - Get & Transform Data with Power Query

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
9 Lessons (1h 37m)
    • 1. Introduction

      3:46
    • 2. Transforming Messy Data on a Worksheet - First Example of Power Query Magic

      21:28
    • 3. The Incredible Unpivot Feature of Power Query - Real Game Changer

      7:01
    • 4. Working with International Dates and Number Values

      10:03
    • 5. Merge Queries - A VLOOKUP Alternative

      10:03
    • 6. Merge Queries - Exploring other Join Kinds

      6:15
    • 7. Combine and Append Multiple Worksheets into One

      10:32
    • 8. Import Importing Multiple Files from a Folder into One List - Incredibly Useful

      15:07
    • 9. Import Data from the Web

      12:46

About This Class

e774afb4

This class is #12 in a series called the Ultimate Excel Course.

In this class you will learn how to use the magic of Power Query in Excel. Power Query has changed the way that we import, shape and load data into Excel. And if you are not familiar with it, you want to get up to speed FAST.

It was introduced with the 2010 version of Excel as an add-in. In Excel 2016 it became part of the Excel, so no add-ins required. So if you have 2016 great. If not just quickly Google and install the add-in. Takes 30 seconds.

This class will really show you the incredible power of this feature and why I think it must be learnt by all Excel users. It seriously is a game-changer. And this course really just skims the surface of its capabilities, but will really open your eyes.

During the class we will use it to import data from the web, text files, from a folder in a directory and even combine multiple worksheets into 1 with the click of a button.

Power Query makes importing, cleaning and transforming data as easy as any other skill in Excel. You won't need intense formulas (although they can be done also).

The Excel files used during the class are provided so that you can follow along. You can then take on the project exercise to test your skills in action.

Please post any questions in the discussion area and I will get back to you.

Grab a coffee, enrol and let's do this.

Please note that this is class #12 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #1 - Excel Formulas Made Easy - Get up to Speed with Excel Formulas Fast

Class #2 - Essential Skills for Working with Large Spreadsheets

Class #3 - Logical Functions - The Decision Making Formulas of Excel

Class #4 - Conditional Formatting: Make your Data Come to Life

Class #5 - Lookup Functions - The Powerful VLOOKUP Function and Beyond

Class #6 - Validating and Protecting Excel Data

Class #7 - Advanced Formulas for Analysing Data

Class #8 - Excel Charts for Simple and Effective Data Presentation

Class #9 - Cleaning and Preparing Data Ready for Analysis

Class #10 - Formatting your Data Ranges as Tables for Superior Management

Class #11 - Master PivotTables for Powerful Analysis and Reporting

Class #12 - Get & Transform Data with Power Query

Class #13 - Introduction to the Data Model and PowerPivot

50

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Alan Murray

IT Trainer, Coffee Lover and Lifelong learner

Hello, my name is Alan Murray and I have been training and consulting in Excel now for over 17 years. I have had the pleasure in helping individuals and businesses from all around the world improve their Excel skills.

I set up Computergaga about 8 years ago to help spread the latest Excel tips and to engage with other Excel experts and learners. It has grown beyond my expectations and I hope to get the chance to speak with many of you soon.

I have a real passion for Excel and I ...

See full profile

Report class