Excel Power Query

person icon Ajay Parmar

4.1 ★★★★ ★

Buy Now

Excel Power Query

Name: Excel Power Query
Rating: 4.1 (283 reviews)
Author: ajay parmar

Complete Tutorial -PowerQuery Basic to Advance

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Ajay Parmar

category icon Office Productivity,Microsoft,Power Query

Lectures -24

Resources -20

Duration -9.5 hours

4.1 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

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)
Online support 24*7 given by me to address your issues

Goals

What will you learn in this course:

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
You will see several complex projects and quizzes with solution to see the real use of powerquery in your office.
Amazing Data cleaning techniques, data mining, making it fit for reports - You shall learn in this.
How to work with websites to get their information

Prerequisites

What are the prerequisites for this course?

You should have atleast excel 2010 installed and basic knowledge of Excel is must. No vba is needed.

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
24 Lectures

Overview and Installation 38:27 38:27
Import Excel Tables within the workbook 28:06 28:06
Import Text files or CSV from a Folder 28:53 28:53
Import Txt files from Folder with FileName 23:56 23:56
Import Excel files with sheet name 12:02 12:02
Import All Excel Tables in one go 33:05 33:05
PowerFul Joins - Vlookup replacement and much more - Part1 20:04 20:04
PowerFul Joins - Part2 19:56 19:56
PowerFul Joins - Part3 36:13 36:13
PowerFul Joins - Part4 15:09 15:09
Group By feature – Amazing and Easy to use 41:48 41:48
Group By feature – Part2 22:42 22:42
UnPivot Feature – Tough days are gone now 35:24 35:24
11 Amazing Powerquery ribbon features 47:27 47:27
Date Functions – Classic invention by Microsoft PQ 32:07 32:07
Text Functions – Full Coverage with amazing examples 12:00 12:00
Text Functions – Part2 17:19 17:19
Complex Project discussion 1 – Surprise Test for you with solution 24:16 24:16
Another Awesome Project for you with solution 26:14 26:14
A quiz with solution 07:29 07:29
One more Project – Advance Level Remove Dummy rows 22:40 22:40
Your Questions My solutions- What if folder data source changed 11:27 11:27
Your Questions My solution- Trick to re-order too many table headers 04:27 04:27
Your Project is solved here – Check out because its awesome 14:28 14:28

Instructor Details

ajay parmar

Course Certificate

Use your certificate to make a career change or to advance in your current career.