Microsoft Excel for Professionals

                     Facilitator: Touhid Imam Khan, M. Com, ICMAB (15 Subjects Passed)
Number of Sessions: 8
      Session Duration: 3 hours
   Total Duration: 24 hours
     Course Length: 2 Months

Course Contents:

Session 1: Fundamentals Refresher & Data Validation

• Overview of advanced Excel features.
• Data validation rules (e.g., drop-downs, input messages, error alerts).
• Practical examples and exercises.

Session 2: Conditional Formatting for Dynamic Analysis

• Creating custom formatting rules.
• Highlighting trends, errors, and outliers.
• Advanced techniques with formula-driven formatting.

Session 3: Text Functions

• Working with functions like CONCATENATE, LEFT, RIGHT, MID, TRIM, and TEXT.
• Cleaning and transforming text data.
• illustration of practical applications.

Session 4: Financial and Statistical Functions

• Essential financial functions (e.g., PV, FV, IRR, NPV).
• Key statistical functions (e.g., AVERAGEIFS, COUNTIFS, STDEV.P).
• Combining functions for complex calculations.

Session 5: Subtotal Functions and Data Consolidation

• Using SUBTOTAL and AGGREGATE functions.
• Advanced data grouping techniques.
• Hands-on consolidation exercises.

Session 6: If Condition and Lookup Functions

• Nested IF conditions and logical operators.
• Advanced lookups (e.g., VLOOKUP, HLOOKUP, INDEX-MATCH).
• Troubleshooting common lookup issues.

Session 7: Pivot Tables, Charts, and Slicers

• Creating and customizing pivot tables.
• Data visualization with pivot charts.
• Interactive filtering using slicers.

Session 8: Database Functions

• Exploring DSUM, DAVERAGE, DCOUNT, etc.
• Working with structured references.
• Practical database-related scenarios.

Session 9: Goal Seek, Solver, and Scenario Manager

• Using Goal Seek for basic optimization.
• Setting up Solver for complex problem-solving.
• Scenario Manager for what-if analysis.

Session 10: Graphical Representation and Data Analysis

• Advanced charting techniques (e.g., waterfall, radar, stock charts).
• Data analysis tools like Analysis Toolpak.
• Comprehensive dashboard.

Certification

• Certificate of Participation: Awarded upon course completion.
• Certificate of Excellence: Awarded to top performers who pass the final assessment.