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

    CourseVenueJul-18Aug-18Sep-18Oct-18Nov-18Dec-18
    16hrs - ICDL Perform Spreadsheet Functions (Excel Fundamentals)JTC Summit02-0306-0710-1118-1901-0203-04
    JTC Summit (Weekend)21 & 2818 & 25-20 & 2717 & 24-
    Mountbatten Square 16-17-03-0408-09-06-07
    Ang Mo Kio
    Blk 574
    ------

    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
  • During the course of, ICDL Excel – Fundamentals, the learners get to make quick and accurate numerical calculations and help their data to look sharper and more professional.

    This course is most suitable for Account Executive, Admin Executive, and HR personnel who deals with number reporting. It allows them to create managed worksheets, create charts, do calculations to manage reports such as inventory listing, payrolls, invoices, payment and product pricing.

  • “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.

Course Feedback

Click here to download our course feedback form.

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.