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

Commencement Dates

27/9/2018 to 28/9/2018 [Thu / Fri]
Genetic (Aljunied)
Blk 118 Aljunied Avenue 2, #02-100
Book Now
6/10/2018 to 13/10/2018 [Sat / Sat]
Genetic (Aljunied)
Blk 118 Aljunied Avenue 2, #02-100
Book Now
15/10/2018 to 16/10/2018 [Mon / Tue]
Genetic (Aljunied)
Blk 118 Aljunied Avenue 2, #02-100
Book Now
18/10/2018 to 19/10/2018 [Thu / Fri]
Genetic (Jurong Gateway)
21 Jurong Gateway #03-09/10 CPF Jurong Building Singapore 608546
Book Now
18/10/2018 to 19/10/2018 [Thu / Fri]
Genetic (Bedok)
Blk 209 New Upper Changi Road, #04-643
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

 

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

 

Singaporean 25 to 39 & PR

Mid-Career Enhanced & Subsidy >=40 years old born on /before 1978

WTS, > = 35 years old  born on/before 1983

Course Fee

$360.00

$360.00

$360.00

SkillsFuture Funding

$288.00

$324.00

$342.00

Total Gross Fee

$72.00

$36.00

$18.00

GST 7%

$25.20

$25.20

$25.20

SkillsFuture Credit Deduction/Cash

$97.20

$61.20

$43.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
Main Office
Block 118 Aljunied Avenue 2
#02-100 Singapore 380118
Tel: +65 6339 7588
Bedok Branch
Blk 209 New Upper Changi Road
#04-643 Singapore 460209
Tel: +65 6913 4572
Jurong Branch
CPF Jurong Building 21
#03-09/10 Jurong Gateway Road
Singapore 150167
Tel: +65 6912 4316
Bukit Merah Branch
Blk 167 Jln Bt Merah Tower 4, Connection One
#06-11A Singapore 150167
Tel: +65 6928 0735