I ejoyed this challenge! A great way to refresh on some basic excel functions, took a little bit of playing to get the equations to work together but satisfying to finish!
Challenge1_Hello_World.xlsx (57.1 KB)
This was great - I definitely needed a refresher on a lot of these concepts!
Isom-Challenge1_Hello_World.xlsx (57.3 KB)
Challenge1_Hello_World.xlsx (67.4 KB)
Challenge1_Hello_World.xlsx (57.1 KB)
I really enjoyed this challenge as it gave me a refreshing on XLOOKUP.
Great practice!
Challenge1_Hello_Worldgj.xlsx (68.1 KB)
Fun surprise at the end!
OReilly_HelloWorld.xlsx (56.7 KB)
Challenge1_Hello_World.xlsx (56.4 KB)
This challenge was informative. I used an unorthodox approach for isolating the needed information from the text. I wrote VBA code and used blank spaces as delimiters. I assigned each word to an entry in an array. Each cell of text had its own array. I assigned variables to certain entries in the array. I then set various cells in a row to the created variables. I iterated through all of the rows.
For the user_data, name_data and name_matrix tabs I used a more straightforward approach: using the formulas that Excel already had like XLOOKUP, CONCAT and SUMIF.
It was impressive to see the formulas all come together to create a cool visual display at the end.
1 Like
Fun Challenge. Great review on text formulas. Here is my submission for Prof. Summer’s class.
Challenge1_Hello_World.xlsx (56.2 KB)
Fun challenge, great to brush up on string splitting, lookups, and conditional formatting.
I used left and right functions instead of split, but it is cool to see how different formulas can get you to the same conclusion.
Challenge1_Hello_World.xlsx (65.4 KB)
Challenge1_Hello_World.xlsx (56.8 KB)
This really helped me get back into excel and remember some keyboard shortcuts as well as learn a bunch of new formulas. Cool to see how much Excel can do!
Super interesting exercise! For some reason, my color formatting didn’t work, but I was able to get everything else!
Challenge1_Hello_World.xlsx (68.3 KB)
This was a really helpful refresher!
0306_Ashcroft_Challenge1_Hello_World.xlsx (57.0 KB)
Challenge1_Hello_World.xlsx (58.1 KB)
Very cool use of conditional formatting! It took me a second to realize I needed to sort the names and user data before it gave me the correct matrix outputs.
Great review on previous IS classes! I used all similar formulas for my answer.
Challenge1_Hello_World (1).xlsx (57.1 KB)
Challenge1_Hello_World.xlsx (56.7 KB)
Challenge1_Hello_World.xlsx (57.1 KB)
Challenge1_Hello_World (version 2).xlsx (62.7 KB)
I feel like this helped me to understand xlookups, reason for pasting values, and using absolutes.
Challenge1_Hello_World.xlsx (60.8 KB)
I learned a lot about separating data and using SUMIF & XLOOKUP.