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.
SEQUENCE : Create Sequence 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, IFERROR, INDEX/MATCH
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.
👉 Consolidation of TBs with Utility/Power Query
👉 Creating different Masters- Why Masters are important for any automation
👉 Reporting with Charts to make it more user friendly/Interactive
👉 Navigation of Reporting with the help of dropdowns/slicers
👉 Dashboarding/Formatting/Presentation/PPTs - How to do it
👉 Update New Data and everything will be updates within seconds
👉 Replace complex Excel formulas with a click of a button.
👉 Consolidate data from all files in a folder
👉 Q&A