Course Fee - Rs. 1,999/- Only
MICROSOFT/OFFICE 365 the latest and most recommended version of Excel is filled with Tens of New Functions/Features. This is going to change our working tremendously and immensely helpful to automate tasks in our spreadsheets. CHAMP EXCEL is organizing a series of Two Interactive Webinars on “Advanced Functions of Office 365 including Power Query” by Eminent Excel Expert and CA Sh. Vijay Agarwal, awarded Microsoft Excel MVP for four consecutives years (2014-18) for his Excel Skills.
Who Should Attend : For 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 too, Power Query can be installed as an add-in from Microsoft site, but it is recommended that we should have Microsoft 365.
👉 Understanding New Functions of Microsoft 365 with Business Scenarios SEQUENCE : Create Sequece of Data with pre logic on any Matrix with single cell formula XLOOKUP : 10 Times powerful than VLOOKUP, Left or Right any side Lookup, No need of HLOOKUP, No need of IFERROR, No more INDEX/MATCH required UNIQUE: Dynamically create Unique list of Data SORT : Dynamically Sort data in any order SORTBY : Sorting Data based on other Columns FILTER : Automate your reports with Filter without Refresh on Realtime basis.
👉 Unpivot Columns with in seconds from Power Query, which can take hours/days without power query.
👉 Replace complex Excel formulas with a click of a button.
👉 Unpivot Columns with in seconds from Power Query, which can take hours/days without power query.
👉 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. CrossTab Consolidation 3. Unpivot multiple pair of columns 4. Import Data from Website 5. Solution to lots of other business problems which we face in our day to day work
👉 Q&A
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!