Excel Formulas and Functions

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 will be delivered in a face to face classroom environment led by an industry experienced trainer. The course is focused on Microsoft Office 2016 version, therefore it would be helpful for you if you have the same or recent version installed on your home computer for practice.

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.

This course has no current classes. Please the waiting list.