86|EXCEL – Smarty’s School Supplies

[Mallory_Yeater]

Challenge86_Data.xlsx (9.9 KB)
Heres what I did!

[Madeeha_Hanif]

Challenge86_Data.xlsx (14.8 KB)

Great Refresher on Text to column!

[Caroline_Freeburn]

This is what I got!
Challenge86_CF.xlsx (15.4 KB)

[Erin_Zhu]

Challenge86_Data 6.28.2024.xlsx (14.2 KB)

[Logan_Fitzpatrick]

Time to complete: 35 Minutes
Rating: Beginner
This was a fun challenge! It helped me to brush up on some basic excel functions.

Challenge86_Logan_Entry.xlsx (16.2 KB)

[Avalon_Porter]

Time: 25 min
Challenge: Beginner / intermediate
I enjoyed this challenge

Challenge86_Data (2).xlsx (14.0 KB)

[Elisabeth_Ware]

Time to complete: 10 minutes
Level: Beginner

Challenge86Solution.xlsx (10.5 KB)

[Abigail_Simpson]

Time to complete 30 minutes
Difficulty beginner
Solution
Challenge86_mysolution.xlsx (15.0 KB)

[Tiana_Holt]

Time: 20 mins
Difficulty: Beginner

[Zachary_Kuta]

Time to Complete: 15 minutes
Difficulty: Beginner

[Elizabeth_Bisel]

15 minutes
easy
Challenge86_Data.xlsx (10.1 KB)

[Zachary_Miner]

Time to complete: 15 minutes
Rating: Beginner
I used text to columns to separate the values for customer and address.

[Dayton_Larson]

Challenge86_Data.xlsx (10.3 KB)

[Lindsay_Shields]

Time: 15 minutes
Difficulty: beginner

Challenge86_Data.xlsx (10.8 KB)

[Austin_Birch]

Time to solve: 15 minutes
Difficulty: Beginner
Solution:
Challenge86_Data.xlsx (10.7 KB)

[Ethan_Hanks]

@Boston

the data file and determine what the “key” should be for each table; or in other words, what can uniquely identify each row of data. There should not be any repeat values as primary keys except for the master transaction file which should reference other tables. Make sure to split up the customer first and last name into two separate columns as well as the different parts of the address.

Challenge86_Data.xlsx (11.4 KB)

[Molly_Pratt]

Time to Complete: 20-30 minutes
Beginner
Here is my solution:
Challenge86_Data.xlsx (12.3 KB)

[Colton_Grimshaw]

Time to Complete: 15 min
Difficulty: Intermediate
Solution:

[jacksonbutler10]

Time to complete: 30 minutes
Difficulty: Beginning-Intermediate
I loved this because it helped me review normalization and my ability to properly use RIGHT, LEFT, MID, TEXTBEFORE, and TEXTAFTER.
Challenge86_Data.xlsx (15.4 KB)

[Shawn_McDougal]

Time to Complete: 15 min
Difficulty: intermediate
It was fun to apply text functions to split up tables quickly as part of the normalization process in created a relational database
Challenge86_Data.xlsx (10.3 KB)