Main navigation

WSQ Funded

Advanced Excel 2016 Course Overview

The Advanced Excel 2016 training is a high-level Excel certification program. Here, you will master the advanced formulas & functions of Excel, and be able to produce more sophisticated reports, perform complex calculations, saving time & improving productivity.

We focus on teaching you Pivot Tables, Advanced Filters, VLOOKUP & HLOOKUP, Worksheet Protection,  Macros, Working With Multiple workbooks. Laptop provided during Advanced Excel training in Singapore.

Learn Advanced Features of Microsoft Excel.

In Just 3 Days,

Master Pivot Tables, Vlookup, Macros & More...

This training will give you opportunities to practice with real world scenarios. Master Excel Easily, Today!

Course Objectives

  • Learn how to apply Conditional Formatting –  helps to analyse data by highlighting cells in a specified range that meet applied condition or criteria.
  • Creating Pivot Reports – to organise & summarise large amounts of data into easy to read tables.
  • Editing template, copying, hiding or unhiding worksheets, saving workbook as a template.
  • Learn macros which is more useful for recording repetitive tasks.
  • Charting features to display two data series, one in a column & second in a line chart type.
  • Linking data within a spreadsheet or between multiple spreadsheets.
  • Workbook sharing – View, change, save, highlight & review changes and merging shared workbooks.
  • Using Advanced Functions – VLOOKUP, HLOOKUP and many more.

   See Detailed Course Outline Below.

Devices with excel screen
Training Schedule for Upcoming Workshop in Singapore
7, 14, 21 Dec 2019
16, 17, 18 Dec 2019
4, 11, 18 Jan 2020
15, 16, 17 Jan 2020

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

What Will You Learn in this Advanced Excel 2016 Class?

Advanced Excel is the most effective and popular training. It is used by almost every industry and department from Executive to Director level. Virtually all companies need a few people with effective Advanced Excel skills.Advanced Excel at intellisoft

Completion of Advanced Excel 2016 Certification Training, you will be able to:

  • Understand the main concepts of Advanced & Conditional Formatting.
  • Analyse data with Excel.
  • Creating, Filtering, Sorting and summarizing with Pivots.
  • Making use of templates.
  • Working on multiple sheets and workbook.

Course Outline

Advanced Excel 2016 Certification

Module 1: Advanced Formatting in

  • Cells & Worksheets
  • Transposing Cells
  • Copying & Moving Sheets


Module 2: Advanced Functions & Formulas

  • Additional Useful Functions & Formulas
  • Date & Time Functions
  • Lookup (Vlookup, Hlookup)
  • Financial, Database & Nested Functions


Module 3: Charts

  • Creating & Formatting Charts
  • Line & Column Charts
  • Inserting Images in Charts
  • Creating Combination Charts in Excel


Module 4: Data Analysis With Excel

  • Using Tables
  • Sorting and Filtering
  • Scenario Analysis using Excel
  • Analysis with Data Tables
  • Creating Outlines


Module 5: Pivot Table Analysis

  • Creating Pivot Tables
  • Filtering Pivot Data
  • Automatic & Manual Grouping of Pivot
  • Sorting Data in Pivot Tables
  • Summarizing Information With Pivot Tables

Module 6: Validating and Auditing Data

  • Validating Data
  • Adding Custom Messages for Error Handling
  • Auditing Data


Module 7: Enhancing Your Productivity

  • Naming Cells
  • Benefits of Using Paste Special
  • Sorting Multiple Columns
  • Creating Custom Lists & Sorts
  • Custom Auto Filtering Techniques
  • Advanced Filtering of Data
  • Adding Sub-Totals


Module 8: Making Use of Templates

  • Using Templates
  • Expanding on  in-built Templates


Module 9: Linking, Embedding & Importing Data

  • Working With Multiple Sheets, Workbooks
  • Automation
  • Importing Delimited Data
  • Linking & Embedding Hyperlinks
  • Embed Excel Data in Microsoft Word


Module 10: Collaborative Editing

  • Tracking and Reviewing
  • File Security
  • Protection of Cells, Worksheets
  • Sharing of Workbooks
WSQ Funded Courses

Target Audience

Course Duration: 3 full days (Weekdays or Weekends)

Course Timings: 8:45am to 5:45pm

Audience:  Suitable to All Users who have Basic Knowledge of Excel.

Whether you are working or not, from any background Student, Professional, Executive, Manager, Retirees, Housewives,  or any other profile, you are most welcome to Join the Advanced Excel Certification Training. 

Skill Level:  For those who are proficient in Basics of Excel in order to enhance their Excel skills and productivity can join this fun loving training.

Function of advanced excel

Intellisoft in SingaporePrerequisites

  • Any learner with a basic proficiency in reading, writing, and understanding English can pick up the Advanced Excel Skills.
  • We look for participants with Secondary education as a pre-requisite
  • Participants should have completed the Basic Excel training, or demonstrate the basic proficiency in using Spreadsheets – things like basic formatting, copying cells, opening spreadsheets, moving, renaming sheets, writing simple formulas to do basic arithmetic.

IDCL LogoCertification : 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 WDA and ICDL Singapore. Student must clear online assessment at the end of the course to qualify for this International Certificate.

We also offer Excel at Basic / Intermediate Level. Check course outline Basic / Intermediate Excel 2016 training.

What Our Happy Participants Say

Training Course Fees

The full course fees for this training is S$695, 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 95%
(WTS)

$636
$59 You Pay
  • Singaporean, Above 35 Years, &
  • Salary Below S$2000 per month
  • Holding a valid WTS Letter
  • Use SkillsFuture to offset balance fee
  • Grant is capped at $26.5 per hour

UP TO 90% Grant

$600
$95
You Pay
  • Singaporean, Above 40 Years &
  • Salary Above S$2000 per month
  • For SME Companies
  • Use SkillsFuture to offset balance fee
  • Grant is capped at $25 per hour

UP TO 80% Grant

$408
$287
You Pay
  • Singaporean, Below 40 Years &
  • Salary Above S$2000 per month
  • PRs / MNC Companies
  • Singaporeans can use SkillsFuture to offset balance fee
  • Grant is capped at $17 per hour.

Do You Have Any Questions

On Course Fee, WSQ Grant or Funding?

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

Course Dates

Register for Advanced Exel
Training Schedule for Upcoming Workshop in Singapore
7, 14, 21 Dec 2019
16, 17, 18 Dec 2019
4, 11, 18 Jan 2020
15, 16, 17 Jan 2020

Learn With Intellisoft & Boost Your Career

Intellisoft Training at Central Singapore

How to Register for Advanced 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

Send us a message

Intellisoft Training Pte Ltd

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

(65) 6296-4663 (Call)

(65) 9066-9991 (Whatsapp now)