2-Day Microsoft Excel Advanced Formulas And Functions Course In Singapore

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.

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

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

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.

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 

• 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