Now a day, many jobs require advanced Excel skills. But 95% of Excel users use a mere 5% of the program’s power! Formulas make Excel smart. Without them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. While anyone can use a simple SUM or IF formula, 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 and debug them, and how to use which formula for which occasion (and they also know few alternatives for any given formula problem).

In Excel Advanced Formulas & Functions, participants will be shown some of the most challenging formulas and functions in Excel and how to put them to their best use. The course will cover how to perform advanced searching and data retrieval with Lookup functions, creating statistic reports with criteria applied using Statistical functions, extracting required text from given string using Text functions, and many more. The course focuses on practical examples that will help users easily transit to using these formulas and functions in real-world scenarios.

Objective

Outline

Section 1: Revision of Functions

Section 2: The IFs Functions

Section 3: Information Functions

Section 4: Statistical Functions

Section 5: Math Functions

Section 6: Date Functions

Section 7: Text Functions

Section 8: Lookup and Reference Functions

Section 9: Database Functions (optional)

Who should attend

1. People who have attended the Excel Advanced course
2. People who wants to advanced their skills in Excel
3. People who wants to learn how to solve problems in Excel
4. For Excel power users

Prerequisite:
1. Must have attended Excel Advanced course or has been using Excel for the past five years continuously
2. Must know the basic of Excel formulas and functions
3. Must know how to use Excel functions like IF, OR, AND, and nested functions

Things to bring during the course:
1. A laptop (preferable your personal laptop)
2. Laptop power adaptor
3. A USB mouse
4. A USB thumb drive or hard-disk
5. Software requirement: Microsoft Excel version 2010-2016

Methodology

This is a two-days hands-on course. The trainer will walk through the topic step-by-step. You 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.

Testimonial

- Very useful formulas and functions that can be applied to daily work ( Accounting and Corporate regulatory Authority )

- Very informative and good notes that helps to cement the lesson

- Many different functions that are very useful

- Very good instructor who is very clear and teaches very well ( Ministry of Manpower )

Alaster Leong's Profile

Mr. Alaster Leong is an IT Trainer who possesses a strong passion in IT Training. He has more than 25 years of IT experience. He has been providing IT training in government, private institutions and organizations since 1992. He specializes in creative courses such as Adobe Photoshop, Adobe Dreamweaver, Adobe Flash, Adobe Acrobat, Access and Excel VBA, Microsoft Office Applications, etc. He is a certified Microsoft Office Specialist Expert (MOS) in Excel.