Learn to use Excel Functions for complex mathematical operations. Math functions are used for many mathematical operations including adding up totals, multiplying values and rounding numbers.
Pre-requisites: Basic familiarity with Excel formulas
Version: Suitable for 2010, 2013, 2016 and Office 365
Learning Outcomes
Understand Math Functions
Use Functions to round numbers
Use Functions to perform conditional sums
Use Functions for complex adding and multiplying
Course Outline
Topics covered include:
Using INT
Using ROUND
Using ROUNDDOWN
Using PRODUCT
Using SUMIF
Using SUMIFS
Using SUMPRODUCT
Resources & Precourse Work
No pre/post work required
Name
Date
Time
Location
Cost (inc GST)
Not quite the content you’re looking for?
Need a course you can’t find content for on our website? We have quite possibly the largest catalogue of course content in Australia! Let us know what you’re looking for and we will customise something for you.