ICDL Perform Spreadsheet Functions (Excel Fundamentals)

excelICDL Perform Spreadsheet Functions training is a highly funded WSQ Skillsfuture approved course. This Excel course SkillsFuture 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 is 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. The course will be conducted in 2019 excel version.

Course  Objectives

  • Use spreadsheet features to create and manage the output of spreadsheets
  • Use spreadsheet application features to manage data
  • Use spreadsheet application tools to enhance document and productivity

You will be awarded with an e-cert of SOA (Statement of Attainment) by SSG and a hard copy certificate by ICDL Asia (International Computer Driving License) which is recognised world-wide upon the completion of this course and passing the assessment. After that, you may also wish to proceed to the next level learning which is a 3 days of Advanced Excel Training.

Course  Outline

excel courseProgram Fundamentals                

  • Understanding the Excel Screen
  • Giving Commands & Command Shortcuts
  • Create, Open, Save & Close Workbook

Getting Started with Worksheets           

  • Types of Mouse Cursor
  • Entering Labels and Values
  • Selecting and Entering Data in Cell Range
  • Entering Content Automatically

Editing a Worksheet

  • 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

 Formulas and Functions

  • 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

Formatting a Worksheet             

  • Formatting Text & Values
  • Adjusting Row Height and Column Width
  • Working with Cell Alignment
  • Adding Cell Borders & Background Colours
  • Copying Formatting

Creating and Working with Charts

  • 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

Managing Workbooks

  • 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

Working with Data Ranges         

  • Sort by One & Multiple Columns
  • Filtering Data

Customizing Excel          

  • Customizing the Ribbon, Quick Access Toolbar and Excel’s Default Options

Target Audience

During the course of, ICDL Excel – Fundamentals, the learners get to make quick and accurate numerical calculations and help their data to look sharper and more professional.

The Excel course SkillsFuture most suitable for Account Executive, Admin Executive, and HR personnel who deals with number reporting. It allows them to create managed worksheets, create charts, do calculations to manage reports such as inventory listing, payrolls, invoices, payment and product pricing

Course Fees

Full course fees: $449.40 (inclusive of GST)

Company Sponsored Self-Sponsored
SME Non-SME

Singaporean & PR aged from  21-39

Singaporean

Singaporean Aged >= 40
Singaporean & PR

Singaporean & PR

 

Singaporean aged >=40
$71.40 $177.40 $71.40 $177.40 $71.40

 

Note:

  • Company sponsored – – Enhanced Absentee Payroll applicable. (Valid till 31 Dec 2020) ▪ SME & Non-SME – $10 x 16 hours = $160
  • Skillsfuture Credit eligible for Singapore Citizens aged 25 and above.
  • Trainees are entitled to the training grant when they meet 75% of the training attendance and pass
    the requisite assessment.

Course Schedule

Duration: 2 day, 16 hours

5 & 6 Nov (Thurs & Fri), 9am to 6pm @ Mountbatten Square

12 & 13 Nov (Thurs & Fri), 9am to 6pm @ JTC Summit

3 & 4 Dec (Thurs & Fri), 9am to 6pm @ JTC Summit

17 & 18 Dec (Thurs & Fri), 9am to 6pm @ Mountbatten Square

Delivery Mode

This 2 day practical oriented course will be delivered face-to-face, classroom mode and computers are provided.

For more information/ registration or Group / In-House Training, please contact Jaslyn @ 6278 9785 or email jaslyn@cbsgroup.com.sg

RSS
Follow by Email