Excel 365 Formulas

Overview

The course assumes that delegates are familiar with basic Windows operations, opening and saving files, entering and editing data in Excel 365 or an earlier version.

Delegates will learn how to be able to enter worksheet formulas using the three basic calculation tools in Excel.  Content will cover: Creating a formula; AutoSum; AutoFill; Absolute cell references; Name cells; Working with multiple sheets; and Working with dates and text.

This course will enable you to

Create a formula

• Enter a formula starting with =
• Build a formula using the operators +,-,* and /
• Understand BODMAS
• Use brackets in more complex formulas

AutoSum

• Add up rows or columns of data with AutoSum
• Edit the formula to change data being added
• Use Quick Analysis to add formulas to tables of data
• Check formula results with AutoCalculate

AutoFill

• Copy formulas to other cells by dragging
• Understand how AutoFill works

Absolute cell references

• Understand why dragging formulas might not work
• Use Absolute Cell references to fix formula problems

Name cells

• Assign a name to a cell or a range
• Use names in formulas
• Edit names

Work with multiple sheets

• Create a summary sheet using data from other worksheets
• Build a formula using data from other sheets

Work with dates and text

• Understand how Excel stores dates
• Calculate days between two dates
• Extract and combine text with Flash Fill

Who is the Course aimed at

Anyone who is familiar with basic Excel techniques, including entering and editing data, saving and printing workbooks and who now wishes to start using and editing formulas to perform calculations in the workbook.