Microsoft Excel 2016 – Level 2 AdvancedIT Short Courses

Enquire MoreRegister NowCorporate Courses

DurationTwo days
Course Dates20 Jan 2020 9:00am - 21 Jan 2020 5:00pm
24 Feb 2020 9:00am - 25 Feb 2020 5:00pm
12 Mar 2020 9:00am - 13 Mar 2020 5:00pm
27 Apr 2020 9:00am - 28 Apr 2020 5:00pm
14 May 2020 9:00am - 15 May 2020 5:00pm
15 Jun 2020 9:00am - 16 Jun 2020 5:00pm
16 Jul 2020 9:00am - 17 Jul 2020 5:00pm
20 Aug 2020 9:00am - 21 Aug 2020 5:00pm
10 Sep 2020 9:00am - 11 Sep 2020 5:00pm
22 Oct 2020 9:00am - 23 Oct 2020 5:00pm
19 Nov 2020 9:00am - 20 Nov 2020 5:00pm
14 Dec 2020 9:00am - 15 Dec 2020 5:00pm

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

Click HERE for more info on SkillsFuture.

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.

Key Takeaways

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.

Who Should Attend

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.

Programme Outline

Module 1: Using Range Names

  • Assigning Names
  • Jumping to Named Ranges
  • Create Range Names from Headings

Module 2: Database/List Operations

  • Introduction to Excel Database
  • Using Tables
  • Removing Duplicates
  • Database Functions
  • Summarize Data using Subtotals
  • Grouping & Outlining Data

Module 3: Data Validation

  • Setting Data Validation
  • Displaying Input Message & Error Alert
  • Circling Invalid Data

Module 4: Data Consolidation

  • 3D Formulae: Using Multi-Dimension Worksheets & Workbooks
  • Consolidating Data

Module 5: Auditing Worksheets

  • Tracking Errors in Excel
  • Understanding Precedents & Dependencies
  • Viewing & Hiding Tracer arrows
  • Resolving Circular References<
  • Using the Watch Window
  • Evaluate Formulas

Module 6: Advanced Functions

  • Nesting of Functions
  • Lookups & Referencing
  • Combining Functions

Module 7: Data Analysis

  • What-If Analysis
  • Using Goal Seek
  • Solver
  • Using the Scenario Manager

Module 8: Pivot Tables

  • Understanding Pivot Tables
  • Building a Pivot Table
  • Pivot Table Formatting
  • Creating Pivot Charts
  • Printing a Pivot Report

Module 9: 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 to 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

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.

Contact Details

  +65 6842 6666
  mdc_enquiries@mdis.edu.sg