Excel Power Query

Excel Power Query

• 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

Complete Tutorial -PowerQuery Basic to Advance

Url: View Details

What you will learn

• How to use PowerQuery in Cleaning and Transforming the complex , unstructured and tidy data mess.
• PowerQuery Ribbon features - Each and Every feature is discussed with examples.
• How to work with millions of rows coming from external sources or within excel sheets

Rating: 4.05

Level: All Levels

Duration: 10.5 hours

Instructor: ajay parmar