Microsoft Excel 2016 - Functions

INF1646
978-1-925349-09-2
B&W printed

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

  View outline

View a detailed outline of the course material. You may need to install Adobe Acrobat Reader to open this file.

View Outline

  Download student files

Download working files to go with this course. Read the installation instructions for opening these files.

Download Files Zip