Home · Course Details

Learn how to write and edit simple formulas in Excel to calculate results. You will learn how to write formulas that add totals and calculate averages and how to use built-in formulas called Functions.

  • Duration: 90 minutes
  • Category: Excel
  • Platform: Adobe Connect
  • Level: Beginner
  • Pre-requisites: Basic familiarity with Windows applications
  • Version: Suitable for 2010, 2013, 2016 and Office 365

  • Understand formulas
  • Create a simple formula to add numbers
  • Use formulas to perform common calculated results
  • Understand cell referencing in formulas
  • Use simple Functions – Excel’s built-in formulas
  • Use formulas that link worksheets and workbooks

Topics covered include:
  • Formulas
  • Copy formulas with AutoFill
  • Functions in Excel
  • SUM Function
  • AutoSum
  • AVERAGE Function
  • MAX Function
  • Absolute cell references
  • Creating formulas that reference cells in other worksheets
  • Linking workbooks

No pre/post work required

Name Date Time Location Cost
Virtual Class - Excel: Formulas for everyday calculations 7 March 2019 09:30 am - 11:00 am Online $99
Virtual Class - Excel: Formulas for everyday calculations 20 May 2019 09:30 am - 11:00 am Online $99

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.