Microsoft is aggressively planning to move almost all its users to subscription based version of Microsoft 365 where they have new powerful calculation engine and other functions, such as XLOOKUP /UNIQUE /FILTER /SORT /SEQUENCE /POWER QUERY etc. They are immensely helpful to automate our data more efficiently and accurately. Each of these functions is a great boon for all Excel Enthusiasts.
MICROSOFT/OFFICE 365 the latest and most recommended version of Excel is filled with tons of New Functions/Features. These are going to change our working tremendously and will help us to automate tasks in our spreadsheets. Unfortunately, many of us haven't explored what it has to offer. Even most of the advanced users of Excel continue working by the old "manual" way, or the "complex" way with difficult formulas of older versions.
Who Should Attend : All Excel enthusiasts who want to be 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 having Microsoft 365 version of Excel. For Power Query you can work in Excel 2016 and Excel 2019 too. In Excel 2013, Power Query can be installed as an add-in from Microsoft site, but Microsoft 365 is recommended should have Microsoft 365.
👉 Understanding New Functions of Microsoft 365 with Business Scenarios
👉 Replace complex Excel formulas with a click of a button.
👉 How to perform common data cleansing activities with Power Query
👉 Consolidate data from all files in a folder
👉 Quickly get and update data from the web, like share prices, on real time basis
👉 Power Query 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. Create Dynamic Drop Downs in multiple cells which change as we type
2. Create Realtime Dashboard without Pivot
3. Import Data from Website
4. Solution to lots of other business problems which we face in our day to day work.
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