You are most likely using Excel to calculate numbers - e.g. to total Sales for a period of time or for a range of products sold. In order to perform this calculation you will be using a Formula or a Function. This is a foundational skill in Excel.
In this lesson, I walk you step-by-step through the process of creating and then copying a Formula to calculate Gross Profit Sales and Gross Profit Percentage for product sales.
I also demonstrate how and when to use Relative or Absolute Cell References in your Formula or Function.