SG ENABLE - Perform Spreadsheet Functions ( Advanced EXCEL) 13/07, 20/07, 27/07/24 9:00AM -6:00PM 24 HRS (special class for the deaf & hard-of-hearing)

Support the sign interpretation

SG ENABLE- ADVANCED EXCEL
|
Qty



     

Course Info

SG Enable  Course
For Singapore Citizen & PR >=16 years old  with proof  of disability
Course Title : 
Perform Advanced Spreadsheet Functions (Advanced Excel 2019)
 

Course Fee:

-  Full Course Fee: SGD720 (before GST)

-  Netourse fee after SG Enable funding 95% funding : SGD114.70 ( incl GST)
-  Net course fee is Temasek Funding or SkillsFuture Credit applicable 

-After training,  learner will be awarded  Training allowance and Training Commitment award within 15 days from training school.
     Training allowance:  SGD6 X24 HR = SGD144.00
     Training commitment Award: SGD100 

-

Training Mode: Classroom Training

Training Time: 9:00AM - 6:00PM
Course Inquiry:  Vera Lin 94300059
Training Venue:  150 Orchard Road,
Orchard Plaza, #06 -14 , S238841


                 
 


COURSE SYNOPSIS
ICDL Advanced Spreadsheets is a high level certification programme which presents learners with the opportunity to bring their spreadsheet skills to an expert level. This allows them to use the full potential of the spreadsheet application to produce higher quality management information.

Individuals with ICDL Advanced Spreadsheets certified skills can:  
•    Produce higher quality information  
•    Pinpoint key information quicker and more easily  
•    Provide more sharply-defined analysis  
•    Produce more sophisticated reports  
•    Use advanced editing, data handling, functions and analysis features  
•    Use macros within the spreadsheets application 

TARGET AUDIENCE
Prospective learners should ideally have the ICDL certification and/or previous experience using computers and common software applications. Typically, these would be individuals who use a wide range of advanced functionalities within a spreadsheet application in a personal or professional context. Spreadsheet applications enable learners to manipulate and produce precise information and conduct crucial data analysis. The ICDL Advanced Spreadsheets certification has been specifically designed to provide learners with the skills to exploit the full potential of the spreadsheet application.

COURSE CONTENT
 
Overview of Module


1.    Considerations in designing spreadsheets

2.    Formatting 

  • Table AutoFormat
  • Conditional formatting
  • Apply data formats
  •  Using multiple worksheets
  •  Insert, move and remove split
  • Hide and show rows, columns, worksheet

3.    Functions and formula

  • Using cell references in formula
  • Function syntax and categories
  • Logical functions
  • Nested functions
  • Nested functions
  • Mathematical functions
  • Statistical functions
  • Date and Time functions
  • Financial functions
  • Text functions
  • Lookup and Reference functions
  • Database functions
  • Creating Three-D worksheets
  • Paste Special options

4.    Charts

  • Using Custom Charts
  • Formatting charts
     

5.    Analysis

  • Managing data in a spreadsheet
  • PivotTables
  • Data Tables
  • Scenario Manager
  • Sorting a database
  • Auto and Advanced Filters
  • Subtotals

6.    Validating and Auditing

  • Data validation
  • Auditing

7.    Enhancing Productivity

  • Range Names
  • Using Templates
  • Linking data
  • Inserting hyperlinks and bookmarks
  • Import data to Excel
  • Macros

8.    Collaborative Editing

  • Working with comments
  • File protection
  • Accessing and sharing data
Date & Time
Saturday

July 13, 2024

Start - 8:30 AM Saturday

July 27, 2024

End - 5:30 PM Singapore
Location

JAMES COOK INSTITUTE

198802365N
198802365N,150 Orchard Road, 06-14, S238841
238841
Singapore
--JAMES COOK INSTITUTE--
Get the direction
Approved Training Organization

JAMES COOK INSTITUTE

--JAMES COOK INSTITUTE--
SHARE

Find out what people see and say about this Course, and join the conversation.