MIS Automation  

Course Fee - INR 1,999 /- only


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. 

  • Session - 1
  • Session - 2
  • Working Files - (Download) - 1
  • Working Files - (Download) - 2

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.

Salient Features of the Course

👉 Introduction and need of Automation of MIS using New Functions of Excel 365

👉 MIS Automation - Challenges to have reporting on BranchWise/RegionWise/Consolidated/MonthWise/QtrWise/YTD/Trending etc

👉 Understanding New Functions of Excel 365 with Business Scenarios         

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