MS Intermediate Excel

Course Content

  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
  1. Statistical and Mathematical Functions
  2. Advanced Lookup Functions
  3. Advanced IF Statements
  4. Advanced Formula Making
  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
  1. Review of Basic Chart Elements
    1. Gridlines
    2. Axes
    3. Data Tables
    4. Data Labels
    5. Legends
  2. Making Combination Charts
  3. Tables
  1. Applying Conditional Formatting
  2. Data Bars, Color Scales, and Icon Sets
  1. Protecting Cell Contents and Worksheets
  2. Protecting the File
  3. Sharing and Exporting Worksheets
  1. Creating  PivotTables
  2. Modifying Value Field Settings
  3. Other PivotTable Features
  4. PivotCharts
  5. Slicers
    • 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