72|EXCEL – True Blue Investing

[zullo13]

I like this

[Reece_Clark]

Nice work on this, this looks super cool.

[Zach_Dullum]

Finding a solution to this problem required me to use a fair amount of the XLOOKUP function, the COUNTIFS function, and references to a separate worksheet. It was also a great practice with implementing graphs in Excel.

[Zach_Dullum]

I definitely agree, XLOOKUP is amazing! It seems like all of the problems I’ve chosen on TechHub were solved using XLOOKUP. Before the semester, I didn’t have much experience, but I feel like I have a good grasp of it after all these repetitions.

[Jaxon_Floyd]

Here is what I got for my solution. I still need to figure out how to customize the chart design/format.

[Tyler_Keller]

Attached is a snip of my solution to this challenge. I really liked how I got to practice different functions that I learned for the first midterm.

[Tyler_Keller]

I think its cool that you used different bucket groupings than the tutorial video since it presents the same data in a way that looks different!

[Garrett_Jones]

Nice to practice with lookups!

[Jack_McFarland]

I am learning just how useful XLOOKUPS and other functions can be!

[Andrew_Bedell]

Here is my solution uploaded as a PNG because the Excel file appears to be too big:

[Alex_Horton]

here is my solution

[Melissa_Mantz]

Thanks for the challenge! I found it very easy, but I’ve never used the search mode on Xlookup to grab data selectively like that.

[EllisNyman]

It wouldn’t let me upload the file so here is a screenshot of it. It was great to refresh my memory on XLOOKUP. Great challenge overall!

[Andrew_Yelton]

[Jacob_Muller]

Took me about 45 minutes and made me realize I am at more of a beginner level than I thought.

[jacksonbutler10]

Time to complete: 45 minutes
Rating: Beginner-Intermediate
I really enjoyed this challenge. It was great practice with XLOOKUP but I struggled a bit with making the histogram look as it should. It gave me some needed experience with data visualization in excel.