BiggestSale: 17Courses in 3500Rs (500 Hrs), 10 Courses in 3000Rs

Excel PowerQuery – English

Excel PowerQuery – English

Data Cleaning & Transformation - Solid ETL Tool

Created by Ajay Parmar

Material Includes

  • Supported files are attached. you may download.

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:28
  • Import Excel Tables within the workbook
    28:07
  • Import Text files or CSV from a Folder
    28:54
  • Import Txt files from Folder with FileName
    23:57
  • 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:13
  • PowerFul Joins – Part4
    15:09
  • Group By feature – Amazing and Easy to use
    41:49
  • Group By feature – Part2
    22:42
  • UnPivot Feature – Tough days are gone now
    35:24
  • 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:27
  • 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
899.00
899.00 3,000.00

Excel PowerQuery – English

899.00
899.00 3,000.00

Material Includes

  • Supported files are attached. you may download.

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:28
  • Import Excel Tables within the workbook
    28:07
  • Import Text files or CSV from a Folder
    28:54
  • Import Txt files from Folder with FileName
    23:57
  • 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:13
  • PowerFul Joins – Part4
    15:09
  • Group By feature – Amazing and Easy to use
    41:49
  • Group By feature – Part2
    22:42
  • UnPivot Feature – Tough days are gone now
    35:24
  • 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:27
  • 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