POWER QUERY is one of the most powerful feature 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.
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.
Power Query is like an Instant Miracle Cure to your difficult data analysis problems.
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.
👉 You can quickly combine and consolidate large data from different sources like Excel, text files, the web and different databases.
👉 You can convert downloads from your ERP system into information you can use.
👉 Unpivot Columns with in 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
👉 Some interesting Business Cases
1. Import Data from Website
2. CrossTab Consolidation
3. Unpivot multiple pair of columns
And these are just a few examples of what it can do! On top of this, your actions are recorded so whenever you get new data, all you have to do is click Refresh!
Guess what? You can apply ALL the knowledge you learn in this course to Power BI as well!
Obtain a digital certificate for completing this course
Full solution ready to use Utility/Templates.
90 DAYS ACCESS
Get access to the webinar recording for 3 months
Get answers to all your queries