WSQ Funded Basic-Intermediate Excel Course

Learn working with Excel Ribbon Cell & Sheets Formatting Essential Functions Charts IF Function Referencing Arithmetic Formulas in Just 2 Days!

Basic Excel 2016 Course Overview

Microsoft Excel commonly used in almost every field, it is extremely easy to learn and it improves your productivity & efficiency.

You can learn the simple tips and tricks in Basic-Intermediate Excel Workshop, which make simple to complex tasks easy, with our
Step-by-step, Practical, and Hands-on training.

View the video for a quick overview of this Excel training.

Excel For Office Productivity

Course Objectives

The Basic Excel Hands-on training teaches you how to use Microsoft Excel 2016 extremely well for day to day use in the office, and at home. You will learn how to create Spreadsheets with multiple sheets, rows, columns, formatting, as well as some key functions and formulas.  You will gain confidence in Creating Excel Files, copy, move, use formulas, summarize, tabulate, create charts, use images, and do all kinds of formatting & printing options. Learn to Write Formulas, Functions, Create Tables to Summarize Information, Charts to Tabulate Data and Work with Multiple Worksheets easily.
  • GET familiar with Excel Ribbon.
  • IMPROVE your Productivity by Learning Many Shortcuts.
  • LEARN Basic Formulas & Functions to Save Time.
  • WORK with different types of Charts & Graphs to Produce Accurate & Presentable Data.
  • COMPILE & Summarize Data from Multiple Worksheets & Workbooks.
  • HIGHLY Recommended for People who want to Upgrade themselves & Move to the Next Level.

WSQ Funded Advanced Excel Course

Need a Course Brochure?
We'll send you one!

Course Outline

Basic Excel 2016 Certification

Module 1: Using Excel Application

  • Get Familiar With Excel Ribbon
  • Opening & Working with Multiple Spreadsheets, Workbooks
  • Enhancing Productivity
  • How to Use Help
  • How to Set Preferences

Module 2: Opening & Closing Workbooks

  • Opening Multiple Workbooks
  • Adding, Moving, Renaming Worksheets
  • Copy, Move, Delete Sheets & Workbooks

Module 3: Formulas and Functions

  • Arithmetic Formulas
  • Functions
  • Brackets
  • Auto Functions
  • Checking for Errors
  • IF Function
  • Count, Average, Round, Min, Max
  • Absolute Referencing
  • Relative Referencing

Module 4: Editing Cells, Sheets

  • Editing Cells,
  • Using Undo, Redo
  • Copying
  • Moving
  • Replacing Text
  • Find & Replace
  • Sorting
  • Filtering

Module 5: Formatting the Data

  • Numbers/ Dates
  • Contents
  • Alignment, Border Effects
  • Freezing Panes

Module 6: Creating Charts in Excel

  • Creating Charts
  • Editing Charts
  • Moving, Resizing
  • Printing Charts

Module 7: Prepare Beautiful Outputs

  • Setup
  • Check and Print
WSQ funded Training Programs

Target Audience

Course Duration:  2 Days full days (Weekdays or Weekends)

Course Timings: 8.45 am – 5.45 pm

Target Audience: For beginner and professional who in need of basic Excel knowledge in order to produce charts and data analysis.

Prerequisites: Need to possess the knowledge of basic PC skills.

Certification: 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. Student must take a 60 minutes online assessment at the end of the course.

Student using LaptopLearners’ Profile:

      1. Any learner with a basic proficiency in reading, writing, and understanding English can pick up the Core Spreadsheet Skills.
      2. We look for participants with Secondary education as a per-requisite
      3. Participants should have completed the Basic PC Skills training.

We also offer Excel at Advanced Level. Check Course Outline for Advanced Excel 2016 training.

What Our Happy Participants Say

Training Course Fees

The full course fees for this training is S$485, before any Government funding.
For Singaporean/PR above 21 years, Training Grants are available.
For Foreigners, no government grants are available.

Grant Information

WSQ funding from SkillsFuture Singapore (SSG) is available to Singaporeans/PRs above 21.
(Both Individuals & Company Sponsored ).

Individual Singaporeans, 25 years & above can also use their SkillsFuture Credits for this training at Intellisoft.

Contact us for more information on How to apply for this SkillsFuture Grant.
Call +65-6296-4663 for Details or WhatsApp Now at +65-9066-9991

up to 70% Grant

$339.50 Funding by SSG
Pay $145.50
  • Singaporeans Above 40 Years
  • Individuals
  • SME Companies
  • Individuals Can Use SkillsFuture

up to 50% Grant

$242.50 Funding by SSG
Pay $242.50
  • Below 40 Years
  • Individuals
  • SG / PR / MNC Companies
  • SkillsFuture (Singaporeans only)

Do You Have Any Questions

On Course Fee, WSQ Grant or Funding?

Ask Us. We’ll be happy to assist you.

Course Dates

Learn With Intellisoft & Boost Your Career

Intellisoft Training at Central Singapore

How to Register for Basic Excel 2016 Training ?

Simply fill this Online Registration Form to book your seat.
Our Training Officer will get in touch with you to confirm your seat shortly.

You can call at at +65 6296-4663 or 9066-9991 (Whatsapp now) if you have any questions.
Register Now

Get in Touch

Intellisoft Training Pte Ltd

5001 Beach Road, #06-05 Golden Mile Complex,
Singapore 199588

(65) 6296-4663 (Call)

(65) 9066-9991 (Whatsapp now)