Excel Power Query (10 hours +)

Complete Tutorial -PowerQuery Basic to Advance

• 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)

• Online support 24*7 given by me to address your issues