2-Day Excel Advanced Formulas and Functions Course

Course Overview

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.

Objectives

Upon completion of the course, learners will be 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. 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.

Prerequisites

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.

Things To Bring

A 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 restrictions).
Laptop power adaptor and a USB mouse.

Course Information

Fee

SGD 755.00 (Nett)

Absentees will be charged the full course fees

Time

9:00am to 5:00pm (14 hours)

Mode

Classroom @ Hotel

(Venue may be subject to changes)

Dates

20-21 May 2024
22-23 Jul 2024
23-24 Sep 2024
25-26 Nov 2024

Closed Class

Important Note

Closed Class

Important Note

Why Learn With Us?

Course Outline

1. Revision of Functions

2. IFs Functions

3. Information Functions

4. Statistical Functions

5. Math Functions

6. Date Functions

7. Text Functions

8. Lookup and Reference Functions

9. Database Functions (Optional)

Our Dedicated Lead IT Trainer - Mr. Alaster Leong

This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.

Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.

He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.

Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.