NSAFD01 - NSA - MICROSOFT EXCEL by NTUC LearningHub

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

Required Prerequisites:

(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

Successful trainees will receive the internationally recognised ICDL Certificate upon completion of the course. This certificate is administered by ICDL Singapore, a new initiative from ECDL Foundation.