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

Collaborating

Sharing Workbooks
Merging Workbooks

Methodologies
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

1) COMPANY SPONSORED PARTICIPANT

SDF GRANT REIMBURSEMENT (Non-WSQ)
SDF Grant Amount: S$28.00
SDF Course Code: CRS-N-0045124

2) INDIVIDUAL PARTICIPANT
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.

Send Enquiry

About the Provider