You are not currently logged in
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).

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 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