Advanced Excel & MIS Training IPT Excel School - IPTINDIA

?? Structured Learning Plan for Advanced Excel & MIS Training (in Hindi)

?? Beginner Level (Excel Basics & Data Handling)

? Duration: 1-2 Weeks

? Excel Basics

• Interface, Ribbon, Quick Access Toolbar
• Workbook & Worksheet Management
• Cell Formatting & Number Formatting
• Basic Formulas: SUM, AVERAGE, COUNT, IF

? Data Management

• Sorting & Filtering
• Data Validation (Dropdown Lists)
• Conditional Formatting
• Text Functions (LEFT, RIGHT, MID, CONCATENATE, TRIM)

? Basic MIS Reporting

• Creating Simple Reports
• Formatting Tables
• Data Cleaning Basics

?? Intermediate Level (Data Analysis & Automation)

? Duration: 3-4 Weeks

? Advanced Formulas & Functions

• Logical Functions: IF, AND, OR, IFERROR
• Lookup Functions: VLOOKUP, HLOOKUP, INDEX-MATCH
• Date & Time Functions: TODAY, NOW, DATEDIF, EOMONTH
• Text Functions: SUBSTITUTE, TEXTJOIN, SEARCH

? Pivot Tables & Charts

• Creating Pivot Tables
• Grouping, Filtering & Slicers
• Pivot Charts & Dynamic Charts

? Data Cleaning & Power Query

• Removing Duplicates
• Splitting & Merging Data
• Importing & Transforming Data using Power Query

? MIS Reporting Techniques

• KPI Tracking & Summary Reports
• Creating Monthly & Yearly Dashboards
• Automating Report Generation

?? Advanced Level (VBA, SQL & Power BI)

? Duration: 4-6 Weeks

? VBA Macros for Automation

• Recording & Running Macros
• Writing VBA Code
• Automating Repetitive Tasks
• Creating User Forms in Excel

? Power BI & Dashboarding

• Introduction to Power BI
• Data Modeling & DAX Functions
• Creating Interactive Dashboards
• Connecting Excel with Power BI

? SQL for MIS Reporting

• Basics of SQL Queries
• SELECT, WHERE, GROUP BY, JOIN
• Extracting Data from Databases for Reports

? Advanced MIS Report Automation

• Using VBA & Power Query for Auto-Refreshing Reports
• Connecting Multiple Data Sources
• Dynamic Dashboards with Real-Time Data

?? Learning Resources (In Hindi)

?? YouTube Channels:

• "Excel Guru Ji" (Advanced Excel)
• "LearnVBAwithAmit" (VBA & Macros)
• "Power BI Duniya" (Power BI & MIS)

?? Online Courses:

• Udemy: "Advanced Excel & MIS Reporting in Hindi"
• Coursera: "Excel for Data Analysis & Reporting"

?? How Can I Help You More?

?? Do you want PDF notes, practice files, or a step-by-step guide? ?? Would you like daily exercises to improve faster?

please call +918802579388 (sujit sir)