Be Power Query Expert in 10 Days - Basic to Advanced Level Course

Course Fee - Rs 3500/-

Why it’s important!

POWER QUERY is one of the most powerful features ever been introduced by Microsoft in last 20 years. This is going to change our working tremendously as it's immensely helpful to automate tasks in our spreadsheets. This is the backbone of Power BI.

Introduction and Course Curriculum

Excel Power Query has been a part of Excel since Excel 2016! It's in the Data tab under Get and Transform. Unfortunately, many people haven't explored what it has to offer! They continue doing things the old "manual" way, Or the "complex" way with complex formulas

Who Should Attend:

For all Excel enthusiasts who want to be an Excel Pro and want to automate their processes.

Prerequisite:

An average knowledge of MS Excel; Basic understanding of Excel Pivot Tables and Excel Formulas will be an added advantage 

Important Note:

This course is designed for Windows users only - Power Query is currently NOT available in Mac. For this, you need a version of Microsoft Excel 2016, Excel 2019 or Excel for Microsoft 365. In Excel 2013 too, Power Query can be installed as an adding from Microsoft site, but it is recommended that you should have Microsoft 365.

Speaker: CA Vijay Agarwal

Big Data Analyst & Automation Expert - Awarded 4 Times as Most Valuable Professional (MVP) by Microsoft. 

Session Wise Agenda

πŸ‘‰ Introduction of Power Query

πŸ‘‰ What Power Query can do for you – The Power of Power Query

πŸ‘‰ Transformation in Power Query – Text, merging columns, fill & replace, remove duplicate, number transformation and work with filter.

πŸ‘‰ Time & Date Transformation and Custom Column

πŸ‘‰ Data Sources – How to connect different data sources

πŸ‘‰ Combining / Appending Data

πŸ‘‰ Merge and Join options in Power Query

πŸ‘‰ Merge options – Left outer/Right Outer/Full Outer/Inner/Left Anti/Right Anti Features

 πŸ‘‰ Group By Feature of Power Query

πŸ‘‰ Relevance of Data Connections in Power Query

πŸ‘‰ You can quickly combine and consolidate large data from different sources like Excel, text files, the web and different databases

πŸ‘‰ Transpose, Reverse, Replace, Rounding, Trim, Clean and many more features to transform data with click of buttons

πŸ‘‰ You can convert downloads from your ERP system into information you can use.

πŸ‘‰ Unpivot Columns within seconds, which can take hours/days without power query

πŸ‘‰ Aggregating or Grouping of Data

πŸ‘‰ How to perform common data cleansing activities with Power Query

πŸ‘‰ Replace complex Excel formulas with a click of a button.

πŸ‘‰ Consolidate data from all files in a folder

πŸ‘‰ Turn complex data transformations that took forever to do (such as unpivoting data), to just a few clicks.

πŸ‘‰ It can handle Millions of rows very efficiently without making file size bigger.

πŸ‘‰ Create an interactive Excel Dashboard with Power Query, Pivot Tables and slicers

πŸ‘‰ More than 10 interesting Business Cases

     1.  Import Data from Website

     2.  CrossTab Consolidation

     3.  Unpivot multiple pair of columns

     4.  Transformation of Trial Balance into Financial Statements

     5.  Payroll comparison with previous months in all heads

     6.  Transformation of multiple files and Charts/Dashboard

πŸ‘‰ Solving complex data analysis problems with merge

πŸ‘‰ Advanced problem solving using the Power Query Interface

πŸ‘‰ Working with List & Table functions

πŸ‘‰ How to Create and Invoke Custom functions

πŸ‘‰ Importing of data with the help of functions

πŸ‘‰ One Complete end to end project using Power Query and latest functions of Excel 365


More Perks

CERTIFICATION
Obtain a digital certificate for completing this course

WORKING FILES
Get access to the working and business solution files

90 DAYS ACCESS
Get access to the webinar recording for 3 months

INTERACTIVE Q/A
Get answers to all your queries

Step 1: Signup

Click on 'Buy Now' button and do Signup first.

Step 2: Payment

After Signing up go for payment method.

Step 3: It's Done

After payment, Your Course Video in your dashboard. Learn Advanced of Power Query.

See the MAGIC of the Power Query - The Most Powerful Excel Tool Ever

Wants to automate you process??, Consolidate your large data in seconds??, Merge Multiple table??, create relationships with the tables?? these are the few features and many more things can do Power Query for you in just few clicks only. Don't Miss the opportunity!! 

Be the part of the Live Webinar - 10 Days Live Session "From Basic to Automation Process in Power Query  

Course Fee - Rs 3500/- Only

SUBSCRIBE
CONNECT WITH US