ICDL EXCEL FUNDAMENTALS
(WSQ COURSE)

Learn to basic of using excel spreadsheet and create tables and use of basic calculation functions.

Programme Content

Excel spreadsheet is a powerful tool. The ICDL Perform Spreadsheet Functions training is a highly funded WSQ Skillsfuture approved course. This course is suitable for those who are new to Excel and need a systematic and structure way of training. It is important to learn Excel 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. In Summary, you will be able to : 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.

Course Deliveries

Program 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

Durations

16 hrs

Prerequistes

Note:

 

Self-Sponsored

  1. Singaporean & PR aged 21 and above = 70% funding.

  2. Singaporeans only (not PR) aged 40 and above = 90% funding.

  3. Singaporeans aged 35-39 with WSS letter = 70% funding.

Company-Sponsored (till end of 2020)

  1. Singaporeans & PRs aged 21 years and above are allowed 90% funding.

  2. Absentee Payroll applies for company sponsored up to $10/training hour. Please use Absentee Payroll calculator provided by SSG to calculate the absentee payroll for your employee.

 

All information is correct at time of publish (18 August 2020). The company reserves the rights to make any changes at any time without notice at its discretion.

Notes to Application:

  1. Please check the available date before you apply for your course.

  2. Your application does not qualify for a seat for the course. You will receive a phone call from our friendly consultant who will assist you in the application.

  3. The Training Provider (ATO) reserves the rights to postpone or cancel the course if the course does not meet the minimum learners required.

Application Procedures:

  1. Applications can enquire online or through email or WhatsApp. We will be in touch with you for the documents required to complete your registration

  2. Upon your seat confirmation, you will receive a confirmation email from the training provider.

  3. Payment must be made prior to the commencement of the course.

 

For Enquiries:

Should you required any further assistance, please contact us at our hotline at

8155 6920 or email to support@ifuture.sg

© 2020 Proudly created by  iFuture.sg