Basic MS Excel

Course Content

  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
  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
  1. Charts
    1. Review of Chart Elements
    2. Basic Chart Design
  1. PivotTable
    1. Basic Pivot Features
    2. Slicers
    3. Drilling Down
    • Makati
    • +63 2 8891 0722
    • +63 2 8891 0713
    • +63 2 8751 6482
    • Intramuros
    • +63 2 8524-5572
    • Intramuros
    • 658 Muralla St., Intramuros, Manila 1002, Philippines


    • Makati
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines