Microsoft Excel: Advanced Formulas and Functions will cover how to perform advanced searching and data retrieval with Lookup functions, creation of statistic reports with criteria applied using Statistical functions, extraction of 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. Participants will be shown some of the most challenging formulas and functions in Excel and how to put them to their best use.
Example like how to do an enhanced searching in LookUp Functions. Complex formulas in Excel will be taught too.
At the end of this course, you should be able to:
You will be learning the following:
For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.