Preview Advanced Excel with Power Query 2024 Version

Back

Power Query Material

Material

Introduction to Power Query

Getting Started With Basics Of Functions

Introduction to Basic Functions in Power Query

Loading Data in Power Query

Learning Basic Text Functions

Trim Text Functions

Split Text in Multiple Columns

Split Text with Delimiter

Adding Prefix & Suffix

Date Functions

Date Functions Weekdays

Calculate Age

Date Functions Start & End of Particular Date

Number Function

Text Functions

Date Functions

Number Functions

Assignment 2

Conditional Column & Column From Examples

Introduction to Conditional Column & Column From Example

Conditional Column on Numbers

Conditional Column on Text

Conditional Column on Dates

Comparing Columns with Conditional Column

Flash Fill with Column From Examples

Column From Examples - Split Text

Column From Examples - Merge Text

Column From Examples - Date

Column From Examples Extract Text

Conditional Column & Column From Examples

Assignment 3

Appending & Combing Files

Introduction to Appending or Combining Files

Combine Tables in One Table

Combine Multiple Table with Functions

Consolidate Multiple CSV Files

Combine Multiple Excel Files From Folder

Combine Multiple Data Sources

Append Queries

Assignment 4

Powerful Cleaning Features In Power Query

Introduction to Cleaning Data in Power Query

Fill Down Unmerged Cells

Promote & Demote Header

Removing Blank Rows

Data Types in Power Query

Dealing with Error Values

Transposing Data Set

Replacing Null Values

Group By in Power Query

Data Cleaning Part1

Data Cleaning Part2

Assignment 5

Replacing VLOOKUP With Merge Queries

Introduction to Replacing VLOOKUP

What is VLOOKUP in Excel

Merge Queries

Merge Two Tables

Merge Two Different Table From Two Different Excel Files

Merge Two Different Data Sources

Merge Queries with Multiple Matching Columns

Find Out Common Records From Two Tables

Merge Queries with No Common Columns

Fuzzy Match in Power Query

Challenge - Find Out Only Working Days

Solutions - Finding Working Days

Replacing VLOOKUP

Assignment 6

Working With Rows & Columns In Power Query

Introduction to Working With Rows & Columns

Remove Blank Records

Remove Duplicates Values

Remove Top or Bottom Rows

Keep Top or Bottom Rows

Remove Columns

Rename, Delete, Duplicate & Move Columns

Working with Rows & Columns

Assignment 7

Working With Filters & Parameters

Introduction to Working With Filters & Parameters

Filtering Textual Data

Filtering Date Data

Filtering Numerical Data

Sorting Data

Creating a Parameter

Connect Parameter With Dataset

Case Study - Filter Data Using Excel Cell Value

Working with Filters & Parameters

Assignment 8

Custom Function Feature To Clean & Combine Files

Introduction to Custom Function to Clean & Combine Files

Clean & Combine Multiple CSV Files

Clean & Combine Multiple Excel Files

Custom Function Features

Assignment 9

Getting Data From Different Sources

Get Data From Google Sheets

Get Data From XML Files

Get Data From MS Access

Get Data From JSON

Get Data From Website

Get Data From PDF, WEB & CSV

Object in Power Query

Introduction of Objects in Power Query

List in Power Query

Records in Power Query

Case Study - Creating Dynamic Calendars in PQ

Case Study - Extract Relevant Information

Case Studies

Introduction to Case Study in Power Query

Clean Bank Statement Available In PDF

Create Fiscal Year Calendar in Power Query

Matching Records in Two Tables

Pick Up The Latest File From The Folder

Technoedge Case Study

Cleaning Bank Financial Data

Changing Stacked Address Table

Split Data In Rows & Columns

Clean Data & Get Discounts

Cleaning Payroll Data

Get File Names From a folder

Excel Power Query to Power BI Power Query

Excel Power Query To Power BI Power Query

Power Query Project

Capstone Project

Project Template

Project 1

Project 2

Project 3

Project 4

Project 5

Preview - Advanced Excel with Power Query 2024 Version