For beginners and professionals who want to learn spreadsheets in order to create and to produce accurate work outputs and tasks associated with developing, formatting, modifying and using a spreasheet.
Need to possess the knowledge of basic PC
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 SSG and ICDL Singapore. The student must take a 45-minute online assessment at the end of the course.
Primary education without PSLE/PSPE Certificate or their equivalent
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:
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 recognize 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 and check and correct spreadsheet content before finally printing spreadsheets
Section 1: Introducing Excel 2016
Excel 2016 Start Screen
Screen, QAT, Ribbon, Worksheet Window, Tell Me
Excel Options to change Preferences
Section 2: Worksheet Essentials
Structure – Worksheet & Workbook,
Cell & Range Address
Navigating – with Keyboard, GoTo F5, NameBox
Create & Save New Workbook, Open, Pin & Unpin
Save in Different Formats – CSV, PDF, Template
Close and Exiting Excel
Section 3: Excel Entries
Enter Numerical Values, Text, Formulas
Editing cell content F2, replace the content
Selection with Mouse, row, column, range
Copy and Cut – ribbon, shortcut, Drag and Drop method
Type of mouse pointer Paste, Paste Preview, Transpose
Participant need to pass the test to get a subsidy
Eligible for Claim Period: 13 Oct 2018 – 12 Oct 2022
All Singaporean aged 25 and above can use their $500 SkillsFuture Credit to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website (www.skillsfuture.sg/credit) to choose for the courses available on the SkillsFuture Credit course directory.
PSEA Funding is available for student aged 21-25 Years old (Pls Call PSEA Hotline 62600777 to check your balance), Form for PSEA Funding is available from Genetic Computer School
Note: Student must bring thumb drive during the lesson.