Module 1: Excel Fundamentals & Advanced Workspace

• Introduction to Microsoft Excel
• Workbook and worksheet management
• Rows, columns and cells
• Data entry and editing
• Formatting cells
• Number, date and currency formats
• Custom formatting
• Freeze Panes
• Page Layout and Print Settings
• Excel Options and customization

Module 2: Advanced Data Entry & Formatting

• AutoFill and Flash Fill
• Custom lists
• Paste Special
• Find and Replace
• Format Painter
• Cell Styles
• Themes
• Merging and Centering
• Text alignment
• Borders and formatting
• Protecting worksheets

Module 3: Excel Formulas & References

• Understanding formulas
• Formula operators
• Relative references
• Absolute references
• Mixed references
• Named ranges
• Formula auditing
• Error handling
• Common formula errors
• Practical formula exercises

Module 4: Mathematical & Statistical Functions

• SUM()
• AVERAGE()
• MIN()
• MAX()
• COUNT()
• COUNTA()
• COUNTBLANK()
• ROUND()
• ROUNDUP()
• ROUNDDOWN()
• SUMPRODUCT()
• Practical calculations

Module 5: Logical Functions

• IF()
• Nested IF
• IFS()
• AND()
• OR()
• NOT()
• IFERROR()
• Combining logical functions
• Grade and result calculations
• Salary and performance calculations

Module 6: Text Functions

• LEFT()
• RIGHT()
• MID()
• LEN()
• TRIM()
• UPPER()
• LOWER()
• PROPER()
• CONCAT()
• TEXTJOIN()
• SUBSTITUTE()
• REPLACE()
• FIND()
• SEARCH()
• Text data cleaning

Module 7: Date & Time Functions

• Working with dates
• Working with time
• TODAY()
• NOW()
• DATE()
• DAY()
• MONTH()
• YEAR()
• DATEDIF()
• EDATE()
• EOMONTH()
• WEEKDAY()
• Working-day calculations
• Age and service-period calculations

Module 8: Lookup & Reference Functions

• Introduction to lookup functions
• VLOOKUP()
• HLOOKUP()
• XLOOKUP()
• LOOKUP()
• INDEX()
• MATCH()
• INDEX + MATCH
• Exact and approximate matching
• Two-way lookup
• Dynamic lookup applications

Module 9: Dynamic Array & Modern Excel Functions

• Dynamic arrays
• Spill ranges
• FILTER()
• SORT()
• SORTBY()
• UNIQUE()
• SEQUENCE()
• TRANSPOSE()
• Combining dynamic functions
• Practical dynamic reporting

Module 10: Data Sorting & Filtering

• Basic sorting
• Multi-level sorting
• Custom sorting
• Filtering data
• Advanced Filter
• Filter by text
• Filter by number
• Filter by date
• Filter using multiple criteria
• Extracting filtered records

Module 11: Conditional Formatting

• Basic conditional formatting
• Highlighting duplicate values
• Data Bars
• Color Scales
• Icon Sets
• Formula-based conditional formatting
• Highlighting top/bottom values
• Dynamic formatting
• Performance and status dashboards

Module 12: Data Validation & Drop-Down Lists

• Data Validation
• Number restrictions
• Date restrictions
• Text length restrictions
• Creating drop-down lists
• Dependent drop-down lists
• Custom validation formulas
• Error alerts
• Interactive Excel forms

Module 13: Excel Tables & Structured References

• Creating Excel Tables
• Table styles
• Table sorting and filtering
• Structured references
• Calculated columns
• Total Row
• Dynamic table ranges
• Using Tables with formulas and charts

Module 14: Charts & Data Visualization

• Creating charts
• Column and Bar charts
• Line charts
• Pie and Doughnut charts
• Area charts
• Scatter charts
• Combo charts
• Secondary axis
• Chart formatting
• Dynamic charts
• Professional data visualization

Module 15: Pivot Tables & Pivot Charts

• Introduction to Pivot Tables
• Creating Pivot Tables
• Rows, Columns, Values and Filters
• Grouping data
• Grouping dates
• Calculated fields
• Slicers
• Timelines
• Pivot Charts
• Interactive reports

Module 16: What-If Analysis & Advanced Tools

• What-If Analysis
• Goal Seek
• Scenario Manager
• Data Tables
• Solver basics
• Forecasting basics
• Sensitivity analysis
• Business decision-making models

Module 17: Power Query & Data Cleaning

• Introduction to Power Query
• Importing data
• Connecting to Excel files
• Combining multiple files
• Removing duplicates
• Handling missing data
• Splitting and merging columns
• Changing data types
• Transforming data
• Merging queries
• Appending queries
• Refreshing data automatically

Module 18: Dashboards & MIS Reports

• Introduction to Excel dashboards
• Dashboard planning
• KPI creation
• Charts and visual indicators
• Slicers and interactive filters
• Dynamic reports
• Sales dashboard
• HR dashboard
• Attendance dashboard
• Financial dashboard
• MIS reporting

Module 19: Excel Automation & Macros

• Introduction to Excel automation
• Recording macros
• Running macros
• Macro security
• Introduction to VBA
• VBA Editor
• Variables and data types
• Basic VBA statements
• Automating repetitive tasks
• Creating simple automated reports

Module 20: Practical Advanced Excel Projects

Students will work on real-world projects such as:

• 📊 Sales Analysis Dashboard
• 👨‍💼 Employee Salary & Payroll Sheet
• 🎓 Student Marksheet & Result Analysis
• 📦 Inventory Management System
• 💰 Expense & Budget Tracker
• 📈 Business MIS Report
• 👥 HR Employee Dashboard
• 🛒 Sales & Product Analysis
• 📅 Attendance Management System
• 📊 Interactive Management Dashboard