3|EXCEL – Advisory Revenue Pivot Tables

[Ramya_Ramesh]

This challenge was so cool and very good practice to get back into using pivot tables. Here is my solution

#1 solution

#2 solution

#3 solution

#4 solution

This is the excel sheet with my solutions
Challenge3_Data - Ramya Ramesh.xlsx (144.8 KB)

[Joshua_Norton]

2.

3.

4.

[Briley-Anne_Brown]

Here are my solutions!
#1

#2

#3

#4

[Russell_Kitsis]

Challenge3_Data.xlsx (136.3 KB)

[Montana_Qualley]

Challenge3_Data.xlsx (135.9 KB)

[Lilia_Fisher]

Good introduction to pivot tables. Took about 15 minutes.
Challenge3_Data.xlsx

[Rachel_Lopez]

Time: 10 minutes
Rating: Intermediate
Comment: This was a good review of Pivot tables.

Q1:

Q2:

Q3:

Q4:

[Spencer_McArthur]

TTC: 30mins
Ranking Medium

Challenge3_Data.xlsx (146.0 KB)

[Ashleigh_Layton]

Time to complete: 30 minutes
Difficulty: Beginner
Extra Notes: Good practice for not having done pivot tables in a couple years!
Solution:

[Colter_Sill]

Time to Solve: 20 Mins
Difficulty: Beginner
Solution:
Challenge3_Data.xlsx (185.3 KB)

[Annecy_Hansen]

Time to Solve: 20 Mins
Difficulty: Beginner

Challenge3_Data_AnnecyHansen.xlsx (145.8 KB)

[Lainey_Jackson]

Time to complete: 25 Minutes
Difficulty: Beginner
Challenge3_Data (1).xlsx (143.9 KB)

[Nate_Hansen]

Time to complete: 15 min
Difficulty: Beginner
Solution:
Challenge3_Data.xlsx (147.6 KB)

[Mark_Whisenant]

Time to complete: 25 min
Difficulty: Easy
Solution:
#1:

#2:

#3:

#4:

[Joshua_Folau]

Time to complete: 35 minutes
Rating: Intermediate
Comments: The fourth pivot table was difficult to get to show the top 10 professionals because some of them have the same number of hours worked. I wished this problem specified what to do in that scenario.
Challenge3_Data.xlsx (145.4 KB)

[Brian_Chen]

Challenge3_Data.xlsx (144.9 KB)

[Spencer_Hakes]

Time to Complete: 15 Minutes
Rating: Easy
Solution:
Challenge3_Data.xlsx (145.6 KB)

[Justin_Day]

Time to complete: 20 minutes
Difficulty Level: Intermediate
Excellent practice for pivot tables!!

Challenge3_Data.xlsx (144.7 KB)

[Taylor_Dahlke]

Challenge3_Data.xlsx (149.4 KB)
this is what I got!

[Coleman_Halls]