Skip To Content
Microsoft Excel Intermediate (Windows Only) is a Program

Microsoft Excel Intermediate (Windows Only)

Time limit: 14 days

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Microsoft Excel Intermediate (Windows Only)

What's In It For Me

  • Format list using advanced formatting commands
  • Present data using Excel Chart
  • Create summarise report using Functions

Software:

(For Virtual Learning Classroom)

Participant laptop and desktop must be pre-installed

With Windows Microsoft Excel 2016 or above

Course Overview

NTUC LearningHub Course Code: MSEI

Course Duration

2 Days / 14 Hours

Course Outline

  • FORMAT WORKSHEETS
    • APPLY CONDITIONAL FORMATTING
      • Applying Conditional Formatting
      • Remove Conditional Formatting
    • APPLY AND REMOVE CELL STYLES
      • Apply a Cell Style
      • Remove a Cell Style
    • CREATE AND MODIFY CELL STYLES
      • Create a New Style
      • Modify a Style
  • BUILD FORMULAS
    • ABSOLUTE AND RELATIVE REFERENCES
      • Relative References
      • Absolute References
    • CELL AND RANGE NAMES
      • Create a Name
      • Use a Cell or Range Name in a Formula
      • Navigate to a Named Range
      • Edit and Delete Cell or Range Names
    • LOGICAL FUNCTIONS
      • IF Function
    • Mathematical and Trig Functions
      • Sumif
    • Statistically Functions
      • Countif
      • Averageif
    • TEXT FUNCTIONS
      • Concatenate Text
      • Left
      • Right
      • Len
    • FORMULA ERRORS
      • #NAME? Error
      • #DIV/0 Error
  • VIEW AND MANAGE WORKSHEETS
    • VIEW WORKBOOKS
      • Change Workbook Views
      • Use Zoom
      • Create a Custom View
      • Apply a Custom View
    • FREEZE ROWS AND COLUMNS
      • Freeze Rows and Columns
      • Unfreeze Panes
    • SPLIT THE WORKSHEET WINDOW
      • Add a Worksheet Window Split
      • Remove a Worksheet Window Split
  • DATA AND TABLES
    • SORT DATA
      • Sort by One Column
      • Sort by Multiple Columns
    • TABLES
      • Create a Table
      • Apply a Table Style
      • Convert to a Range
    • ADD AND REMOVE TABLE DATA
      • Add Table Rows and Columns
      • Remove Table Rows and Columns
    • REMOVE DUPLICATES
    • TOTAL ROWS
      • Add a Total Row
      • Change Calculations
    • SLICERS
      • Insert a Slicer
      • Filter with a Slicer
      • Clear and Remove a Slicer
    • FILTER DATA
      • Filter
      • Clear a Filter
    • DATA VALIDATION
      • Create a Validation Rule 
      • Add an Input Message
      • Add an Error Message
    • IMPORT DATA
    • EXPORT DATA
  • CHARTS 
    • CREATE CHARTS
      • Create a Chart
      • Create a Recommended Chart
    • MOVE AND RESIZE CHART
      • Move a Chart
      • Resize a Chart
    • DELETE A CHART
    • CHANGE CHART TYPE
    • LAYOUT AND STYLE
      • Apply a Chart Layout
      • Apply a Chart Style
    • CHART COLORS
    • TITLES AND LEGENDS
      • Change the Chart Title
      • Add Axis Titles
      • Position the Chart Legend
    • GRIDLINES
      • Show Chart Gridlines
    • LABELS AND DATA TABLES
      • Add Data Labels 
      • Display a Data Table
    • DATA SERIES
      • Change the Color of a Data Series
    • MODIFY CHART DATA
      • Add a Data Series
      • Rename a Data Series
      • Reorder a Data Series
    • FILTER CHARTS
      • Filter a Chart
      • Remove a Filter
    • SPARKLINES
    • CHART TEMPLATES
      • Save a Chart as a Template
      • Create a New Chart from a Template

Course Objectives

  1. Format list using advanced formatting commands
  2. Present data using Excel Chart
  3. Create summarize report using Functions

Pre-requisites

Completed "Microsoft Excel 2016: Beginner" course or possess equivalent knowledge and skills

Funding Information

Price

Course Fee:
  Before GST With GST
Full Course Fee  $  330.00  $  353.10
 
Remarks:
  • Individual Sponsored
    • NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP). For more details on UTAP, click here
Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees

MSEI