3MSES01: PERFORM SPREADSHEETS FUNCTIONS
PERFORM SPREADSHEETS FUNCTIONS
Course Duration
Mode of Assessment
NA
Who Should Attend
[For Corporate Registrations only]
- Individuals who are interested in learning how to use a spreadsheet to produce accurate work output professionally.
Course Overview
Work smarter with Spreadsheets.
Rapid digitalisation and the growth of data have made analytical and quantitative skills some of the most important tools to improve productivity at work. By having the skill in Spreadsheets, you will be able to handle data accurately and produce precise work output regardless of your job responsibilities within the company. This course will equip you with the basic knowledge about the functions of Spreadsheets to ensure that you become a proficient user.
Course Schedule
Next available schedule
Course Objectives
Upon course completion, learners will be able to:
- Work with spreadsheets and save them in different file formats
- Choose built-in options such as the ‘Help’ function within the application to enhance productivity
- Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data
- Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets
- Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas
- Format numbers and text content in a spreadsheet
- Choose, create and format charts to communicate information meaningfully
- Adjust spreadsheet page settings, check and correct spreadsheet content before finally printing spreadsheets
Pre-requisites
(a) F2F Classes, these are the admission requirements.
- Know the basic functions of a computer
- Be able to read, write, speak and understand basic English
- Have a keen interest to acquire new knowledge and willingness to learn a new skill
(b) Virtual Learning Classes, these are the admission requirements.
Trainings will be conducted on Zoom platform, thus webcam and microphone are compulsory
- Have a Windows OS PC prior to class with the software installed (Apple Mac OS is not applicable)
- Know the basic functions of a computer
- Be able to read, write, speak and understand basic English
- Have a keen interest to acquire new knowledge and willingness to learn a new skill
Course Outline
Topic 1: Using the Application
- Working with Spreadsheets
- Enhancing Productivity
Topic 2: Cells
- Insert, Select
- Edit, Sort
- Copy, Move, Delete
Topic 3: Managing Worksheets
- Rows and Columns
- Worksheets
Topic 4: Formulas and Functions
- Arithmetic Formulas
- Functions
Topic 5: Formatting
- Numbers/Dates
- Contents
- Alignment, Border Effects
Topic 6: Charts
- Create
- Edit
Topic 7: Prepare Outputs
- Setup
- Check and Print
Certificate Obtained and Conferred by
- Certificate of completion from NTUC LearningHub
Trainees will have to arrange a schedule to attempt the ICDL External exam with NTUC LHUB Exams unit. Successful trainees who have passed the external ICDL exams will receive the internationally recognised ICDL Certificate upon of the course. This certificate is administered by ICDL Singapore, a new initiative from ECDL Foundation.
Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from NTUC LearningHub.
Additional Details
Medium of Instruction: English
Trainer to trainee ratio: 1:20
Mode of Delivery: <Physical class>
Price
Course Fee |
|||||
|
Individual Sponsored Trainee |
Company Sponsored Trainee |
|||
before GST |
after GST |
before GST |
after GST |
||
Full Course Fee |
$500.00 |
$545.00 |
$500.00 |
$545.00 |
Funding Eligibility Criteria
Company Sponsored Trainee |
To qualify for the funding:
|
Terms & Conditions apply. NTUC LearningHub reserves the right to make changes or improvements to any of the products described in this document without prior notice.
Prices are subject to other LHUB miscellaneous fees.
Batch ID | Course Period | Course Title | Funding Available |
Duration (Hours) |
Session (Hours) |
Venue | Available Seats |
Online Payment |
---|