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 Module 4 Perform Spreadsheet Functions exam.

The exam requires the candidate to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she shall understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. The candidate shall be able to accomplish standard mathematical and logical operations using basic formulas and functions. The candidate shall demonstrate competence in using some of the more advanced features of a spreadsheet application such as importing objects, and creating graphs and charts.

Module 1. Exploring Excel
  • Working with Excel
  • Starting Excel
  • Using the Office Button
  • Exploring Excel Options
  • Using the Ribbon
  • Hiding the Ribbon
  • Customizing the Quick Access Toolbar
  • Using the Mini Toolbar
  • Customizing the Status Bar
  • Exiting Excel
  • Labs
Module 2. Getting help
  • Using Microsoft Excel Help and Resources
  • Working with Excel Help
  • Looking Further for Answers
  • Labs
Module 3. Using Basic Workbook Skills
  • Selecting a Cell using the Keyboard
  • Using Key Tips
  • Scrolling using the Mouse
  • Using the Go To dialog box
  • Entering Text into Cells
  • Entering Numbers into Cells
  • Saving a New Workbook
  • Closing a Workbook
  • Creating a New Workbook
  • Using a Template
  • Opening an Existing Workbook
  • Using Data Entry Shortcuts
  • Editing Cell Entries
  • Checking Worksheet Spelling
  • Creating a New Folder
  • Renaming an Existing Workbook
  • Labs
Module 4. Working with Ranges
  • Working with Ranges
  • Selecting Ranges with the Mouse
  • Selecting Ranges with the Keyboard
  • Selecting Non-adjacent Ranges
  • Entering Values into a Range
  • Using the Auto Fill Feature
  • Labs
Module 5. Working with Columns and Rows
  • Selecting Columns and Rows
  • Using Narrow Columns Tooltips
  • Changing the Width of Columns
  • Changing the Height of Rows
  • Adjusting Columns Automatically
  • Hiding Columns and Rows
  • Unhiding Columns and Rows
  • Inserting a Column
  • Insert a Row
  • Deleting a Column
  • Deleting a Row
  • Labs
Module 6. Formatting Numbers
  • Using Number Formats
  • Using the Accounting Number Style
  • Using the Percent Style
  • Using the Comma Style
  • Changing Decimal Places
  • Labs
Module 7. Formatting Text
  • Changing an Existing Font
  • Modifying the Font Size
  • Using Bold and Italics
  • Underlining Text
  • Changing the Font Color
  • Rotating Text in a Cell
  • Wrapping Text in a Cell
  • Shrinking Text in a Cell
  • Changing Cell Alignment
  • Changing Text Indentation
  • Labs
Module 8. Formatting Cells
  • Using the Merge and Center Button
  • Changing the Vertical Alignment
  • Splitting Cells
  • Using the Borders Button
  • Drawing Cell Borders
  • Using the Fill Color Button
  • Pasting Formats
  • Using the Format Painter Button
  • Copying Formats to Non-Adjacent Cells
  • Clearing Formats
  • Inserting Selected Cells
  • Inserting Cut or Copied Cells
  • Deleting Selected Cells
  • Labs - Formatting Cells
Module 9. Creating Simple Formulas
  • Using Formulas
  • Entering Formulas
  • Using the AutoSum button
  • Using the AutoSum List
  • Inserting Functions in Formulas
  • Editing Functions
  • Using the AutoCalculate Feature
  • Using Range Borders to Modify Formulas
  • Checking Formula Errors
  • Using IF Function
  • Labs
Module 10. Copying and Moving Data
  • Copying/Cutting and Pasting Data
  • Copying and Pasting Formulas
  • Using the Paste Options Button
  • Using the Paste List
  • Using the Clipboard Task Pane
  • Creating an Absolute Reference
  • Filling Cells
  • Using Drag-and-Drop Editing
  • Using Undo and Redo
  • Labs
Module 11. Creating Charts
  • Using Charts
  • Creating Charts
  • Moving and Resizing Charts
  • Identifying Chart Elements
  • Changing the Chart Type
  • Swtich Row/Column
  • Removing/Adding a Legend
  • Moving the Legend
  • Charting Non-adjacent Ranges
  • Changing the Chart Range
  • Changing the Data Source
  • Changing the Chart Location
  • Printing a Chart
  • Labs
Module 12. Formatting Charts
  • Adding Chart Titles
  • Formatting Chart Title
  • Formatting Chart Elements
  • Changing the Text Orientation
  • Adding a Data Table
  • Creating an Exploded Pie Chart
  • Adjusting the 3D View
  • Deleting a Chart
  • Labs
Module 13. Managing Data
  • Sorting in Ascending/Descending Order
  • Finding Data
  • Replacing Data
  • Finding and Replacing Cell Formats
  • Labs
Module 14. Using Page Setup
  • Setting Margin and Centering Options
  • Changing the Page Orientation and Paper Size
  • Repeating Row and Column Labels
  • Scaling a Worksheet
  • Changing Page Breaks
  • Setting/Removing a Print Area
  • Changing Headers and Footers
  • Using Built-in Headers and Footers
  • Labs
Module 15. Printing
  • Previewing a Worksheet
  • Printing the Current Worksheet
  • Printing a Selected Range
  • Printing a Page Range
  • Printing Multiple Copies
  • Labs - 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 / MS Excel 2003 will be an added advantage.

  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $91 $117.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60
  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $91 $117.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60
  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $38 $64.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60

Remarks:

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 attained minimum 75% attendance and pass ALL Assessments/Exams in order to qualify for Funding.
  • Trainee undertakes to reimburse ST Electronics (e-Services) FULL course fees should he/she be ineligible for course fee grant. ST Electronics (e-Services) is not liable for any other funding not approved by WSG.
  • ST Electronics (e-Services) reserves the right to change the date or venue without prior notice.
  • ST Electronics (e-Services) reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.