Course Syllabus

Module 1: Getting Started & Interface (4 h)

• Topics: Excel UI, ribbon/tab navigation, worksheets, basic operations (workbooks, cell entry, formatting)
• Description: Establish a strong foundation by learning to create, navigate, and format workbooks efficiently.
• Features: Guided labs on data entry, basic formatting, and quick analysis (Quick Analysis Tools).

Module 2: Formulas & Functions (6 h)

• Topics: Formulas, cell references (relative/absolute), essential functions (SUM, AVERAGE, IF, VLOOKUP), date/time functions
• Description: Equip learners to build dynamic spreadsheets with calculations, conditional logic, and lookups.
• Features: Hands-on exercises and formula auditing.

Module 3: Data Organization & Tables (5 h)

• Topics: Tables, named ranges, sorting/filtering, subtotal, slicers
• Description: Teach proper structuring of data for easier analysis and maintenance.
• Features: Labs on creating and managing dynamic tables.

Module 4: Data Visualization (5 h)

• Topics: Charts (column, line, pie), PivotTables, PivotCharts, conditional formatting, sparklines
• Description: Enable professional visualization and summarization of data insights.
• Features: Dashboard-building labs and slicer-linked reporting.

Module 5: Data Analysis Techniques (4 h)

• Topics: Advanced functions (INDEX/MATCH), what-if analysis, Goal Seek, Scenario Manager
• Description: Introduce scenario planning and complex lookups for decision support.
• Features: What-if modeling labs.

Module 6: Data Import & Cleansing (4 h)

• Topics: Data import (CSV, web, databases), Flash Fill, text/clean/date functions
• Description: Master import processes and cleaning methods to ensure quality data.
• Features: Data preparation labs using Power Query principles.

Module 7: PivotTables & Advanced Reporting (4 h)

• Topics: PivotTable grouping, calculated fields/items, PivotCharts, interactive reporting
• Description: Transform datasets into meaningful summaries and visualizations.
• Features: Practice advanced pivot layouts and filters.

Module 8: Automation with Macros & VBA Introduction (4 h)

• Topics: Macro recording, basics of VBA, user-defined functions (UDFs)
• Description: Automate repetitive workflows and introduce custom functions.
• Features: Labs on recording macros and building simple VBA scripts.

Module 9: Collaboration & Protection (3 h)

• Topics: Shared workbooks, protecting worksheets/workbooks, comments, track changes
• Description: Secure data and enable collaborative editing in shared environments.
• Features: Labs on protecting sensitive content and version control.

Module 10: Excel in the Cloud & Add-ins (3 h)

• Topics: Excel 365 real-time collaboration, Power Query, Solver, Analysis ToolPak
• Description: Leverage cloud features and advanced add-ins for enhanced data handling.
• Features: Labs using add-ins and shared workbook collaboration.

Module 11: Dashboard Design & Best Practices (4 h)

• Topics: Dashboard layout, interactive controls, formatting best practices
• Description: Build visually appealing, functional dashboards for business reporting.
• Features: Dashboard creation labs with user navigation and KPI highlights.

Module 12: Capstone Project (1 h)

• Description: Students build a fully functional spreadsheet model including formulas, pivot, chart dashboards, macros, and protection.
• Features: Peer review and instructor feedback.

• Key Features

  • Live expert-led classes (onsite/virtual)
  • >60% hands-on labs covering all key Excel functionalities
  • Real-world scenarios: finance, reporting, data cleaning, automation
  • Step-by-step automation: Macro/VBA fundamentals
  • Dashboard and data analysis workshops
  • Collaboration & cloud integration labs for shared editing
  • Capstone project mirrors workplace tasks
  • Certification readiness unlocks MOS/MO‑200, MO‑201 credentials
  • Access to templates: quick reference charts, macro code, dashboards