Microsoft Excel 2016 - Level 2 Advanced


Course introduction

Excel has become very much more than just a simple spreadsheet. Although its roots are still in number management, today Excel’s uses cover a wide gamut – from simple data entry to complicated financial models and analysis.

Course Benefits

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

  • Learn how to use complex functions to model their data
  • Learn to generate a variety of answers and reports.

Target Audience

Those seeking to further their knowledge of Excel would benefit from this course. Those needing to create spreadsheet models & data analysis are especially encouraged to attend.

Course Outline

Using Range Names

  • Assigning Names
  • Jumping to Named Ranges
  • Create Range Names from Headings
  • Managing Names
  • Using Names in Formulas and Functions
Database / List Operations
  • Introduction to Excel Databases
  • Using Tables
  • Removing Duplicates
  • Filtering
  • Database Functions
  • Summarise Data Using Subtotals
  • Grouping and Outlining Data
Data Validation
  • Setting Data Validation
  • Displaying Input Message and Error Alert
  • Circling Invalid Data
Data Consolidation
  • 3D Formulae: Using Multi-Dimension Worksheets and Workbooks
  • Consolidating Data
Auditing Worksheets
  • Tracking Errors in Excel
  • Understanding Precedents and Dependencies
  • Viewing and Hiding Tracer Arrows
  • Resolving Circular References
  • Using the Watch Window
  • Evaluate Formulas
Advanced Functions
  • Nesting of Functions
  • Lookups and Referencing
  • Combining Functions
Data Analysis
  • What-If Analysis
  • Using Goal Seek
  • Solver
  • Using the Scenario Manager
Pivot Tables
  • Understanding Pivot Tables
  • Building a Pivot Table
  • Pivot Table Formatting
  • Creating Pivot Charts
  • Printing a Pivot Report
  • Sharing Workbooks
  • Merging Workbooks

A good foundation in Excel is essential for this course. Participants should be familiar with the program and be able to write basic formulae. Having attended an essentials 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 with each other and putting ideas into practice.

Key Information
Duration 2 days
Time 9 am to 5 pm
Date 10 - 11 Dec 2018
28 - 29 Jan 2019
25 - 26 Feb 2019
21 - 22 Mar 2019
15 - 16 Apr 2019
23 - 24 May 2019
24 - 25 Jun 2019
22 - 23 Jul 2019
29 - 30 Aug 2019
16 - 17 Sep 2019
21 - 22 Oct 2019
14 - 15 Nov 2019
12 - 13 Dec 2019
Trainer Microsoft Certified Trainer

Course Fee
Member $272.85
Non-Member $321.00
  • Members enjoy a 15% discount before GST
  • Group Discount (5 or more participants) - 10%
  • All fees are inclusive of 7% GST
Funding Available

  • SDF Grant Amount: S$28.00
  • SDF Course Code: CRS-N-0045124
SkillsFuture Credit
(Individual Singaporean aged 25 and above)
Pre-approved SkillsFuture funding of S$500.00

Available Course Sessions

Please click here to stay updated on upcoming sessions.

Trainer Profile

Microsoft Certified Trainer

All of our Associate Trainers offer our high level of service therefore are subject to regular peer assessments and interview prior to joining our Institute. They must all be qualified and have relevant experience to an agreed level and are subjected to continual audit and evaluation. Strict internal assessment is implemented as an integral part of our quality control mechanism.