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.
All our courses are not subsidised and non-claimable using SkillsFuture credit
Excel Real World Essential - Bridging To The Next Level Course Overview
Course Description
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:
- Excel Pivot Table In-Depth
- Excel Advanced Formulas and Functions
- Excel 100 Tips and Techniques
- Excel Data Cleansing and Building Techniques
- Excel Power Query Series 1 – Automating Data Preparation
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.
Course Objectives
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.
Who Should Attend?
- 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
Methodology
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.
Pre-requisites
- Basic Excel skills
- Software Requirement: Microsoft Excel version 2010 and above or Office 365 installed
Things To Bring
- 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
15. Basic functions
- TODAY, NOW
- SUM, AVERAGE
- COUNT, COUNTA, COUNTBLANK
- MAX, MIN
- IF
16. Intermediate functions
- 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.
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:
- 14 - 15 Nov 2023
- 15 - 16 Jan 2024
- 11 - 12 Mar 2024
- 13 - 14 Jun 2024
- 19 - 20 Aug 2024
- 14 - 15 Nov 2024
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.
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.