Microsoft Excel 2016 – Level 3 Beyond AdvancedIT Short Courses

Enquire MoreRegister NowCorporate Courses

DurationTwo days
Course Dates27 Mar 2024 9:00am - 28 Mar 2024 5:00pm
25 Jun 2024 9:00am - 26 Jun 2024 5:00pm
19 Sep 2024 9:00am - 20 Sep 2024 5:00pm
03 Dec 2024 9:00am - 04 Dec 2024 5:00pm

Course Fee

Member $370.60
Non-Member $436.00
  • Members enjoy a 15% discount before GST
  • Group Discount (5 or more participants) - 10%
  • Course fees updated with 9% GST for 2024

Funding Available

    SDF Grant Amount: S$28.00
    Course Reference No.: TGS-2020501721
    SkillsFuture Credit
    (Individual Singaporean aged 25 and above)
    Pre-approved SkillsFuture funding of S$500.00

Click HERE for more info on SkillsFuture.


An often overlooked area of Excel is its power to derive answers from the data entered. This takes Excel out of the realm of a mere spreadsheet and into the realm of a “modeller” – the ability to build analytical solutions and conclusions.

Key Takeaways

Upon completion of this workshop, participants will be able to;

  • To empower existing Excel users who wish to take their skills further and venture into the areas of Data Modelling, Financial Expositions, Statistical Summaries and Scenario Management

Who Should Attend

This course would benefit anyone who needs to apply advanced analysis techniques to more complex data sets.

Programme Outline

Module 1: Custom Formatting

  • Creating new styles
  • Applying & modifying styles
  • Merging styles
  • Complex Number Formatting
  • Number format codes
  • Creating custom number formats
  • Displaying leading or trailing zeros
  • Customize currency, date, time, scientific & text formats

Module 2: Advanced Data Manipulation

  • Rounding Numbers
  • Rounding to significant figures
  • Rounding to nearest multiple
  • Rounding dollar values
  • Extracting integer values
  • Rounding to even or odd integer
  • Manipulating Text
  • Matching cell contents
  • Joining cells
  • Changing cases
  • Extracting character
  • Text length
  • Working with Dates & Times
  • Calculate the number of days. months or years between dates
  • Offsetting a date
  • Calculate the time difference
  • Rounding time values
  • Counting, Summing & Averaging Techniques
  • Conditional counting & multiple criteria
  • Counting frequent entries
  • Conditional summing & multiple criteria
  • Conditional averaging & multiple criteria

Module 3: Specialized Lookups

  • Two Way Lookup with INDEX & MATCH
  • Multiple Column Lookup

Module 4: Financial Functions

  • Loan Calculations
  • Investment Calculations
  • Depreciations

Module 5: Statistical & Array Functions

  • Constructing Array Formulas
  • Ranking
  • Frequency Distribution
  • Histograms

Module 6: Advanced Data Analysis

  • Analysis ToolPak
  • Regression
  • Sampling
  • Working with Trend Lines

Module 7: Data Modelling

  • Building Spreadsheet Models
  • Optimising Spreadsheet using Solver

Module 8: Introduction to Macros

  • Recording a Macro
  • Running Macros
  • Assigning Macros

Module 9: Forms in Excel

  • Understanding Excel’s Forms & Form Controls
  • Using the Form Controls
  • Text boxes & labels
  • Checkboxes & option buttons
  • Spinner & combo boxes
  • Drop-down lists
  • Buttons
  • Form Calculations


A good foundation in Excel is essential for this course. Participants should be familiar with absolute vs. relative cell referencing, basic and conditional functions and formulae syntax, chart creation, as well as worksheet linking. Having attended an advanced course is advantageous.

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied for this course.

Experiential learning approach is adopted where the learners will be required to consider the experience as a learning process joined with critical reflection which further qualifies for this theory to be applied for this course because, at each segment, the learners are introduced to some form of experience after which they are asked to reflect on these experiences before sharing and putting ideas into practice.

If you are interested in this corporate programme, please complete the following form and one of our representatives will get back to you as soon as possible.

I would like to receive marketing, advertising and promotional messages via:
(Please untick if you do not wish to receive)

MDIS values your privacy and we are committed to safeguarding your personal data in compliance with the Personal Data Protection Act 2012. By providing your personal details, you have authorised MDIS to share with you our marketing, advertising and promotional materials.

Quick Information

An often overlooked area of Excel is its power to derive answers from the data entered. This takes Excel out of the realm of a mere spreadsheet and into the realm of a "modeller" - the ability to build analytical solutions and conclusions.

Contact Details

  +65 6842 6666