ES WSQ – 2 Days – Perform Spreadsheets Functions (Ms Excel 2013 – 17 hrs) (ICDL Certification Module: Spreadsheets)

Commencement Dates

21/12/2017 to 22/12/2017 [Thu / Fri]
Genetic (Aljunied)
Blk 118 Aljunied Avenue 2, #02-100
Book Now
7/1/2018 to 14/1/2018 [Sun / Sun]
Genetic (Aljunied)
Blk 118 Aljunied Avenue 2, #02-100
Book Now

Overview

Course Duration

17 Hours 

Target Audience

For beginner and professional who in need of spreadsheet in order to create and to produce accurate work outputs.

Pre-requisites

Need to possess the knowledge of basic PC

Certification

Successful trainees will receive the internationally recognized ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore. This is a joint certification between WDA and ICDL Singapore. Student must take a 45 min online assessment at the end of the course.

Course Pathway

ICDL - Perform Advanced Spreadsheet Functions (Advanced Excel 2013)

 

Objectives

This module enables candidates to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application. Candidates will understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.

On completion of this module each candidate will be able to:

  1. Work with spreadsheets and save them in different file formats

  2. Choose built-in options such as the Help function within the application to enhance productivity

  3. Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data

  4. Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets

  5. Create mathematical and logical formulas using standard spreadsheet functions. Use good practice 
    in formula creation and recognize error values in formulas

  6. Format numbers and text content in a spreadsheet

  7. Choose, create and format charts to communicate information meaningfully

  8. Adjust spreadsheet page settings and check and correct spreadsheet content before finally printing spreadsheets

Course Details

SECTION

DESCRIPTION

Section 1 : Introducing Excel 2013

Starting Excel Interface
Excel Screen
Navigating Ribbon
Worksheet Window
Getting Help
Set Preferences

Section 2 : Workbook Management

Workbook Open & Close
Opening Multiple Workbooks
Create & Save a New Workbook
Save in Different Formats & Template
Save & Share Files Online

Section 3 : Data Entry

Enter Labels & Numbers
Enter Formulas - Autosum
Check for Errors
Check Spelling

Section 4 : Worksheet Formatting

Multiple Worksheets
Rename
Copy & Move
Insert & Delete
Switch Workbooks

Section 5 : Data Manipulation

Edit & Delete
Undo & Redo
Ranges
Fill Handles
Flash Fill
Copy & Move Cells
Finding & Replacing Text
Sorting & Filtering

Section 6 : Printing and Output

Printing In Excel
Page Setup - Size, Orientation & Layout
Setting Margins
Printing Selections - Setting a Print Area
Setting Headers & Footers
Printing Titles
Preview Prints

Section 7 : Cell Formatting

Apply Formatting
Fonts, Font Size & Font Styles
Number Formatting
Formatting Dates & Times
Adding Cell Colours & Borders
Alignment & Rotation
Zoom & Freeze Panes
Inserting & Deleting Sheets
Changing Column Width & Row Height
Inserting & Deleting Rows & Columns

Section 8 : Formulas

Introduction to Excel Calculations
Writing Formulas
Order of Operations
Relative & Absolute Cell Addressing
Troubleshoot Errors

Section 9 : Functions

Writing Functions
Autosum
Count Numbers
Average & Round
Maximum & Minimum
Logical Function - IF

Section 10 : Charts

Introducing Charts
Chart Recommendation
Creating Charts
Moving Charts Between Worksheets
Chart Types
Copy, Move & Resize Charts
Formatting Charts
Setting Charts Options

 

Fees Structure

Subsidy and Nett Payable Amount

Subsidy Categories

Fees after subsidy

Fees payable with GST

Company

SME Company

$36/-

$61.20/-

Non – SME Company

$72/-

$97.20/-

Foreigner (WP, S-Pass, E-Pass, Dependant Pass)

$360/-

$385.20/-

Individual

Singaporean - 40 yrs and above

$36/-

$61.20/-

Singaporean – 21 – 39 yrs

$72/-

$97.20/-

Singapore PR

$72/-

$97.20/-

WTS (35 yrs and above - salary less than $2000)

$18/-

$43.20/-

Foreigner and work pass holders – WP, S-Pass,

E-Pass, Dependant Pass)

$360/-

$385.20/-

SME: Small and Medium Enterprise

WTS: Workfare Training Support

Participant need to pass the test to get subsidy


Thank you for your enquiry. One of our course consultants will keep in touch with you shortly.

Request more information

What would you like to request?



+



WE ARE...
Adobe authorized training center
WSQ work skills qualification training center
ICDL test center
EduTrust CPE Singapore
GENETIC COMPUTER SCHOOL
Registration No: 198902296M
24 June 2015 to 23 June 2019
OUR LOCATION
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588