1|EXCEL – Hello World

[Xinjie_Christy_Lai]

Time to complete: 35
Difficulty: Medium-Easy
Challenge1_Hello_World.xlsx (96.2 KB)

[Margaret_Sakar]

Great challenge! Very fun, informative, and easy to retain.

Challenge1_Hello_World.xlsx (56.8 KB)

[Bergen_Rosdahl]

Fun challenge!

[Adamaris_Sanchez]

Time to complete: 30 minutes

This was a super fun challenge that helped me review XLOOKUP.

[Sam_Ferguson]

This was a great challenge! Did a good job helping me to shack the rust off my excel skills, thanks!
Challenge1_Hello_World.xlsx (53.2 KB)

[Yvonne_Yao]

Time to complete: 25 minutes
Rating: Beginner
I truly enjoyed this challenge and was fascinated with learning how to use TEXTSPLIT, XLOOKUP, and CONCAT. Mine is red, blue, and white, just in time for the fourth of July weekend!

[Keira_McGann]

Time to Complete: 32 minutes
Rating: Beginner
I really liked how the pattern was revealed at the end, and you didn’t know it until you chose a color scale. It was also nice to get some practice with XLOOKUP, and CONCAT.

[Nicholas_Rodriguez]

Time to complete: 30 minutes
Rating: Beginner
This was a great challenge! I gained experience using XLOOKUP and CONCAT functions, and utilized conditional formatting to identify trends in the data. These are great skills to have when dealing with data sets. Attached is a copy of my solution:
Challenge1_Hello_World - my solution.xlsx (57.2 KB)

[Kristian_Macris]

I really enjoyed the challenge! It was really cool to see the last step unfold!

[Vincent_Crowns]

Loved the challenge! This is such a great way to brush up on my Excel skills! XLookUp is such a useful tool and I always forget about it!

Time: 20 minutes
Rating: Beginner

[Quyen_Le]

Interesting Challenge!

[Madelyn_Boulton]

Time to complete: 45 minutes
Difficulty: Hard
Notes: I had a hard time with this for so many reasons but I finally figured it out so that was a relief.
Challenge1_Hello_World.xlsx (75.6 KB)

[Kate_Munger]

Time to complete: 1 hour
Difficulty: Hard
Challenge1_Hello_World.xlsx (57.2 KB)

[Audrey_Vengesai]

Time to complete: 1 hours
I enjoyed playing around with the formulas but had a hard time with some of them.

[Josh_Tanner]

Time to complete: 25 minutes
Difficulty: Moderate
Notes: Great Challenge! Very fun to use different necessary functions of excel

[Cash_Clark]

Great challenge!
Time to complete: 15
Difficulty: Easy

[Zachary_Miner]

Great challenge and fun surprise at the end! It took me about 30 minutes. Here are the formulas I used:
=SUMIF(Voting_Data!D:D,User_Data!B7,Voting_Data!B:B)
=XLOOKUP(D2,User_Data!B:B,User_Data!A:A)
=XLOOKUP(E2,Name_Data!B:B,Name_Data!A:A)
=G2&H2
=XLOOKUP(D$4&$C5,Voting_Data!$I$2:$I$541,Voting_Data!$F$2:$F$541)

[Sam_Jezik]

Time: 30 minutes
Difficulty: intermediate
Solution

[Thomas_Ricks]

Time 45 min
Difficulty Intermediate
Conditional formatting was not working as it should. But, got it figured out. I liked learning the different functions.

[Tate_Erickson]

Time: 35 minutes
Difficulty: Beginner
Solution