Home ·
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.
Snapshot
- 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
Learning Outcomes
- 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
Course Outline
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
Resources & Precourse Work
No pre/post work required
| Name | Date | Time | Location | Cost (inc GST) | |
| Virtual Class - Excel: Formulas for everyday calculations | 22 January 2020 | 12:00 pm - 01:30 pm | Online | $159.50 | |
| Virtual Class - Excel: Formulas for everyday calculations | 21 May 2020 | 12:00 pm - 01:30 pm | Online | $159.50 |
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.