Basic Excel 2016

Working on Laptop

Course Overview

The Basic-Intermediate Excel Training is well suited for beginners as well as people experienced in using Excel.

This is a very Practical and Hands-On Training, full of exercises.

Learn to Write Formulas, Functions, Create Tables to Summarize Information, Charts to Tabulate Data and Work with Multiple Worksheets easily.

Learners Profile :

Improve Productivity with Intellisoft
  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 of Advanced Excel 2013 OR Advanced Excel 2016 training.

Excel in Multiple Devices

Course Duration:  2 Days (8:45am to 5:45pm)
Weekdays or Weekends available.

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

Course Module - Basic Excel 2016

MODULE I | Using Excel Application

MODULE IV | Editing Cells Sheet

  • Get Familiar With Excel Ribbon
  • Opening & Working with Multiple Spreadsheets, Workbooks
  • Enhancing Productivity
  • How to Use Help
  • How to Set Preferences
  • Editing Cells,
  • Using Undo, Redo
  • Copying
  • Moving
  • Replacing Text
  • Find & Replace
  • Sorting
  • Filtering

MODULE II | Opening and Closing Workbooks

MODULE V | Formatting Data

  • Opening Multiple Workbooks
  • Adding, Moving, Renaming Worksheets
  • Copy, Move, Delete Sheets & Workbooks
  • Numbers/ Dates
  • Contents
  • Alignment, Border Effects
  • Freezing Panes

MODULE III | Formulas & Functions

MODULE VII | Creating charts in Excel

  • Arithmetic Formulas
  • Functions
  • Brackets
  • Auto Functions
  • Checking for Errors
  • IF Function
  • Count, Average, Round, Min, Max
  • Absolute Referencing
  • Relative Referencing
  • Creating Charts
  • Editing Charts
  • Moving, Resizing
  • Printing Charts

MODULE IV | Prepare Beautiful Outputs

  • Setup
  • Check and Print

How to Register: Simply fill this Online Registration Form. The Intellisoft Training Officer will get in touch with you to confirm your seat shortly. You can call us at +65 6296-4663 if you have any questions.

Use Skills Future at Intellisoft
Recognised certification
WSQ Funding


Sufficient practice and more short cuts learnt to save time and speed up productivity – Grace 

Different kind of charts & graphs are very useful to produce accurate, presentable data – Jurong Health

Trainer was very patient in helping the slow learners. The session was interesting & learnt a lot of new things in Excel – Alan

I liked the training very much as there were lot of hands-on to practice rather than following the note book – Maria

See how I helped my friend Mark in improving his Excel productivity – reduce errors, and come back on time for our jog…

Intellisoft Trainings