Complete Introduction to Excel Power Query

Quickly & effectively learn to transform and prepare data for Microsoft Excel using Power Query

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

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

Description
**** 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:

Introduction and Course Content

Basic Data Transformations - Learn about filtering data, changing data types, adding new columns and removing columns

Advanced Data Transformations - Merging data into one table, Appending data, Grouping data, conditional rules and custom fields

Data Cleansing - Techniques and skills to clean up your data

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.

Course 1 - Power Query -Consume and Transform Data

Course 2 - Power Pivot - Data Modeling and DAX Formulas

Course 3 - Pivot Tables and Pivot Charts

Who this course is for:
Excel users who want to learn how to IMPORT and TRANSFORM data in Excel
Learners who want to learn ADVANCED techniques for preparing data for analysis