The Best Excel Courses in Singapore for Beginners and Advanced Users

Excel is a core skill for anyone who is looking for a good paying job in 2022. Learn this skill at Auston today.

Use your $500 SkillsFuture Credit Here!

Find Jobs On:

All Versions Taught Here!

We teach Excel on 2016, 2019, 365. When you are learning excel, don’t worry about versions – the skills we teach work across all versions.

Our Courses

Basic Excel

This 1-day course is for first time users and those who are not very familiar with excel. Learn with confidence.

Topics
> Introduction to Excel
> Using Excel's Interface
> Shortcut Keys
> Data Formats
> Basic Formulas
> Copy, Move, Delete
> Pasting Data

Intermediate Excel

This 2-day course is for current users who want to start using excel to a moderate level.

Topics
> Editing Cell Contents
> Formulas
> Cell References
> Logical Functions
> Formatting Worksheets
> Working with Data Ranges
> Filtering Data
> Print Layouts
> Headers and Footers
> Making Basic Charts
> Customising Excel

Advanced Excel

This is a 3-day course in some of the most complex features of Excel that will accelerate and improve your work.

Topics
> Advanced Formatting
> Custom Number Format
> Working with Tables
> Mixed Cell Referencing
> Multiple Operators
> Data Validation and Audits
> Fixing Errors
> Advanced Chart Design
> Creating Custom Lists
> Auto Filter and Advanced Filter
> Using PivotTables
> Scenarios and Goal Seek
> Intro to Macros

Advance Excel 365

This 2-day course is designed for the most advanced users who are looking for the latest features on the latest version.

Topics
> VLookup, HLookup, XLookup
> Working with PivotTables
> Absolute References
> Sorting, Filtering, AutoFills
> Wrapping, Merging, Centering
> Formating Datasets
> Text-To-Columns
> Cell modification
> Query
> Formatting Cells
> Handling Missing Data
> Conditional Formatting
> Nested functions
> Filtering by Conditions

Why Choose Us

Computers are Provided

No more lugging your laptop to class. We provide fast PCs for you to learn on.

file_type_excel

Software Is Provided

Genuine and Licensed - Learn on authentic versions of Microsoft Excel.

Convenient Locations

We're at Tiong Bahru MRT and Tampines MRT

Highly Rated Trainers

Our students love our trainers. Just read some of the compliments below.

Clients' Compliments

Rated 4.6 / 5 on Google Reviews

Rated 4.4 / 5 on MySkillsFuture Reviews

Rated 4.3 / 5 on Facebook Reviews

Our Trainers

Improve your Excel Skills With Us Today!

Complete the form so we can contact you about fee and course date information.

How to Pick an Excel Course in Singapore

learning excel course in singapore advanced excel

Interested to learn Microsoft Excel but not sure where to begin?

Look no further than this handy guide from Auston!

Our comprehensive guide to Microsoft Excel will help you choose the ideal Excel course (or set of Excel courses) for you.

Keep on reading to find out more.

What is Microsoft Excel?

If you are reading this page, it’s quite likely that you already have a little background on Microsoft Excel; so you can go ahead and skip this section. For first-timers, please read on!

Microsoft Excel is a spreadsheet software within the Microsoft Office Suite that helps you store information. Companies use this for information management on all kinds of things such as inventory, customer data, orders, invoices, and so forth.

This data can be formatted into data tables that allow you to manage your spreadsheets. You can also set filters to your data labels in order to better manage your chart data.

Need to format charts for a clearer outline?

You can customise cell styles with conditional formatting or any of the templates available!

But there are more advanced functions to Microsoft Excel than to merely present data.

Microsoft Excel can be a totally wasted instrument if you don’t know how to use it or its tools properly. It greatly aids in data analysis due to its many advanced spreadsheet functions or efficient workbook functionality. Some of the built-in tools include logical functions and formulas.

What is the difference between the Microsoft Excel versions?

Microsoft Office has several versions of Microsoft Excel currently available on the market, which are 2013, 2016, 2019 and 365.

Lots of people ask this understandable question, especially if you don’t have much experience in Excel. Here is the quick answer: Unless you are a super-advanced user, there is literally NO difference.

Many businesses, users, and student training providers like to tout that they teach the latest version. However, most users use about 5% of Excel’s functions, so the additions from the latest versions rarely impact your ability to use Microsoft Excel.

If you would like to explore a detailed analysis of the differences in software versions, please read more  at this website here.

So, what do I really need to know when using Microsoft Excel?

a man thinking

Many people think that learning Excel is a one-time event. They think that a single advanced Excel course can take them from 0 to 100 and that course completion means there’s no more knowledge to be learnt.

This is a total misconception!

Microsoft Excel has so many functions along with multiple ways to implement those functions into your spreadsheet as well. For each day that you use it, you’ll learn a new trick, shortcut or feature, further growing your arsenal and personalising the way you use the software. It’s abilities are as endless as your creativity and logic!

That said, there are reasonable levels of achievements according to each type of job scope. For example, let’s say that there are 100 skills to learn in an advanced Excel course. However, you actually end up using only 10 skills. It’s a huge investment of your time and money, only to use a small fraction of the training.

Thus, we recommend starting with basic Excel courses and working your way up once you’ve mastered the fundamentals. After all, there is no rush to become an advanced user. We typically expect our students to become advanced over 2-3 years, not 2-3 weeks!

What you really need to know about Excel is what your job requires you to do.

Here are some typical examples of job roles and their expected competency in Microsoft Excel:

Office Admin Assistant

Skill level: Basic

  • Input accounting entries and ensure the integrity of system data
  • Maintain a proper filing system to ensure files are recorded
  • Manage admin duties such as data entry, emails, preparing of simple contracts & issuing of invoices, etc

Accounts Executive

Skill level: Intermediate

  • Monthly accrual, amortization, and all other GL entries to complete monthly closing
  • Preparation of monthly analytical reports including budget vs actual spending

Business Analyst

Skill level: Advanced

Explore/Reconcile data using various open source tools and/or cloud tools to generate business insights

Procurement Executive

Skill level: Advanced

  • Manage procurement timeline, stakeholders, and communications between end-user and vendor
  • Keep track of procurement transactions and upkeep procurement system access records
  • Identification of opportunities for automation & other process improvements

What you will realize is that there are more opportunities to use basic and intermediate skills in the market than advanced tasks. As such, we have designed our Excel curriculum as follows:

Learn Microsoft Excel today!

Learning Excel can be scary and overwhelming but it doesn’t have to be.

If you’re looking to improve your skills, Auston provides Excel courses suitable for any skill requirements of your job. Better yet – our courses are also 90% subsidized by SkillsFuture Singapore.

Now choose a version:

Excel Course 2016 SkillsFuture The version of excel that was most widely installed and used across the world in 2021. This application is most likely the version that you have learned on in the past.
Office 365 training skillsfuture subsidized The popular cloud and desktop based version of Microsoft Office that allows users to easily collaborate across locations and versions.
_

if you are unsure which version to choose, pick office 365