Complete Introduction to Excel Power Query

Learn to easily transform and prepare data for Microsoft Excel using Power Query

**** Updated June 2020 – This best selling Udemy Power BI course has been updated with new content ****

What you’ll learn

  • Learn how to use Excel Power Query to CONNECT and TRANSFORM data in Excel.
  • Have a COMPREHENSIVE understanding of connecting and transforming data using Excel 2016.
  • Load data into Excel from multiple DIFFERENT SOURCES such as SQL Server, CSV, XML, JSON and SQL Analysis Services.
  • Transform data by filtering, changing data types, removing columns and performing BASIC transformations.
  • Perform ADVANCED transformation such as Merging, Appending, Unpivoting, Grouping and custom calculations.
  • Learn to CLEAN data and LOAD data using parameters.
  • Lifetime access to course materials and practice activities from an experienced Udemy instructor.

Course Content

  • Introduction –> 4 lectures • 13min.
  • Perform Transformations –> 10 lectures • 48min.
  • Advanced Transformations –> 7 lectures • 32min.
  • Cleanse Data –> 5 lectures • 18min.
  • Connect to Data Sources –> 10 lectures • 30min.
  • Course Conclusion –> 1 lecture • 1min.

Complete Introduction to Excel Power Query

Requirements

  • You should be able to work with data in Excel and do basic reporting.
  • Excel 2016 or above.

**** Updated June 2020 – This best selling Udemy Power BI course has been updated with new content ****

Recent reviews:

“This course is really extremely useful to learn key concepts in a structured fashion. The concepts learned will save a lot of time in prepping data for further analysis from standardized say monthly spreadsheets that have data in columns where from an analysis point you would require rows. Just the concept of un-pivoting has paid for the course.”

“I am into certifications and this course is aligned to the MCSA BI Reporting!”

“Wonderful Power Query course. I highly recommend it!!!”

**** Lifetime access to course materials and practice activities.  ****

This course is presented by Ian Littlejohn – who with over 75 000 students is one of the most popular instructors on Udemy. Ian provides world leading courses on Excel, Power Pivot, Power BI and Google Data Studio.

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today’s business environment. Excel is now recognized as the most commonly used data analysis tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn to use Power Query to consume and transform data.

In this class (the first module of my 3 part “Excel Master Class” Series), you will cover:

  1. Introduction and Course Content
  2. Basic Data Transformations – Learn about filtering data, changing data types, adding new columns and removing columns
  3. Advanced Data Transformations – Merging data into one table, Appending data,  Grouping data, conditional rules and custom fields
  4. Data Cleansing – Techniques and skills to clean up your data
  5. Connecting to Data Sources – Learn how to connect and access data from a variety of different data sources including, files, databases, web URL and SQL Analysis Services

We look forward to having you on our course as we learn and explore the incredible power of Microsoft Excel.

Please note that this course is the first course in a series of three courses for the Excel Master Class series.  Search for my instructor profile to purchase these other courses.

  1. Course 1 – Power Query -Consume and Transform Data
  2. Course 2 – Power Pivot – Data Modeling and DAX Formulas
  3. Course 3 – Pivot Tables and Pivot Charts