38|EXCEL – Cowabunga Surf Audit

[Zachary_Marsden]

I loved this challenge. Really helped me apply concepts from multiple classes!

[Garrett_Vail]

I loved the integration with more than just our data analytics class, it brought a real life audit scenario that combined all our class knowledge. Great exercise!

[Alan_Zhong]

I used Pivot Tables to sum up the number of boards counted in both the audit and Cowabunga’s own inventory count. I found the inventory to be understated by 3 boards and so I added it back in the adjusting entry. The problem was Cowabunga not counting any surf boards from the Sundrift, as well as not recording properly all the surf boards already sold from the Cobra, the Surf Lancer, and the BIG Sport.

[Ryan_White]

Here’s the solution that I got!

[Tyler_Coburn]

Thanks for the challenge! It was nice to brush up on the xlookup function

[Lindsay_North]

Here is my solution, thanks!!

[meganebarton]

Here’s my solution. This was a great practice!

[Matthew_Layden]

Here’s what I got!

[Peter_Warnick]

The use of xlookup and nested if statements was cool, except for all the syntax errors I made had to fix.

[Aaron_Williams]

Way to go! How did you Bring in all of the samples with their unique ID and Cowabunga counts to the first sheet?

[Kazuki_Nakano]

[Elaina_Marriott]

this was a great one!

[Jay_Davis]

Took me a little while to find my error, but good practice to review journal entries and auditing practices!!

[Ken_Wesemann]

[Jacob_Dutton]

Fun challenge, here is my solution:

[Pearce_Nally]

Challenge38_Cowabunga_Inventory.xlsx (17.3 KB)

Here is my solution!

[Nathan_Hersam]

Here is my solution!
Challenge38_Cowabunga_Inventory.xlsx (16.1 KB)

[Allison_Terhune]

Challenge38_Cowabunga_Inventory.xlsx (17.9 KB)

Here’s my solution!

[Keldon_LaRose]

What a fun activity, thanks for the assignment

[Rande_Ritz]

Good audit practice