Classroom/ Online: Yes/ No
Scheduling Date(s):
Note: Please click specific date for detailed venue and course fee etc.
Excel Advanced Formulas & Functions
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.
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
- Learn and understand how to use those functions in the following function categories:
- IFs Functions
- Information Functions
- Statistical Functions
- Math Functions
- Date Functions
- Text Functions
- Lookup and Reference Functions
- Database Functions
- Learn how to mix and match functions
- Learn how to solve real-life problem using functions
- Learn how to automate your work using functions
- Learn how to analyze problems and derive solutions
- Strengthen your Excel skills with formulas and functions
- Increase productivity by automating your work
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)
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
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.
Testimonials
- 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 )
- 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 )
Profile of Alaster Leong
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.