2-Day Microsoft Excel Advanced Formulas And Functions Course In Singapore
Learn how to audit, debug and employ different Excel formulas to best use them for different problems
All our courses are not subsidised and non-claimable using SkillsFuture credit
Microsoft Excel Advanced Formulas And Functions Course Overview
Course Description
This course is created, owned, and trained by its original creator, Mr. Alaster Leong, and co-trained by Ms. Ow Yeong Yin Leng. Learn from the original creator.
As jobs globally require advanced Microsoft Excel knowledge, it is undoubtedly one of the most important skills any employee can have. Our advanced Excel formulas and functions course in Singapore does the job of prepping you well for using Excel efficiently at work.
However, 95% of Excel users use a mere 5% of the program’s power formulas in improving work efficiency. Without these formulas, Excel becomes a data keeping tool.
By using formulas, you can crunch, analyse and glean insights from the data for complex questions. Anyone can use a simple SUM or IF formula, but an advanced user would be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, VLOOKUP formulas. Apart from knowing the formulas, advanced Excel users know how to audit, debug and employ different Excel formulas for different problems. For any given problem, having a few alternative methods on hand can prove useful as well.
In the Microsoft Excel Advanced Formulas and Functions course, learners will be shown some of the most challenging formulas and functions in Excel and how to best use them. This course delves into practical examples that will help users easily transition to using these formulas and functions in real-world scenarios.
Course Objectives
At the end of the course, learners are able to:
use those functions in the following function categories:
– IFs Functions
– Information Functions
– Statistical Functions
– Math Function
– Date Functions
– Text Functions
– Lookup and Reference Functions
– Database Functions
- mix and match functions
- solve real-life problem using functions
- automate work using functions
- analyse problems and derive solutions
- strengthen Excel skills with formulas and functions
- automate tasks to increase productivity
- perform advanced searching and data retrieval with Lookup functions
- create statistic reports with criteria applied using Statistical functions
- extract required text from given string using Text functions and many more
Who Should Attend?
This course is for anyone:
- who has completed the Excel Advanced course
- who wants to advanced their skills in Excel
- who is highly interested to learn problems solving in Excel
- who is a power user in Excel
Methodology
This is a hands-on practical course. Our trainer will walk through each of the topics step-by-step. Learners will also be provided with exercise files on each topic to effectively apply what has been taught. A short Q & A session will be available after each topic.
Pre-requisites
This Excel Advanced Formulas and Functions course is suitable for those
- with an advanced working knowledge of Excel who want a greater understanding of more sophisticated formulas and functions within Excel.
- familiar with creating functions including IF, OR, AND, nested functions, VLOOKUPs and HLOOKUP
- Software Requirement: Microsoft Excel version 2010 or higher or Office 365 installed
Things To Bring
- PC/Windows operating system laptop with Microsoft Excel version 2010 or higher or Office 365 installed (personal laptop is preferred as some company laptops may have security restriction)
- Laptop power adaptor
- USB mouse
Course Outline
Our Dedicated Trainers
Having trained adult learners specialising in IT from both public and private sectors since 1986, Alaster has a wealth of experience in training. Before moving into the training sector, Alaster worked in IT for over 12 years – boasting a wide range of roles held within software development. Prior to being approved by People’s Association (PA), Alaster was an Associate Trainer with the Civil Service College. He also holds Microsoft Office Specialist (MOS) certification and specialises in training Microsoft Office Applications and Adobe Photoshop.
With his vast experience and commitment to keeping abreast with emerging trends, tools and technologies within the IT and software industry, Alaster is extensively involved in developing course outlines and materials that equip learners with up-and-coming skills in demand for the future of work.
In constantly exploring innovative and effective methods of imparting knowledge, Alaster is able to engage his learners in the courses he conducts. A large part of his trainings are committed to providing practical solutions to real-life problems, especially in the Excel courses he conducts. An approachable and engaging trainer, Alaster is always willing to aid his learners in overcoming various problems using the skills acquired even after courses. Well-known and liked for his dedication, commitment and passion for training, Alaster is appreciated by his learners.
Our PowerPoint Tips and Techniques course, conducted in Singapore is created and delivered by Mr Alaster Leong with Ms Ow Yeong Yin Leng as co-trainer. His vast background gives him reliability as a trainer.
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
All our courses are not subsidised and non claimable using SkillsFuture credit.
For organisations applying with more than 2 learners, please click here to download the registration form.
All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, 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-EFF
No laptop will be provided. Bring Your Own Laptop Course.
Course Fee:
S$755.00 (Nett)
Inclusive of lunch and 02 coffee breaks with snack items.
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:
- 06 - 07 Dec 2023
- 22 - 23 Jan 2024
- 21 - 22 Mar 2024
- 20 - 21 May 2024
- 22 - 23 Jul 2024
- 23 - 24 Sep 2024
- 25 - 26 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 at a preferred month, 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.
More Original Courses Developed & Trained By Alaster
Data Analysis Using Dynamic And Interactive Excel Dashboard Course
Data Analysis With Excel Power Query, Data Model And Power Pivot Course
Design And Build Digital Word Fill-In Form And Auto Export Collected Data to Excel Course
Excel 100 Tips And Techniques Course (Exclusive)
Excel 365 Dynamic Arrays Series 1 – Power Functions (Exclusive)
Excel Automation With VBA Series 1 – Fundamentals Course
Excel Data Cleansing And Building Techniques Course
Excel Pivot Table In-Depth Course
Excel Power Query – Automating Data Preparation (Exclusive)
Power BI Desktop Series 1 – Data Model, DAX And Dashboard Visualization Course (Exclusive)
Power BI Desktop Series 2 – Advanced DAX Formulas Course (Exclusive)