Microsoft Excel 2016 Functions LoanNew
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.
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.
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
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
Booking / availability