skip to navigation skip to content
Self-taught course

Provided by: University Information Services


This course is self taught (Materials may be loaned out).

Bookings cannot be made on this course (Course is not taking bookings).

More information about UIS self-taught courses.

Booking / availability

Microsoft Excel 2016 Functions

Self-taught course


Microsoft Excel 2016 - Functions will show you how 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.

Target audience

Microsoft Excel 2016 - Functions assumes some knowledge of Excel, including an understanding of how functions are used.


It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Topics covered

Logical Functions

  • Understanding Logical Functions
  • Using IF With Text
  • Using IF With Numbers
  • Nesting IF Functions
  • Using IFERROR
  • Using TRUE And FALSE
  • Using AND
  • Using OR
  • Using NOT

Lookup Functions

  • Understanding Data Lookup Functions
  • Using CHOOSE
  • Using VLOOKUP
  • Using VLOOKUP For Exact Matches
  • Using HLOOKUP
  • Using INDEX
  • Using MATCH
  • Understanding Reference Functions
  • Using ROW And ROWS
  • Using ADDRESS
  • Using INDIRECT
  • Using OFFSET

Maths Functions

  • Understanding Maths Functions
  • Using SQRT
  • Using ABS
  • Using INT
  • Using TRUNC
  • Using ROUND
  • Using ODD And EVEN
  • Using MROUND
  • Using PRODUCT
  • Using SUMIF
  • Using SUMIFS

Statistical Functions

  • Understanding Statistical Functions
  • Status Bar Statistics
  • Using COUNT And COUNTA
  • Using COUNTIF
  • Using MODE
  • Using MEDIAN
  • Using LARGE And SMALL
  • Using STDEV
  • Using VAR

Financial Functions

  • Understanding Financial Functions
  • Using PMT
  • Using FV
  • Using NPV
  • Using PV
  • Using RATE
  • Using EFFECT
  • Using NOMINAL

Date And Time Functions

  • Understanding Date And Time Functions
  • Using NOW
  • Using HOUR And MINUTE
  • Using TODAY
  • Calculating Future Dates
  • Using DATE
  • Using Calendar Functions
  • Using WEEKDAY
  • Using WEEKNUM
  • Using WORKDAY
  • Using EOMONTH

Text Functions

  • Understanding Text Functions
  • Using The PROPER Function
  • Using The UPPER And LOWER Functions
  • Using The CONCATENATE Function
  • Using The LEFT And RIGHT Functions
  • Using The MID Function
  • Using The LEN Function
  • Using The SUBSTITUTE Function
  • Using The T Function
  • Using The TEXT Function
  • Using The VALUE Function

Information Functions

  • Understanding Information Functions
  • Using The CELL Function
  • Using The ISBLANK Function
  • Using The ISERR Function
  • Using The ISODD And ISEVEN Functions
  • Using The ISNUMBER And ISTEXT Functions
  • Using The TYPE Function

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

Watsonia workbook with 94 topics. Files for the exercises are provided on a CD or can be downloaded here


Approximately 20 hours

Related courses

Booking / availability