Module 1: Excel Fundamentals
- Excel interface and navigation
- Cell referencing and formatting
- Basic formulas and functions
- Data entry and validation
Module 2: Advanced Functions
- Logical functions: IF, AND, OR
- Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH
- Text functions: LEFT, RIGHT, MID, CONCAT
- Date & time functions
Module 3: Data Analysis Tools
- Sorting and filtering
- Conditional formatting
- Pivot tables and pivot charts
- What-if analysis: Goal Seek, Scenario Manager
Module 4: Charts and Visualization
- Creating and customizing charts
- Dynamic charts with named ranges
- Sparklines and dashboards
Module 5: Excel for Finance & Banking
- Loan and EMI calculations
- Budgeting and forecasting templates
- Bank reconciliation and ledger formats
Module 6: Introduction to VBA
- What is VBA and why use it?
- Recording and editing macros
- VBA editor and syntax basics
- Variables, loops, and conditions
Module 7: Automating with VBA
- Creating custom functions
- Automating reports and formatting
- Form controls and user forms
- Error handling and debugging
Module 8: Mini Projects
- Invoice generator
- Attendance tracker
- Finance dashboard
- Automated certificate creator