ASK Training

Course Description

ICDL Perform Spreadsheet Functions training is a highly funded SkillsFuture Singapore (SSG) approved course. This course is suitable for those who are new to Excel and need a systematic and structure way of training. Why is it so important to learn Excel? It is because almost every organisation across all industries are using the Excel to boost productivity and improve quality of work. Many different job roles require some knowledge Excel as this is an industry standard software now.

 

In the 2 days of training, you will learn to how to manage data ranges, page layout, create tables, create charts and use simple formulas such as SUM, COUNT and IF.

Course Objectives

At the end of this Photoshop course, you should be able to:

Use spreadsheet application features to manage data

Use spreadsheet features to create and manage the output of spreadsheets

Use spreadsheet application tools to enhance document and productivity

Use spreadsheet application features to manage data

Use spreadsheet features to create and manage the output of spreadsheets

Use spreadsheet application tools to enhance document and productivity

Use spreadsheet application features to manage data

Use spreadsheet features to create and manage the output of spreadsheets

Use spreadsheet application tools to enhance document and productivity

Use spreadsheet application features to manage data

Use spreadsheet features to create and manage the output of spreadsheets

Use spreadsheet application tools to enhance document and productivity

Course Outline

You will be learning the following:

  • Understanding the Excel Screen
  • Giving Commands & Command Shortcuts
  • Create, Open, Save & Close Workbook
  • Editing Cell Contents
  • Copy and Moving Cells & Clipboard
  • Checking Spelling
  • Insert & Delete Cells, Rows & Columns
  • Using Undo and Redo
  • Finding and Replacing Content
  • Adding Comments to Cells
  • Formatting Text & Values
  • Adjusting Row Height and Column Width
  • Working with Cell Alignment
  • Adding Cell Borders & Background Colours
  • Copying Formatting
  • Using Workbook Views
  • Select, Switch, Insert, Delete, Rename, Move & Copy Worksheets
  • Splitting and Freezing a Window
  • Creating Headers and Footers
  • Hidie Rows, Columns, Worksheets & Windows
  • Setting the Print Area
  • Adjusting Page Margins and Orientation
  • Adding Print Titles, Gridlines, Row & Column Headings
  • Adjusting Paper Size & Print Scale
  • Printing Worksheets and Workbooks
  • Customizing the Ribbon, Quick Access Toolbar and Excel’s Default Options
  • Types of Mouse Cursor
  • Entering Labels and Values
  • Selecting and Entering Data in Cell Range
  • Entering Content Automatically
  • Overview of Formulas and Cell References
  • Entering Formulas
  • Formulas with Multiple Operators
  • Inserting and Editing a Function
  • Using Logical Functions
  • Displaying and Printing Formulas
  • Understanding Formula Errors
  • Choosing and Selecting the Source Data
  • Choosing the Right Chart & Elements
  • Inserting, Moving and Resizing a Chart
  • Editing, Adding, and Removing Chart Data
  • Change Chart Data, Layout, Style & Labels
  • Changing the Chart Gridlines
  • Emphasizing Data
  • Applying Different Chart Type
  • Modifying Chart Background
  • Formatting Chart Elements
  • Sort by One & Multiple Columns
  • Filtering Data

Course Fees And Grants

S$449.40 per participant (Inc. GST)

 

SMEs Company Sponsored Singaporean/PR only: S$71.40 (Inc. GST).

 

Click here for more details on WSQ Funding.

 

Click here for UTAP Fundings

 

For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueOct-21Nov-21Dec-21Jan-22Feb-22Mar-22
16hrs - ICDL Perform Spreadsheet Functions (Excel Fundamentals)TGS-2015500266JTC Summit07-08
25-26
08-09
18-19
02-03
20-21
06-07
17-18
07-0807-08
21-22
TGS-2015500266JTC Summit (Weekend)16 & 2306 & 1304 & 1108 & 1512 & 1919 & 26
TGS-2015500266Mountbatten Square
21-2201-0209-1013-1417-1801-02
TGS-2015500266Mountbatten Square (Weekend)02 & 09-18-19-19 & 26-
TGS-2020505421Home Based Learning11-1225-2627-2810-1114-1514-15

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

S$449.40 per participant (Inc. GST)

 

SMEs Company Sponsored Singaporean/PR only: S$71.40 (Inc. GST).

 

Click here for more details on WSQ Funding.

 

Click here for UTAP Fundings

 

For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Browse Courses

Learning Paths

Master Microsoft Office

Master Microsoft Office

Become a Web Designer

Become a Web Designer

Become a Digital Marketer

Become a Digital Marketer

Become a Video Producer

Become a Video Producer