आरंभ – MIS & Automation program is intended to make you Excel & VBA Automation champion by acquiring the fundamentals of Excel spreadsheets to perform basic data analysis and VBA automation to automate your daily task.

Core & Advanced Excel with Dashboard

MS Excel from beginner to Advance excel, Formulas, Chart tips and Tricks in MS Office and Office 365.

VBA Automation with Real time project implementation

This course is designed to teach you the basics of Microsoft Excel & VBA Automation all the way to Excel & VBA mastery. It’s perfect for you if you are a beginner or intermediate Excel VBA  user who needs to drastically increase your excel vba skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups as well as automation of your daily office task. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. You will learn how to build professional dashboards in Excel & VBA.

What you will learn:

• Enhance your current Excel files & automate your work with VBA.
• Master Microsoft Excel from Beginner to Advanced
• Build financial models from scratch (shown step-by-step)
• Format sheets and charts professionally
• Learn new keyboard shortcuts and be even faster in Excel
• Use Cell Styles and format spreadsheets easier and faster
• Writing Formulas and performing Calculations
• Create charts with Trend Lines, and Dual Axis
• Use Excel as a Database with Sort and Filter options
• How to avoid the most common Database Design flaws
• Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
• Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions
• Learn several hidden Excel tips and tricks
• Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
• Learn to make Excel & VBA dashboards.
• Master Excel VBA & Macros
• Explore Google Sheets
• Learn Excel with ChatGPT
• Reduce manual routine tasks to the click of a button