86|EXCEL – Smarty’s School Supplies

Challenge86_Data.xlsx (10.1 KB)

1 Like

This was my solution:
Challenge86_Data.xlsx (10.0 KB)

It was a good review and practice of normalization.

Here is my solution! I am not sure I did it in the most efficient way but I got all the right answers! If anyone wants to give me any suggestions on how to do it better I am open to feedback!
SierraLucasNormalizationTechhubChallenge86.xlsx (18.8 KB)

1 Like

Here is my solution
0406_Young_Challenge86_Data.xlsx (14.8 KB)

Challenge86_DataSolved.xlsx (13.7 KB)

1 Like

Challenge86_Data_KateDebenham2.xlsx (10.3 KB)

This was a great review of data normalization! Thanks!

Challenge86_Data_Solution.xlsx (10.5 KB)
Here’s my solution!

Challenge86_Data.xlsx (10.1 KB)
Here is my data. Thanks for the normalization practice!

1 Like

Here is my solution, I included all tables on one page
Pieper Nelson Challenge 86.xlsx (19.3 KB)

1 Like

Well I had to change a little bit after checking the video to verify my answers, but it was good normalization practice.
Challenge86_Data.xlsx (11.2 KB)

That is awesome! I’ll have to check this excel challenge out to review normalization!

Challenge86_Data.xlsx (12.5 KB)
Here is my solution with normalized tables!

Challenge86_Data.xlsx (18.0 KB)

I love normalizing data!

Great review of normalization and text-to-columns!
TechHub Challenge 86 Normalization.xlsx (10.5 KB)

Challenge86_Brooklyn.xlsx (10.1 KB)

Here is my solution. This was a great refresher!

Here’s my response! It was great practicing normalizing data in Excel, since most of what I’ve done has been on paper. It was great practice and a great reminder of third normal form.

D13_HW_Challenge86_Data.xlsx (11.4 KB)

This was actually a very good reminder of normalization. It also helped me practice the text-to-column technique and the Textafter and textbefore formulas.
Challenge86_Data.xlsx (14.3 KB)

1 Like

Challenge86_Data.xlsx (14.5 KB)
This was such a good refresher on old and new material in excel! Thank you!

Challenge86_Data.xlsx (10.3 KB)
Not the most elegant looking of solutions, but here’s mine.

Here’s my solution. Thanks for the practice!

Challenge86_Data.xlsx (11.4 KB)