arrow_back
Back
lock
Power Query Material
lock
Material
lock
Introduction to Power Query
lock
Getting Started With Basics Of Functions
lock
Introduction to Basic Functions in Power Query
lock
Loading Data in Power Query
lock
Learning Basic Text Functions
lock
Trim Text Functions
lock
Split Text in Multiple Columns
lock
Split Text with Delimiter
lock
Adding Prefix & Suffix
lock
Date Functions
lock
Date Functions Weekdays
lock
Calculate Age
lock
Date Functions Start & End of Particular Date
lock
Number Function
lock
Text Functions
lock
Date Functions
lock
Number Functions
lock
Assignment 2
lock
Conditional Column & Column From Examples
lock
Introduction to Conditional Column & Column From Example
lock
Conditional Column on Numbers
lock
Conditional Column on Text
lock
Conditional Column on Dates
lock
Comparing Columns with Conditional Column
lock
Flash Fill with Column From Examples
lock
Column From Examples - Split Text
lock
Column From Examples - Merge Text
lock
Column From Examples - Date
lock
Column From Examples Extract Text
lock
Conditional Column & Column From Examples
lock
Assignment 3
lock
Appending & Combing Files
lock
Introduction to Appending or Combining Files
lock
Combine Tables in One Table
lock
Combine Multiple Table with Functions
lock
Consolidate Multiple CSV Files
lock
Combine Multiple Excel Files From Folder
lock
Combine Multiple Data Sources
lock
Append Queries
lock
Assignment 4
lock
Powerful Cleaning Features In Power Query
lock
Introduction to Cleaning Data in Power Query
lock
Fill Down Unmerged Cells
lock
Promote & Demote Header
lock
Removing Blank Rows
lock
Data Types in Power Query
lock
Dealing with Error Values
lock
Transposing Data Set
lock
Replacing Null Values
lock
Group By in Power Query
lock
Data Cleaning Part1
lock
Data Cleaning Part2
lock
Assignment 5
lock
Replacing VLOOKUP With Merge Queries
lock
Introduction to Replacing VLOOKUP
lock
What is VLOOKUP in Excel
lock
Merge Queries
lock
Merge Two Tables
lock
Merge Two Different Table From Two Different Excel Files
lock
Merge Two Different Data Sources
lock
Merge Queries with Multiple Matching Columns
lock
Find Out Common Records From Two Tables
lock
Merge Queries with No Common Columns
lock
Fuzzy Match in Power Query
lock
Challenge - Find Out Only Working Days
lock
Solutions - Finding Working Days
lock
Replacing VLOOKUP
lock
Assignment 6
lock
Working With Rows & Columns In Power Query
lock
Introduction to Working With Rows & Columns
lock
Remove Blank Records
lock
Remove Duplicates Values
lock
Remove Top or Bottom Rows
lock
Keep Top or Bottom Rows
lock
Remove Columns
lock
Rename, Delete, Duplicate & Move Columns
lock
Working with Rows & Columns
lock
Assignment 7
lock
Working With Filters & Parameters
lock
Introduction to Working With Filters & Parameters
lock
Filtering Textual Data
lock
Filtering Date Data
lock
Filtering Numerical Data
lock
Sorting Data
lock
Creating a Parameter
lock
Connect Parameter With Dataset
lock
Case Study - Filter Data Using Excel Cell Value
lock
Working with Filters & Parameters
lock
Assignment 8
lock
Custom Function Feature To Clean & Combine Files
lock
Introduction to Custom Function to Clean & Combine Files
lock
Clean & Combine Multiple CSV Files
lock
Clean & Combine Multiple Excel Files
lock
Custom Function Features
lock
Assignment 9
lock
Getting Data From Different Sources
lock
Get Data From Google Sheets
lock
Get Data From XML Files
lock
Get Data From MS Access
lock
Get Data From JSON
lock
Get Data From Website
lock
Get Data From PDF, WEB & CSV
lock
Object in Power Query
lock
Introduction of Objects in Power Query
lock
List in Power Query
lock
Records in Power Query
lock
Case Study - Creating Dynamic Calendars in PQ
lock
Case Study - Extract Relevant Information
lock
Case Studies
lock
Introduction to Case Study in Power Query
lock
Clean Bank Statement Available In PDF
lock
Create Fiscal Year Calendar in Power Query
lock
Matching Records in Two Tables
lock
Pick Up The Latest File From The Folder
lock
Technoedge Case Study
lock
Cleaning Bank Financial Data
lock
Changing Stacked Address Table
lock
Split Data In Rows & Columns
lock
Clean Data & Get Discounts
lock
Cleaning Payroll Data
lock
Get File Names From a folder
lock
Excel Power Query to Power BI Power Query
lock
Excel Power Query To Power BI Power Query
lock
Power Query Project
lock
Capstone Project
lock
Project Template
lock
Project 1
lock
Project 2
lock
Project 3
lock
Project 4
lock
Project 5
Preview - Advanced Excel with Power Query 2024 Version
Discuss (
0
)
navigate_before
Previous
Next
navigate_next