Microsoft Excel: Advanced Formulas and Functions
Microsoft Excel: Advanced Formulas and Functions 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. 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.