MIS Automation using New Functions of Excel 365  

Course Fee - INR 1,000 /- only

Why it's important!

MIS reporting is one of the topmost and statutory requirements in every organization. Having to report branch-wise, region-wise, month-wise, quarter-wise, year-to-date, trending analysis, etc. is an extremely challenging and tedious task. A smart use of Excel 365 can make our lives easier and promote efficient behavior. We can also build lot of interactive charts that catches your eyes while preparing MIS Report.

INTRODUCTION AND
COURSE CURRICULUM

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. 

MIS Automation video sessions
  • Day 1 Session
  • Day 2 Session
Working Files
  • MIS Automation All-in-one Working Files
  • MIS Bank Report

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

MORE PERKS 

CERTIFICATION 
Obtain a digital certificate for completing this course

WORKING FILES
Get access to the working and business solution files

90 DAYS ACCESS
Get access to the webinar recording for 3 months

INTERACTIVE Q/A
Get answers to all your queries


CONNECT WITH US