Excel PowerQuery – English
Course Description
- This course covers the Basic and Advance PowerQuery
- From installing the PQ to checking the system requirements and Its definition.
- Covering the PQ ribbon – all features with examples in full detail
- Why it is called ETL Tool – Extract Transform Load
- Benefits of Powerquery over normal Excel spread sheets
- Handling millions and billions rows efficiently
- How to import data from different sources like txt , csv,folders, databases, excel sheets
- Every minute detail about PQ ribbon features with the help of examples
- Know your magnificent Group by feature – Complete tutorial including projects
- Date functions – Very easy and powerful
- Text Functions in extracting the values is discussed, no need to build now excel formulas or VBA
- PQ functions – CSV.Document , Excel.Currentworkbook, excel.workbook are discussed with practical examples
- Transpose feature, UnPivot Feature – where and how they can be used.
- How to use first row as header, how to change data type and why you should know this.
- How to reverse the rows of your table.
- How to use replace value feature and how to use Fill values button in Powerquery under Transform tab
- How to use split, columns from example, edit custom columns.
- How to extract the numbers, texts or num to digit and vice versa
- Several practical projects for you with solutions – Amazing result driven projects for you
- What are the different types of JOINS – Left Join, Right, Full, left anti, Right Anti – All are covered
- How to use IF statements in PQ and how they are beneficial in real time projects
- How to change the source or location of data, What is refresh and refresh all ,Connection only ,close and close and load to options
- How to use website tables data in excel using powerquery- Its called webscraping
- Several advance level projects with quizzes (solution given in lectures
Course Curriculum
PQ Begins
-
Overview and Installation
38:27 -
Import Excel Tables within the workbook
28:06 -
Import Text files or CSV from a Folder
28:53 -
Import Txt files from Folder with FileName
23:56 -
Import Excel files with sheet name
12:03 -
Import All Excel Tables in one go
33:05 -
PowerFul Joins – VLookup replacement and much more – Part1
20:05 -
PowerFul Joins – Part2
19:57 -
PowerFul Joins – Part3
36:14 -
PowerFul Joins – Part4
15:10 -
Group By feature – Amazing and Easy to use
41:49 -
Group By feature – Part2
22:43 -
UnPivot Feature – Tough days are gone now
35:25 -
11 Amazing Powerquery ribbon features
47:28 -
Date Functions – Classic invention by Microsoft PQ
32:08 -
Text Functions – Full Coverage with amazing examples
12:00 -
Text Functions – Part2
17:20 -
Complex Project discussion 1 – Surprise Test for you with solution
24:17 -
Another Awesome Project for you with solution
26:15 -
A quiz with solution
07:30 -
One more Project – Advance Level Remove Dummy rows
22:41 -
Your Questions My solutions- What if folder data source changed
11:28 -
Your Questions My solution- Trick to re-order too many table headers
04:28 -
Your Project is solved here – Check out because its awesome
14:29 -
Import Website Tables
13:57
Excel PowerQuery – English
Course Description
- This course covers the Basic and Advance PowerQuery
- From installing the PQ to checking the system requirements and Its definition.
- Covering the PQ ribbon – all features with examples in full detail
- Why it is called ETL Tool – Extract Transform Load
- Benefits of Powerquery over normal Excel spread sheets
- Handling millions and billions rows efficiently
- How to import data from different sources like txt , csv,folders, databases, excel sheets
- Every minute detail about PQ ribbon features with the help of examples
- Know your magnificent Group by feature – Complete tutorial including projects
- Date functions – Very easy and powerful
- Text Functions in extracting the values is discussed, no need to build now excel formulas or VBA
- PQ functions – CSV.Document , Excel.Currentworkbook, excel.workbook are discussed with practical examples
- Transpose feature, UnPivot Feature – where and how they can be used.
- How to use first row as header, how to change data type and why you should know this.
- How to reverse the rows of your table.
- How to use replace value feature and how to use Fill values button in Powerquery under Transform tab
- How to use split, columns from example, edit custom columns.
- How to extract the numbers, texts or num to digit and vice versa
- Several practical projects for you with solutions – Amazing result driven projects for you
- What are the different types of JOINS – Left Join, Right, Full, left anti, Right Anti – All are covered
- How to use IF statements in PQ and how they are beneficial in real time projects
- How to change the source or location of data, What is refresh and refresh all ,Connection only ,close and close and load to options
- How to use website tables data in excel using powerquery- Its called webscraping
- Several advance level projects with quizzes (solution given in lectures
Course Curriculum
PQ Begins
-
Overview and Installation
38:27 -
Import Excel Tables within the workbook
28:06 -
Import Text files or CSV from a Folder
28:53 -
Import Txt files from Folder with FileName
23:56 -
Import Excel files with sheet name
12:03 -
Import All Excel Tables in one go
33:05 -
PowerFul Joins – VLookup replacement and much more – Part1
20:05 -
PowerFul Joins – Part2
19:57 -
PowerFul Joins – Part3
36:14 -
PowerFul Joins – Part4
15:10 -
Group By feature – Amazing and Easy to use
41:49 -
Group By feature – Part2
22:43 -
UnPivot Feature – Tough days are gone now
35:25 -
11 Amazing Powerquery ribbon features
47:28 -
Date Functions – Classic invention by Microsoft PQ
32:08 -
Text Functions – Full Coverage with amazing examples
12:00 -
Text Functions – Part2
17:20 -
Complex Project discussion 1 – Surprise Test for you with solution
24:17 -
Another Awesome Project for you with solution
26:15 -
A quiz with solution
07:30 -
One more Project – Advance Level Remove Dummy rows
22:41 -
Your Questions My solutions- What if folder data source changed
11:28 -
Your Questions My solution- Trick to re-order too many table headers
04:28 -
Your Project is solved here – Check out because its awesome
14:29 -
Import Website Tables
13:57