Excel Training – Calculate the weekly profit

Welcome to this Excel training designed to enhance your proficiency in calculating weekly profits using fundamental statistical functions. In this exercise, you will:

  • Calculate Total Weekly Profit: Use the SUM function to aggregate daily profits.
  • Compute Average Daily Profit: Understand how to use the AVERAGE function to find the central tendency of daily profits over a week.

By the end of this exercise, you will:

  • Calculate the total weekly profit by summing up daily profits.
  • Compute the average daily profit over a week.
Excel Training calculate the weekly profit

This practical exercise will solidify your understanding of these basic functions and equip you with the skills to apply them in real-world business scenarios, making data analysis more streamlined and insightful.

To start this Excel training about the way to calculate the weekly profit, click on the following button

Weekly revenue calculation

Calculate a week of ticket revenue from full-price and half-price customers: unit totals with absolute references, row totals, then SUM and AVERAGE — 10 guided steps.

The full-price reference must be locked.

1 / 10

Write in D2 the formula to calculate the full-price amount.

The $C$11 rate stays locked, the B2 reference shifts down.

2 / 10

Fill the formula down from D2 to D6 using the fill handle.

The half-price ticket rate must be locked.

3 / 10

Write in E2 the formula to calculate the half-price amount for Monday.

Same as column D: $C$12 stays locked, C2 shifts.

4 / 10

Fill the formula down from E2 to E6 using the fill handle. What formula do you get in E6?

Add up Monday's full-price and half-price totals.

5 / 10

Write in F2 the formula to calculate Monday's total revenue (full price + half price).

Both references (D2 and E2) shift down together.

6 / 10

Fill the formula down from F2 to F6 using the fill handle.

Use the SUM function to make this easier.

7 / 10

Write in B7 the formula to calculate the total number of full-price customers.

Fill to the right using the fill handle.

8 / 10

Fill the formula from B7 across to F7.

Use the AVERAGE function on the range B2:B6.

9 / 10

In B8, calculate the average number of full-price customers over the week.

Use the fill handle to fill the formula to the right.

10 / 10

Fill the formula across to cell F8.

Your score is

0%

The other courses in this module

  1. Learn how to use the SUM function in Excel
  2. Exercise: Calculate the income of the week
  3. Learn how to use the Dollars in an Excel formula
  4. Exercise to learn how to use the Dollar Sign in Excel

Excel-Tutorial.com, your training partner.

The purpose of Excel-tutorial.com is to help users master Excel through a series of tests, tutorials, and online training programs. Whether you're a beginner or an advanced user, our resources are designed to build your skills step by step.

Our certified experts have developed detailed training programs tailored to all skill levels. Our courses cover various Excel topics, from basic data processing to advanced data analysis and visualization. You'll find clear instructions, easy-to-follow lessons, and structured content that ensures steady progress.

Excel-tutorial.com stands out for its interactive teaching approach. Our lessons include exercises, real-life use cases, and engaging quizzes to solidify your understanding. This lets you apply your new skills immediately to real-world tasks, making learning both practical and impactful.

Plus, you can track your progress and test your knowledge with quizzes that provide instant feedback. Our goal is to help you gain confidence in Excel, one concept at a time. Join us at Excel-tutorial.com and start transforming your data skills today!

Most Viewed Posts