Basic MS Excel

Course Duration

8 hours, 1-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Course Content

  • MODULE I: Excel Functions
    1. Text Funcitons
      1. Combining Cells
      2. Extracting Cell Contents
      3. Changing Case of Texts
    2. Logical Functions
      1. Basic IF Statements
      2. Nested and Series IF
    3. Math Functions
      1. Math Functions
    4. Lookup Functions
      1. VLOOKUP

  • MODULE II: Database Management
    1. Sorting Options
    2. Text-to-Columns
    3. Remove Duplicates
    4. Conditional Formatting
      1. Basic Conditional Formatting
      2. Data Bars, Color Scales, and Icon Sets
    5. Data Validation
      1. Modifying Error Alerts
    6. Subtotal Tool
      1. Group and Ungroup
      2. Basic Subtotal
    7. Data Consolidation
      1. Consolidate Tool

  • MODULE III: Tables and Charts
    1. Charts
      1. Review of Chart Elements
      2. Basic Chart Design

  • MODULE IV: Pivot Reports
    1. PivotTable
      1. Basic Pivot Features
      2. Slicers
      3. Drilling Down
    • MAKATI
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines

    • Contact No.
    • +63 2 8891 0713
      +63 2 8751 6482

    • Email Address
    • inquiries@mapua.edu.ph

    • INTRAMUROS
    • 658 Muralla St., Intramuros, Manila 1002, Philippines

    • Contact No.
    • +63 2 8524-5572


    • Email Address
    • ccesc@mapua.edu.ph