Duration: 2 days
Time: 9am to 6pm

What Will Be Taught For This MS Excel Perform Spreadsheet Functions Course?

This course provides the basis for the practice-based test for ICDL Perform Spreadsheet Functions exam. It sets out essential concepts and skills relating to understanding the concept of spreadsheets and using a spreadsheet to produce accurate work outputs.

Successful candidates will be able to:

  • Work with spreadsheets and save them in different file formats, locally or in the cloud.
  • Use available help resources, shortcuts and the go to tool to enhance productivity.
  • Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data.
  • Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets.
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognize error values in formulas.
  • Format numbers and text content in a spreadsheet and use available autoformat/table styles.
  • Choose suitable charts, and create and format charts to communicate information meaningfully.
  • Adjust spreadsheet page settings and check and correct spreadsheet content before printing.

Module 1. Exploring Microsoft Excel

  • Starting Excel
  • The User Interface
  • The Backstage View
  • Excel Options
  • Creating a Workbook
  • Opening a Workbook
  • Saving the Workbook
  • Closing the Workbook
  • Working with Worksheets
  • Using the Ribbon
  • Hiding the Ribbon
  • Using Zoom Tools
  • Closing & Exiting Excel
  • Practice - Exploring Microsoft Excel

Module 2. Getting Help

  • Using Microsoft Excel Help and Resources
  • Working with Excel Help
  • Practice - Getting Help

Module 3. Basic Workbook Skills

  • Using Keyboard for Selection
  • Using GoTo
  • Entering Text
  • Entering Numbers
  • Shortcuts for Data Entry
  • Editing Data
  • Spell Check
  • Creating a New Folder When Saving
  • Saving the Workbook with Another File Type
  • Practice - Basic Workbook Skills

Module 4. Selection

  • Selecting a cell
  • Selecting a range of adjacent cells
  • Selecting a range of non-adjacent cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of adjacent rows
  • Selecting a range of non-adjacent rows
  • Selecting an entire column
  • Selecting a range of columns
  • Selecting a range of non- adjacent columns
  • Practice – Selection

Module 5. Working with Columns and Rows

  • Adjusting the Column Width
  • Adjusting the Row Height
  • Automatically Adjusting Columns
  • Hiding and Un-hiding Rows and Columns
  • Inserting Columns and Rows
  • Deleting Columns and Rows
  • Freezing and Unfreezing Columns and Rows
  • Practice - Working with Columns and Rows

Module 6. Number Formatting

  • About Number Formats
  • Accounting Number Style
  • Percent Style
  • Comma Style
  • Decimal Places
  • Practice – Number Formatting

Module 7. Text Formatting

  • Formatting Text
  • Changing the Font
  • Changing Font Size
  • Bold and Italic
  • Underlining Text
  • Font Color
  • Rotating Text
  • Text Wrapping
  • Cell Alignment
  • Apply Table Style
  • Practice – Text Formatting

Module 8. Cell Formatting

  • Merging Cells
  • Vertical Alignment
  • Unmerge Cells
  • Adding Borders
  • Drawing Borders
  • Adding Fill Colors
  • Format Painter
  • Inserting Cut or Copied Cells
  • Deleting Cells
  • Practice – Cell Formatting

Module 9. Working with Tables

  • Adding Table Rows and Columns
  • Practice - Working with Tables

Module 10. Formulas

  • Using Basic Formulas
  • Entering Formulas
  • Basic Functions
  • Using the AutoSum Button
  • Using the AutoSum List
  • Using Formula AutoComplete
  • Editing Functions
  • Using Auto Calculate
  • Modifying Formulas using the Range Border
  • Error Checking
  • Create Absolute Reference
  • Using IF Function
  • Practice – Basic Formulas

Module 11. Cut, Copy and Paste

  • Copying and Pasting Data
  • Cutting Data
  • Copying Formulas
  • Paste Options
  • Paste List
  • Filling Cells
  • Drag-and-Drop Editing
  • Undo and Redo
  • Practice – Cut, Copy and Paste

Module 12. Data Management

  • Sorting
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Format
  • Practice – Data Management

Module 13. Creating Charts

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Deleting a chart
  • Adding a Chart Title
  • Changing the Chart Background
  • Format chart legend, axis
  • Changing a column, bar, line or pie slice colors
  • Changing the chart type
  • Adding a Data Table
  • Changing the Chart Layout
  • Moving charts
  • Delete chart
  • Practice - Creating Charts

Module 14. Using Page Setup

  • Worksheet margins
  • Worksheet orientation
  • Worksheet page size
  • Headers and Footers
  • Header and footer fields
  • Scaling your worksheet to fit a page(s)
  • Repeating Row and Column Labels
  • Changing Page Breaks
  • Setting/Removing a Print Area
  • Changing Sheet Options
  • Practice - Using Page Setup

Module 15. Printing

  • Print Preview
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing a Page Range
  • Printing Multiple Copies
  • Practice - Printing

Who Should Attend This MS Excel Perform Spreadsheet Functions Course Training?

Ideal for beginners in Microsoft Office Excel to develop a solid foundational understanding of spreadsheet concepts and applications.

Pre-requisite

An understanding of Windows / Microsoft Excel 2013/2016 will be an added advantage.

  w/o GST w GST
Course Fee $400 $428
Singapore Citizen & PR aged ≥ 21 years $111 $139
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$40 $68
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$20 $48
  w/o GST w GST
Course Fee $400 $428
Singapore Citizen & PR aged ≥ 21 years $111 $139
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$40 $68
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$20 $48
  w/o GST w GST
Course Fee $400 $428
Singapore Citizen & PR aged ≥ 21 years $111 $139
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$40 $68
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$20 $48

Remarks:

COMAT is a business centre of e-Services, Electronics, ST Engineering.

Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
  • This course is eligible for using PSEA funds.

Company Sponsored

  • Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
  • Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr
  • Absentee payroll claimable by companies (SMEs and Non-SMEs) sponsoring candidates under WTS Scheme: Up to 95% of hourly basic salary (no dollar cap)

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attain minimum 75% attendance and pass ALL Assessments/Exams in order to qualify for Funding.
  • Trainee undertakes to reimburse e-Services, Electronics, ST Engineering FULL course fees should he/she be ineligible for course fee grant. e-Services, Electronics, ST Engineering is not liable for any other funding not approved by WSG.
  • e-Services, Electronics, ST Engineering reserves the right to change the date or venue without prior notice.
  • e-Services, Electronics, ST Engineering reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.