MS Excel (Advanced Level)

Free Registration: https://crm.lcbsdhaka.com/view.php?id=198410

Facilitator: Touhid Imam Khan, M. Com, ICMAB (15 Subjects Passed)
Number of Sessions: 8
Session Duration: 2 hours
Total Duration: 16 hours
Course Length: 2 Months
Course Fee: 6,000 BDT

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.