Introduction

Sample data

How to get Power Query

Get data

Combine data

Main Power Query interface

Transform data

Applied steps

Close & Load

Data imported into Excel

Insert pivot table & chart

Importing additional data

Wrap up

Data Sources

Excel's Most Powerful Tools

Cleaning Data

What this course is about

Problems with Data

What is ETL?

Where can we get our data from?

What is Transform?

Where can we load Power Query?

One Click Refresh

Power Query Benefits

Transform and Clean Data

Bonus Benefit of Power Query

How Big is the Data?

How would we solve this without Power Query?

Using the MID function

Pivot Tables

Expand Pivot Source

Importing the master file

Power Query Simplicity

Introduction

Benefits of Power Query

Power Query Process

Conclusions

Power Query

Power Query Editor

Query Settings

Advanced Editor

Combine

Pivot Columns

Convert a Column to a List

Conditional Columns

Custom Function

Enable Include and Report Refresh

Where to find Power Query in Excel

Splitting a column by delimiter

Extracting the surname

Import and Rearrange Data

Removing Columns

Load to a table

Power Query Example

Inserting a Pivot Table

Transforming data from Excel to Power Query

Conclusion

Power Query

Getting Data from Multiple Data Sources

Reordering Columns

Applied Steps

Custom Column Formula

Return the Number of Characters in a Text Value

Cleaning

Text Column Extract

Pros and Cons

Do You Want To Learn Vba At All

Hidden features your Excel Power Query you had this whole time

Power Query Editor Excel Shortcut

Quick Access Toolbar in Power Query

New Course: Automate with Power Query from Leila

Properly Enter M-Functions in Power Query Editor

Zoom-in and out Shortcut Keys in PQ Editor

Automatically Sort Column Headers

Import Entire File Content in Power Query

Add Table Name to QAT-Bar in Excel

Copy & Paste Power Queries to Different Excel Files

Add Slicers to Tables

Adjust Refresh Settings in Excel

Wrap Up

Power Query

Sum

Sum Function

Query Functions

Compare Excel to Power Query

Merge Columns

Prefix

Introduction to Power Query in Excel

What is Power Query?

Where do you find Power Query?

How to import data from the web with Power Query

How to import data from a range or table in Power Query

Power Query Editor layout

Make changes to your headers

Examining the applied steps

How to convert data types in the Power Query Editor

Remove unwanted rows (filtering)

How to split columns in Power Query

Create a new column

Create a new column to find a value

Rounding and moving column

How to merge queries and join tables in Power Query

Add new data, then refresh your query

Start of Video

Tip 1: Folders & Notes

Tip 2: Formula Bar / Column Statistics

Tip 3: Copying Queries

Tip 4: References & Parameters

Tip 5: Maintaining Query Folding

Intro

What is Power Query?

Where to do data transformations

Resources

Power Query Academy

Advanced Power Query

Where to learn more about Power Query

Power Query Courses

Conclusion

Current View

Power Query

Data Source Settings

Manage Parameters

Choose Columns

Keep Row and Remove Rows

Group by

Use the First Row as Headers

Append Operation

Combine Files

Welcome

Advantages of Power Query

Connecting to an Excel file

Connect to a new data source

Refreshing the data

What else can Power Query do for you?

How to keep a copy of every month's report

Formatting

Sharing the Report

Outline

Intro

What I'll cover in this video

Transforming columns

Duplicate columns

Dynamic Parameters

Getting a List of Years

Convert to Table

Invoke a function

Conclusion

Intro

Transform Data

Editing steps

Transforming columns

Advanced editor

Viewing the data

Conclusion