The skills and knowledge acquired in Microsoft Excel 2016 - Functions are sufficient to be able to use a variety of Excel functions, including logical functions, math functions, date and time and financial functions. It is a reference manual and is designed to be used by someone already familiar with how functions are used in Excel.

At the completion of this course you should be able to:

• use logical functions to test whether a statement is true or false
• use a range of lookup and reference functions
• use maths functions to solve complex problems
• use a variety of statistical functions
• use a variety of financial functions to perform calculations
• use the date and time functions to perform calculations
• use a range of text functions
• use a range of information functions to test worksheet data