Microsoft Excel (Advance)

Microsoft Excel (Advance)

Course Information

1 Day Course

Fee: $680 (before GST)

Course Dates:

  • 22 Jan 2026
  • 26 Feb 2026
  • 27 Mar 2026
  • 24 Apr 2026
  • 29 Jun 2026
 

Time: 9.15am – 5pm

Contact: [email protected] 

Venue: Hotel (near MRT)

Note:

  • Tea breaks and buffet lunch will be served. Car park coupons are available upon request. 
  • For 3 pax and above, 10% discount across the board

Course Introduction

Computing skills are one of the top skills employers desired in their employees. Microsoft Office suite of applications, being the most popular software in the world, are extremely useful and widely used in organisations, schools and homes. It is the most practical and productive tool for documenting and organising information, delivering presentations, as well as processing data in work environments across the globe. Microsoft Office has been designed to be user friendly, interactive and powerful, which drastically helps increase users’ productivity within the office environment.

Microsoft Office is a collection of purpose build programmes including:
1) Microsoft Excel – Creates simple to complex data/numerical spreadsheets.
2) Microsoft PowerPoint – Creates professional multimedia presentations.
3) Microsoft Word – Create text documents. 

Course Outlines

  • Nested IF, IF(And), IF(OR)
  • Using Nested IF with VLOOKUP and
    Name Range
  • Using TEXT Function including Split
    Text and FlashFill
  • Using Index Function
  • Using Match Function
  • Combine Index and Match Function
  • Creating Pivot Tables and Pivot Charts
  • Using Groups and Subtotals in Pivot Tables
  • Implementing Calculated Fields and Items in Pivot Tables
  • Using Slicers
  • Creating Basic Dashboards
  • Using Single Input Table
  • Using Two Input Table
  • Scenario Manager
  • Goal Seek
  • Introduction to Data Models
  • Normalization and Denormalization
  • Understanding a Star Schema
  • Introduction to Power Pivot
  • Calculated Columns
  • Measures
  • Using Links and Relationships
  • Creating DAX Formulas
  • Writing DAX Formulas in Power Pivot
  • Power View
  • Power Query