• 1. Introduction & Basics
    • Excel Interface, Rows, Columns, and Cells (A1 Notation).
    • Creating, Saving, and Navigating Workbooks.
    • Data Entry, Selection, and Editing.
    • Formatting Cells, Fonts, Borders, and Numbers.
  • 2. Essential Functions & Formulas
    • Arithmetic Operators (Plus , Minus, Multiply, Divide) and parentheses.
    • Basic Functions: SUM, AVERAGE, COUNT, MIN, MAX.
    • Relative vs. Absolute Cell References.
    • Logical Functions: IF, AND, OR.
    • Text Functions: CONCATENATE, LEFT, RIGHT, MID, TEXTJOIN.
  • 3. Data Management & Analysis
    • Sorting and Filtering Data (Custom and Advanced).
    • Conditional Formatting (Highlights, Data Bars, Color Scales).
    • Data Validation (Creating dropdown lists).
    • PivotTables & PivotCharts: Creating, grouping, and filtering.
    • VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH.
    • “What-If” Analysis: Goal Seek, Data Tables, Scenario Manager.
  • 4. Visualization & Reporting
    • Creating Charts: Bar, Column, Pie, Line, and Area.
    • Chart Customization (Labels, Titles, Axes).
    • Using Slicers for Interactive Reports.
  • 5. Advanced Topics & Automation
    • Importing Data from External Files (Text, CSV, Database).
    • Macros & VBA Introduction: Recording and editing automation scripts.
    • Power Query for Data Transformation (ETL).
    • Data Protection: Protecting Worksheets and Workbooks.
  • 6. Industry Standard Skills
    • Data Visualization (Dashboard Design).
    • Time Series Analysis.
    • Commonly used keyboard shortcuts.
  • 7. Certification Focus (MOS Excel Associate)
    • Managing Workbook Options and Settings.
    • Formatting Cells and Ranges.
    • Creating Tables.