MS Intermediate Excel

Course Duration

16 hours, 2-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Course Content

  • MODULE I: Review of Essential Excel Functions
    1. Basic Arithmetic Formulas (SUM, AVERAGE, etc)
    2. Excel Interface and Navigation Techniques
    3. Text Functions: LEFT, RIGHT, UPPER, LOWER, TRIM, etc
    4. Math Functions: COUNTIF, SUMIF, RANK, etc
    5. Basic Logical Functions: IF, IFERROR, AND, OR
    6. Date and Time Functions
    7. Basic Lookup Functions

  • MODULE II: Intermediate Functions
    1. Statistical and Mathematical Functions
    2. Advanced Lookup Functions
    3. Advanced IF Statements
    4. Advanced Formula Making

  • MODULE III: Database Management
    1. Review of Basic Database Management
      1. Text-to-Columns
      2. Data Validation
        1. Creating Basic Dropdown Lists
        2. Other Data Validation Options
    2. Consolidation Tools
      1. Creating 3D Formulas
      2. Consolidation Tool
    3. Using Groups and Subtotals

  • MODULE IV: Charting
    1. Review of Basic Chart Elements
      1. Gridlines
      2. Axes
      3. Data Tables
      4. Data Labels
      5. Legends
    2. Making Combination Charts
    3. Tables

  • MODULE V: Conditional Formatting
    1. Applying Conditional Formatting
    2. Data Bars, Color Scales, and Icon Sets

  • MODULE VI: Security and Sharing Options
    1. Protecting Cell Contents and Worksheets
    2. Protecting the File
    3. Sharing and Exporting Worksheets

  • MODULE VII: Advanced Pivot Tables
    1. Creating  PivotTables
    2. Modifying Value Field Settings
    3. Other PivotTable Features
    4. PivotCharts
    5. Slicers
    • 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