Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (42m)
    • Power Query for Excel 2

      1:05
    • The Case study

      0:52
    • Connect and transform data from Excel workbooks

      10:37
    • Connect and transform .txt files

      5:03
    • Connect and transform web data with Excel Power Query

      14:19
    • Merge and analyse data

      9:54

About This Class

COURSE SUMMARY

Power Query is an Excel add-in, available in Excel 2010 Professional Plus and Excel 2013. In Excel 2016 it is known as Get and discover data. Power Query can be described as SQL for Excel users (without the need for knowing SQL). It allows uses find data from multiple sources, combine data, transform data, and make the data usable for reporting and data analytics.

LEARN HOW SET UP QUERIES TO EXTRACT DATA FROM MULTIPLE SOURCES, TRANSFORM DATA OF DIFFERENT TYPES AND LEARN HOW TO USE POWER QUERY TO AUTOMATE DAILY TASKS.

This course is broken down into 3 classes.

In the first class, we looked start at the very basics and learn how to set up Power Query. You also were given the sample data required for the this and the next classes.

In this class, the second class of this course works though a case study on how an organisation can use internal data of different file types, such as Text files and Excel files, and then combine this data with External data from the web to accurately calculate the potential market size, the actual market size and the portion of the market held by the company.  This case study will give you a solid working knowledge of Power Query.

In the Final Class we will look at some more advanced features of Power Query.  You will be introduced to the language use, which is known as M, you will learn how to query not just files of different types but also Folders of data. You will also learn how to sort “Bad Data” and user Power Query to automate reoccurring tasks.

1 of 1 students recommendSee All

Excellent class!

13

Students

--

Projects

Paula Guilfoyle

CPA, Online Educators, Lifelong Learner

Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.