16hrs – ICDL Perform Spreadsheet Functions (Excel Fundamentals)

Course Code: CRS-Q-0026928-ES

Course Objective – 16hrs – ICDL Perform Spreadsheet Functions (Excel Fundamentals)

During the course of 16hrs – ICDL Perform Spreadsheet Functions (Excel Fundamentals), you will be learning:

  1. Use spreadsheet features to create and manage output of spreadsheets
  2. Use spreadsheet application features to manage data
  3. Use spreadsheet application tools to enhance document and productivity

Upon the completion of this course, it allows you to proceed to the next level which is 24hrs ICDL Perform Advanced Spreadsheet Functions Excel Advanced

  • Course Dates and Venue

    Course Duration: 2 days (16 hours) 9am – 6pm

    CourseVenueOct-17Nov-17Dec-17Jan-18Feb-18Mar-18
    16hrs - ICDL Perform Spreadsheet Functions (Excel Fundamentals)JTC Summit19-2013-1414-1503-0401-0201-02
    JTC Summit (Weekend)07 & 1404 & 11-06 & 13--
    Mountbatten Square -02-03-09-10-06-07
    Mountbatten Square (Weekend)21 & 28-02 & 09---

    September 2015

    SMTWTFS
    30
    31
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    1
    2
    3
  • Program Fundamentals                

    • Understanding the Excel Screen
    • Giving Commands & Command Shortcuts
    • Create, Open, Save & Close Workbook

    Getting Started with Worksheets           

    • Types of Mouse Cursor
    • Entering Labels and Values
    • Selecting and Entering Data in Cell Range
    • Entering Content Automatically

    Editing a Worksheet

    • Editing Cell Contents
    • Copy and Moving Cells & Clipboard
    • Checking Spelling
    • Insert & Delete Cells, Rows & Columns
    • Using Undo and Redo
    • Finding and Replacing Content
    • Adding Comments to Cells

     Formulas and Functions

    • Overview of Formulas and Cell References
    • Entering Formulas
    • Formulas with Multiple Operators
    • Inserting and Editing a Function
    • Using Logical Functions
    • Displaying and Printing Formulas
    • Understanding Formula Errors

    Formatting a Worksheet             

    • Formatting Text & Values
    • Adjusting Row Height and Column Width
    • Working with Cell Alignment
    • Adding Cell Borders & Background Colours
    • Copying Formatting

    Creating and Working with Charts

    • Choosing and Selecting the Source Data
    • Choosing the Right Chart & Elements
    • Inserting, Moving and Resizing a Chart
    • Editing, Adding, and Removing Chart Data
    • Change Chart Data, Layout, Style & Labels
    • Changing the Chart Gridlines
    • Emphasizing Data
    • Applying Different Chart Type
    • Modifying Chart Background
    • Formatting Chart Elements

     Managing Workbooks

    • Using Workbook Views
    • Select, Switch, Insert, Delete, Rename, Move & Copy Worksheets
    • Splitting and Freezing a Window
    • Creating Headers and Footers
    • Hidie Rows, Columns, Worksheets & Windows
    • Setting the Print Area
    • Adjusting Page Margins and Orientation
    • Adding Print Titles, Gridlines, Row & Column Headings
    • Adjusting Paper Size & Print Scale
    • Printing Worksheets and Workbooks

    Working with Data Ranges         

    • Sort by One & Multiple Columns
    • Filtering Data

    Customizing Excel          

    • Customizing the Ribbon, Quick Access Toolbar and Excel’s Default Options
  • For people who are able to operate a PC and understand English.

  • “We got to learn the use of different functions and formulas which are relevant to my personal development. Priscilla is very well prepared, extremely helpful, patient and very understanding.” – Moses Hai Raymond Freddy (14 – 15 Nov 2016)

    “Learn to use excel productively in family’s finances. Priscilla is patient, thorough and has lots of professionalism.” – Moses Hai Raymond Freddy (14 – 15 Nov 2016)

Fees and Grants

$449.40 per participant (Inc. GST)

SMEs Company Sponsored Singaporean/PR only: $71.40 (Inc. GST).
Click here for more details on Grant.

SDF subsidy: WSQ Courses. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

Applicants may use SkillsFuture Credit for this course

Registration

Click here to download registration form for company-sponsored trainees.

Click here to download registration form for self-sponsored trainees.

Apply Online - ICDL

16hrs – ICDL Perform Spreadsheet Functions (Excel Fundamentals) (CRS-Q-0026928-ES)


All registration should be submitted at least 1 week before course commencement. Please call us directly to check on the class status.

A. Company Particulars

Company Name

Company Address

Postal Code

B. Training Coordinator / Contact Person

TC / Contact Person Name*

TC / Contact Person Email*

Contact Number*

C. Billing Information


Billing Contact Person Name*

Billing Contact Person Email*

Billing Contact Number*

Billing Fax Number

Business Unit (BU / SBU)

For Businesses or Government Agencies using the e-invoice system only.

Are you applying for SDF Grant?

D. Participants


Participant 1

NRIC Type

Gender

Nationality

Race

Education Level

Salary Range

Course Start Date*

Course End Date*

Participant 2

NRIC Type

Gender

Nationality

Race

Education Level

Salary Range

Course Start Date

Course End Date

Participant 3

NRIC Type

Gender

Nationality

Race

Education Level

Salary Range

Course Start Date

Course End Date

Have more than 3 participants?

Attach their particulars here (PDF, Word .doc, Excel .xls)

I have Read and Agree to the Terms and Conditions


We do not sell or share your information with anyone else.