25|EXCEL – Tax Prep Startup

[Scott_Cherry]

Challenge25_Tax_Prep_Data.xlsx (6.7 MB)

Here is the link to my solution. Had to teach myself the xlookup function real quick, similar to the v and h lookup functions, but fun nonetheless to learn another for my excel toolkit. Using the map feature for the first time was interesting as well. Had a good time completing this quick challenge, thank you!

[Charlotte_Chen]

Here is my solution, I didn’t know Excel had a map chart before, and it’s been a long time since I used Excel. Good exercise!

[Masahiro_Hokazono]

This was a good practice. I didn’t know about the Unique function and Map feature, so it was a great learning experience.

[Chase_Halverson]

I really enjoyed this challenge. I hadn’t used the mapping tool in excel before and it was great to learn about.
Challenge25_Tax_Prep_Data.xlsx (6.8 MB)

[britbraatz]

Time to complete: 15 minutes
Level of Difficulty: Beginner
This was a quick fun challenge and one I could definitely see myself using.
Challenge25_Tax_Prep_Data.xlsx (459.5 KB)

[jason_ng]

It took me 20 minutes to complete. For me this is a medium difficulty.

[Juliette_Sorensen]

Time: 20 minutes
I thought it was easy. I liked making a map! I had never done that before!
The formulas were pretty simple and then I used a pivot table to choose what information I wanted.

[Brayden_Cook]

[Kassidy_Robinson]

This was a fun and easy reminder of some Excel functions. I also got to know that Excel had a mapping function which was interesting. My map didn’t appear to have great accuracy, but that is interesting and something to look further into!

Here’s my solution:
Challenge25_Tax_Prep_Data.xlsx (1.3 MB)

[LaRee_Cameron]

This was good, I haven’t worked much with Excel to be honest and so I learned a lot of new things as I figured it out, it brought back some things I had learned in a high school accounting class.
Time to complete: 30min
Challenge25_Tax_Prep_Data.xlsx (13.3 KB)

[Braxton_Mearian]

Time: 7 Minutes
Rating: Not difficult

This was a great challenge. Thanks!

Challenge25_Tax_Prep_Data.xlsx (7.1 MB)

[Xiaofang_Zhang]

Challenge25_Tax_Prep_Data.xlsx (2.4 MB)

[Caleb_Spiers]

This was an awesome challenge, albeit short!

[alexalleweireldt]

Time to complete: 15 minutes
Rating: Beginner

Good challenge to help relearn some of the oft-used formulas as well as make a map (which was something new and fun!).

[Caden_Vance]

Time to complete: 10 minutes
Rating: Beginner
Comments: Quick and easy! Nice to learn how to use the map function, even if my version of excel won’t let me isolate only the regions with data.
Solution:

[Spencer_McArthur]

TTC: 20
Ranking: Intermediate
Challenge25_Tax_Prep_Data.xlsx (14.9 KB)

[Nate_Hansen]

Time to complete: 10 Min
Difficulty: Beginner
Solution:
Challenge25_Tax_Prep_Data.xlsx (97.1 KB)

[Harrison_Briggs]

Great functionality I didn’t know Excel had. Thank you for the challenge.

[Mark_Whisenant]

Time to complete: 5 minutes
Difficulty: easy
Solution:

[Kevin_Guo]

Time spent: 10 min

Powerful tool to visualized region related data, not good as Tableau but easy to hand on.