Excel Formulas and Functions

Due to Coronavirus situation, as of April 1st 2020 this course will be delivered in virtual classroom via Video conferencing.

About the course

Need to know more about formulas and functions in excel? Learn logical, mathematical, simple nested functions and statistical functions plus understand comparison, division and exponentiation formulas.

Learning outcomes

When you have completed the course, your learning achievements should include -

• date functions
• logical functions (lookup, if, choose, true, false, conditions)
• mathematical functions (square root, integer, absolute value, round)
• simple nested functions
• statistical functions (standard deviation, count, maximum, minimum)
• addition
• average
• comparison
• division
• exponentiation
• multiplication
• percentage
• subtraction
• combinations of above

Delivery method and resources required

This course is currently being delivered in a virtual classroom environment via video conferencing. You will need a Windows 10 enabled computer/laptop, good internet connection, a web camera (essential as the trainer will need to see your screen) and a printer (optional). Once you have enrolled, you will receive instructions on how to join the virtual classroom.

As this course will be delivered in Microsoft Office 2016, it is expected that you have this version of office loaded on your computer. Your computer or laptop must be operational. If it has any known fault that may disrupt your learning, it is recommended that you do not enrol into this course.

Please note that this is a basic course and not Nationally Accredited and therefore, you won’t receive a Statement of Attainment. However, on successful completion of the full course, you will receive an attendance certificate. After completing this course, you may wish to enrol into the accredited programs such as Introduction to Word, Excel Introduction or Intermediate, Excel Pivot Table etc. (When available).

Further information

Should you require further information, please feel free to ring our enrolment office on 02 96872072 or email to admin@parramattacollege.com.au.

$165 Limited GST free
Excel Formulas and Functions

<p><p style="font-size: 150%; color: #008000;"><strong style>Due to Coronavirus situation, as of April 1st 2020 this course will be delivered in virtual classroom via Video conferencing.</strong style


If there isn't a class to suit you, please the waiting list.