How To Create Formulas In Excel For Beginners [Simple Exercise]

To succeed as a data analyst, understanding the basic building blocks of Excel is essential. Some of these building blocks are operators, functions, and formulas. The goal of this exercise is to teach you how to create formulas in excel.

You will learn how to create and use a simple formula in excel to calculate the goal ratio of the English Premier League’s top goal scorers.

To avoid confusion, let me quickly explain the terms – operators, functions, and formulas.

  • Operators specify the type of calculation you want to perform in a formula
  • Functions are predefined formulas that perform calculations
  • Formulas are expressions that operate on values in a range of cells

For example: SUM(I13:I15)+10

  • SUM(I13:I15)+10 is a formula
  • + is an operator
  • SUM() is a function

Now that we understand these terms, let’s get right into our exercise.

Data:

English Premier League Top Goal Scorers - Wikipedia

Exercise:

How to create formulas in excel - Top English Premier League Goal Scorers - Exercise
  1. Calculate the goal Ratio of each player
  2. Calculate the Overall Average of all players

Hints:

  1. Calculate the Goal Ratio by using the division operator to divide Goals by Games
  2. Calculate the Overall Average using the AVERAGE() function
  3. Don’t forget to set your Ratio to two decimal places

Your result should look like this.

How to create formulas in excel - Top English Premier League Goal Scorers - Result

Bonus:

Get the data directly from Wikipedia. To do this:

Top English Premier League Goal Scorers - Web

Then go ahead to clean up the data and complete the exercise.

Hope you found this tutorial on how to create formulas in excel helpful.

Happy Analyzing!

Leave a Comment