Advance Excel Training (Level 1 & 2)
The Advance Excel & MIS Training course is a job-oriented, skill-based program designed for professionals, accountants, analysts, and students aiming to master data management, reporting, automation, and analysis using Excel and VBA.
This course is divided into two levels ā Level 1: Advanced Excel with Formulas and Level 2: VBA Programming & Macros ā helping learners transition from intermediate Excel use to automated, intelligent MIS reporting systems.
Course Levels & Syllabus (Level 1)
Level 1: Advanced Excel with Advanced Formulas
Total Classes: 52ā|āCourse Fee: ā¹6,500
š Part A ā Excel Essentials
Excel Options & UI Customization
Paste Special & Custom Formatting
Conditional Formatting
Sorting, Filtering, and Cell Selection
š Part B ā Data Summarization
Pivot Table & Advanced Pivot Table
Charts & Graphs
Hyperlinks and Object Editing
š Part C ā Advanced Formulas
Logical, Text, Date & Time Formulas
Lookup Functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
Database, Financial & Statistical Functions
Array Formulas
š Part D ā Data Tools & Automation Basics
Data Validation
Subtotals & Data Tools
Shared Workbook
Macros (Recording + Editing)
Form Controls
Level 2: VBA Programming with Macros & User-Defined Functions
Total Classes: 44ā|āCourse Fee: ā¹5,500
š Core Topics
Excel Form Controls & Macro Recording
Editing Macros and Basic VBA Programming
VBA Data Types, Conditions, and Loops
String & Number Manipulation in VBA
User-Defined Functions (UDFs)
š Advanced Applications
VBA with Pivot Tables, Charts, and Forms
VBA Integration with Outlook (Email + Attachments)
Automated Reports & Dashboards
Multi-form Projects (UserForm 1ā10)
Who Should Enroll?
This course is ideal for:
Working professionals in MIS, Admin, or Accounting roles
B.Com / MBA / CA students
Data analysts and team leads
Anyone looking to master Excel for career growth
Beginners who want to learn automation with VBA
Certification
Upon completion, students receive a Govt. of West Bengal Registered Certificate issued under the NBCE (National Board of Computer Education), valid for:
Govt. exams like SSC, PSC, RRB
Office/Clerk roles in private and public organizations
Freelance work in IT, web, and DTP domains
Enroll Now !
Master data analysis, automate reports, and upgrade your resume with Advanced Excel & MIS Training at Mousumi Computer Center.
Mousumi Computer Center, Santoshpur offers career-focused computer training across a wide range of certified courses.