19|EXCEL – Pizza Pivot Table

Challenges
, ,
41

Challenge19_Dataset_PizzaPivotTablesChallenge.xlsx (6.9 MB)

I loved learning how to better create PivotCharts. I think they are crucial to better understanding and representing large sums of data. I also thoroughly enjoyed playing around with the data to see what other trends I could find. Thanks for the challenge!

2 Likes
42

Challenge19_Dataset_PizzaPivotTablesChallenge.xlsx (6.9 MB)

I liked this challenge and the opportunity to practice using pivot tables some more. This challenge encouraged me to use the sort feature more, which helped with finding the answer to the questions in the prompt!

43

Challenge19_Dataset_PizzaPivotTablesChallenge-Alvin Gaertner.xlsx (6.9 MB)

Here is mine

44

  • What days and times is the pizza restaurant the busiest?- Wednesday at 12:25:12 PM

  • How many pizzas are they making during peak periods? 28

  • What are the best and worst selling pizzas? best:The Thai Chicken Pizza
    Worst: The Brie Carre Pizza

  • What is the average order value?

Average Order value per pizza: $25,558.13

45

This is my solution to the Pizza Pivot table

Dataset_PizzaPivotTablesChallenge Solution Ramya Ramesh.xlsx (6.9 MB)

46

Here is my solution. I found this a very helpful reminder of how to use pivot tables. They’re pretty simple once you remember how its supposed to all layout. Thank you!
Challenge19_Dataset_PizzaPivotTablesChallenge.xlsx (5.7 MB)

47

Challenge19_Dataset_PizzaPivotTablesChallenge.xlsx (6.9 MB)
Great practice with PivotTables!

48

Pizza solution!.xlsx (6.8 MB)

49
  1. 12PM M-F

Screenshot 2023-12-06 at 10.53.45 PM
Screenshot 2023-12-06 at 10.53.45 PM1090×584 129 KB

3. The Classic Deluxe Pizza was the best and The Brie Carre Pizza was the worst
4.
Average Order value per pizza: $25,558.13

I think that the pivot tables were a great way to solve these questions! I think question 4 would have been easier with a simple =average equation instead of a pivot table.

50

TechHub Challenge - SONA.xlsx (7.0 MB)
This challenge was a great refresher on pivot tables!

51

https://byu-my.sharepoint.com/:x:/r/personal/eblack03_byu_edu/Documents/Challenge19_Dataset_PizzaPivotTablesChallenge-%20Ellie.xlsx?d=w6629373d7b1a474da722c1d7130f9151&csf=1&web=1&e=EhYwd4&nav=MTVfezlENUZDODI0LUZBMUItNDM5Ny05MDBBLTlFREMyNjcxQjBCNX0

52

Here is my solution:
Excel 19 Pizza Pivot -JW.xlsx (6.9 MB)

53

Challenge19.xlsx (6.9 MB)
20 minutes

54

Challenge19_Dataset_PizzaPivotTablesChallenge_Liz_S.xlsx (6.8 MB)

This challenge was an easy but great refresher on pivot tables, and a fun way to practice my design skills! It took about 15 minutes to complete.

55

Time to Complete: 15-20 min
Rating: Beginner
Easy and Engaging
Challenge19_Dataset_PizzaPivotTablesChallenge.xlsx (6.7 MB)

56

This was a fun challenge! I enjoyed experimenting with different conditional formatting options on pivot tables. Time to Complete: 15 Minutes
Challenge19_Dataset_PizzaPivotTablesChallenge.xlsx (6.7 MB)

57

Time to complete: 15 min
Rating: Intermediate
I liked this challenge! See my solution below:
Challenge19_Dataset_PizzaPivotTablesChallenge_Faith_Bruce.xlsx (6.8 MB)

58

Excel Challenge.xlsx (6.8 MB)
Time to Complete: 10 minutes
Difficulty: Beginner

59

Time to complete: 15-20 minutes
Rating: Beginner

This challenge was a really good refresher on pivot tables. I don’t practice my pivot table skills often enough, so I really liked this challenge.

Challenge19_Dataset_PizzaPivotTablesChallenge.xlsx (6.8 MB)

60

Time to complete: 20 minutes
Difficulty: Beginner
Challenge19_Dataset_PizzaPivotTablesChallenge.xlsx (7.0 MB)

1 Like