skip to navigation skip to content
Self-taught course

Provided by: University Information Services


Booking

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
LoanNew

Self-taught course

Description

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.

Prerequisites

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 COLUMN And COLUMNS
  • Using ADDRESS
  • Using INDIRECT
  • Using OFFSET

Maths Functions

  • Understanding Maths Functions
  • Using SQRT
  • Using ABS
  • Using INT
  • Using TRUNC
  • Using ROUND
  • Using ROUNDDOWN And ROUNDUP
  • Using ODD And EVEN
  • Using CEILING.MATH
  • Using MROUND
  • Using PRODUCT
  • Using SUMIF
  • Using SUMIFS
  • Using SUMPRODUCT

Statistical Functions

  • Understanding Statistical Functions
  • Status Bar Statistics
  • Using COUNT And COUNTA
  • Using COUNTBLANK
  • 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
Objectives

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
Format

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

Duration

Approximately 20 hours

Related courses
Theme
Spreadsheets

Booking / availability