This course is conducted in PC/Windows operating system. There will be no laptop provided. Learners are required to bring along their own laptops.

2-Day Excel Real World Essential -
Bridging To The Next Level Course
In Singapore (Exclusive)

Fast track your Excel learning journey from basic to intermediate and learn important features and functions you need to do more in less time.

Register Now

All our courses are not subsidised and non-claimable using SkillsFuture credit

Excel Real World Essential - Bridging To The Next Level Course Overview

This course is developed jointly by Ms Ow Yeong Yin Leng and Mr Alaster Leong and this course is exclusively train by Ms Ow Yeong Yin Leng. Learn from the original co-creator of this course.
 
Do more in less time! This course allows you to take a step of others by shortening your traditional Excel learning journey from basic-intermediate Excel to just 2 days!
 
You may have been using Excel for some time but typically less than 30% of its features. These days, businesses are increasingly dependent on data intelligence, so employees are expected to be more proficient with Microsoft Excel. Manually performing tasks consumes too much time and effort, so using Excel formulas instead of manual actions reduce human error in reports. 
 

The reason you may find Excel overwhelming is that there seems to be a lot to know. This may be true, but one still needs to know the essentials and a few advanced skills to utilize and optimize Excel for your daily tasks or to remain employable, or to confidently operate this indispensable software in workplaces worldwide, or to speed up your workflow.

Whether you are self-taught and want to learn more Excel functions to improve efficiency and productivity, or a basic Excel user, our Excel Real World Essential course conducted in Singapore will teach you the most important Excel features and functions for the real-world, building the knowledge and skills you need to become a confident user to apply what you learn immediately in your workplace.

This essential Excel course will also elevate your skills to intermediate Excel level, and help you bridge the skills gap to some of the advanced courses ALS offers below:

Those who are interested to attend our advanced courses but would like a refresher on Excel features and functions are also welcomed to attend this course.

Throughout this course, you will be provided with practical, real-world examples. These examples will help you grasp the full potential of each feature, allowing you to apply the skills you have acquired both in your current or new job with confidence.

This Microsoft Excel Real World Essential course will give you the hands-on experience you need to apply the best solution for the task at hand. That way, you can do more in less time.

At the end of the course, learners will be able to:

    • build a proper data structure.
    • apply the most important Excel features in the real-world.
    • work with Excel efficiently and confidently, resulting in time savings and increased productivity at work.
  • Working professionals who want to become more confident in Excel
  • Anyone who want to learn how to build a proper data structure for future reporting and data analysis
  • Beginners with some basic Excel knowledge wanted to learn more on Excel features and functions they would use in the real world
  • Anyone who wants to ensure they have the necessary Excel skills they need to be successful in their careers

This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.

  • Basic Excel skills
  • Software Requirement: Microsoft Excel version 2010 and above or Office 365 installed
  • PC/Windows operating system laptop with Microsoft Excel version 2010 and above or Office 365 installed (personal laptop is preferred as some company laptops may have security restriction)
  • Laptop power adaptor
  • USB mouse

Course Outline

  • TODAY, NOW
  • SUM, AVERAGE
  • COUNT, COUNTA, COUNTBLANK
  • MAX, MIN
  • IF
  • Nested IF
  • OR, AND
  • VLOOKUP, HLOOKUP
  • DAY, MONTH, YEAR
  • DATEDIF
  • UPPER, LOWER, PROPER
  • LEFT, MID, RIGHT
  • COUNTIF, SUMIF, AVERAGEIF (optional)

Our Dedicated Trainer

Learn from the original co-creator of this course.

Graduated with a degree in Computer Science with Management and a former programmer, Yin Leng has been conducting IT training for the public and private sectors since 1995.

Yin Leng is not only a Microsoft Certified Trainer since 2009 and an approved trainer by the People’s Association (PA), she was also an Associate Trainer at Civil Service College. Her experience with and knowledge of IT software speak for themselves.

Additionally, she is well-liked for being amicable and approachable. Her passion for training drives her to impart knowledge, sharing her expertise in computer programming and application software with her learners.

Her patient approach to teaching has garnered praises from a variety of learners, ranging from children, adults, disabled, special needs, the general public and even staff of the Grassroot Leader Profile System.

Course Registration

This course is not subsidised and non claimable using SkillsFuture credit.

Organisations with more than 2 learners, click here to download registration form.

All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, which are intended to foster a learner’s success in the course. Be sure to check the necessary pre-requisites before registering.

This course is not subsidised and non claimable using SkillsFuture credit.

Leave this field blank

To learn more, be sure to read our Terms and Conditions and Privacy Policy.

To learn more, be sure to read our Terms and Conditions and Privacy Policy.

Course Information

Course Code:

ALSIT-ERW

No laptop will be provided. Bring Your Own Laptop Course.

Course Fee:

S$780.00 (Nett)

Call us for a group rebate when you register in a group of 8 or more.

Absentees will be charged the full course fee.

Course Dates:

  • 10 - 11 Jul 2023
  • 21 - 22 Aug 2023
  • 14 - 15 Nov 2023

2 days, 9:00am – 5:00pm
(14 hrs, exclude lunch break)

A closed class can be requested if you have a group of at least 6 or more registered for the same course and date at a preferred date, subject to trainer availability.

Closed class is not customised class.

Download 2023 Training Calendar

Training Venue:

To be confirmed one (1) week prior to the course start date.

Registration:

For Company-Sponsored Learners: Click here to download registration form.

For Self-Sponsored Learners:
Click here to download registration form.

You can also register online here.

Note:

ALS reserves the right to reschedule, postpone or cancel any course, change the trainer and venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control.