Formulas – Arithmetic Operations

DESCRIPTION: The power of Excel comes from its ability to carry out complex equations and lay it out in a neat format. It can also do many calculations at once and duplicate ones you’ve already made. Once the connections between cells are established, any updates to the raw information used for your formulas will automatically update your final result. This will eventually allow you to create dynamic tables which can analyse based off changing raw data, and that’s just the beginning. In this course, you’ll learn how to get started with formulas by first telling Excel that you want to create one. We’ll then go through the different arithmetic functions available such as addition, subtraction, multiplication and division. We’ll add a little bit of complexity to this by introducing brackets and finally I’ll show you how to extend formulas using either cell copying or the fill handle.

TARGET AUDIENCE: This is for beginners who are looking to begin performing calculations. The AutoSum course is highly recommended before taking this course but is not compulsory.

DOWNLOADABLE FILES: 

DIFFICULTY: Beginner

COURSE OUTCOMES:

  • How to let Excel know you want to calculate something
  • Manual and linked formulas
  • BODMAS – Brackets of Division, Multiplication, Addition and Subtraction
  • Copying formulas for larger data sets
  • Fill handle operation for quick formula duplication

MORE SHORT COURSES