Microsoft Excel – Functions
The skills and knowledge acquired in Microsoft Excel – Functions are sufficient to be able to use a variety of Excel functions, including logical functions, math functions, date and time and financial functions.
The training is designed to be used by someone already familiar with how functions are used in Excel.
The course topics include:
- Logical Functions
- Lookup Functions
- Maths Functions
- Statistical Functions
- Financial functions
- Date and Time Functions
- Text Functions
- Information Functions
This course is intended for current Microsoft Excel users and assumes some knowledge of Excel, including an understanding of how functions are used.
This course covers Microsoft Excel Functions, and has only one level.
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
Microsoft Excel – Functions – Online Training
Online Training – Private Courses
You can book private, customised, online training for your organisation. To do this, please click on the Book Online Training button on this page.
Online Training – Public Courses
You can attend Microsoft Excel – Functions Online Workshops, by selecting your date from the list below. You can book up to 8 trainees for these public workshops.
The Microsoft Excel – Functions Online Training Workshops are presented by a CTO Facilitator, in a live virtual classroom.
|Name||Date||Time||Location||Cost (inc GST)|
|Microsoft Excel - Functions||28/04/2020||9:30am - 4:30pm||Online Training||$367.00||Enrol|
|Microsoft Excel - Functions||20/05/2020||9:30am - 4:30pm||Online Training||$367.00||Enrol|
|Microsoft Excel - Functions||16/06/2020||9:30am - 4:30pm||Online Training||$367.00||Enrol|
|1-3 trainees||$995||per day|
|4-8 trainees||$1,495||per day|
|Each additional trainee||$120||per day|