-
Licence Bundles
- Office 365 (2017) Licences
- Office 365 (2014) Licences
- Office 2016 Licences
- Office 2013 Licences
- Office 2010 Licences
- Windows Licences
- Creative Cloud Licences
- Creative Cloud (2018) Licences
- Creative Suite 6 Licences
- Creative Suite 5 Licences
- Creative Suite 4 Licences
- MYOB Licences
- Business Services Licences
- Information Technology Licences
- Microsoft Office 365 (2017)
- Microsoft Office 365 (2014)
- Microsoft Office 2016
- Microsoft Office 2013
- Microsoft Office 2010
- Microsoft Windows
- Adobe Creative Cloud (2018)
- Adobe Creative Cloud
- Adobe Creative Suite 6
- MYOB
- QuickBooks
- Digital Skills
- ICT Training Package
- BSB Training Package
- Medical
- Programming
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.
Download student files
Download working files to go with this course. Read the installation instructions for opening these files.