POWER QUERY is one of the most powerful features ever introduced by Microsoft in the 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.
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
For all Excel enthusiasts who want to be an Excel Pro and want to automate their processes.
An average knowledge of MS Excel a basic understanding of Excel Pivot Tables and Excel Formulas will be an added advantage
This course is designed for Windows users only - Power Query is currently NOT available on Mac. For this, you need a version of Microsoft Excel 2016, Excel 2019, or Excel for Microsoft 365. In Excel 2013, Power Query can be installed as an addition to the Microsoft site, but it is recommended that you have Microsoft 365.
Big Data Analyst & Automation Expert - Awarded 4 Times as Most Valuable Professional (MVP) by Microsoft.
👉 Introduction of Power Query
👉 What Power Query can do for you – The Power of Power Query
👉 Transformation in Power Query – Text, merging columns, 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, and different databases
👉 Transpose, Reverse, Replace, Rounding, Trim, Clean, and many more features to transform data with a 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 a 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), into 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 the 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 the latest functions of Excel 365
Click on 'Buy Now' button and do Signup first.
After Signing up go for payment method.
After payment, Your Course Video in your dashboard. Learn Advanced of Power Query.