# 25|EXCEL – Tax Prep Startup **URL:** https://www.techhub.training/t/25-excel-tax-prep-startup/179 **Category:** Challenges **Tags:** sumif, excel, intermediate, xlookup, unique **Created:** [February 27, 2023, 10:47pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179 "2023-02-27T22:47:42Z") **Posts on this page:** 20 **Page:** 3
### Author: ![Scott\_Cherry](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@Scott\_Cherry](https://www.techhub.training/u/Scott_Cherry) #### Post date: [April 10, 2024, 2:41am UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/41 "2024-04-10T02:41:51Z")
[Challenge25\_Tax\_Prep\_Data.xlsx](https://www.techhub.training/uploads/short-url/25U4qyby0jklgSspS2RbhSOnxf9.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! ---
### Author: ![Charlotte\_Chen](https://avatars.discourse-cdn.com/v4/letter/c/f9ae1b/32.png) [@Charlotte\_Chen](https://www.techhub.training/u/Charlotte_Chen) #### Post date: [April 10, 2024, 1:11pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/42 "2024-04-10T13:11:14Z")
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! ![Screenshot (4)](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/c9d24e68cc56a62d42c1cad489a90e59de09af8c.png) ---
### Author: ![Masahiro\_Hokazono](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@Masahiro\_Hokazono](https://www.techhub.training/u/Masahiro_Hokazono) #### Post date: [April 10, 2024, 4:39pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/43 "2024-04-10T16:39:00Z")
This was a good practice. I didn’t know about the Unique function and Map feature, so it was a great learning experience. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/89d792da4596e3df0b10bea2d3a502032bc07b4a.png) ---
### Author: ![Chase\_Halverson](https://avatars.discourse-cdn.com/v4/letter/c/eb8c5e/32.png) [@Chase\_Halverson](https://www.techhub.training/u/Chase_Halverson) #### Post date: [April 11, 2024, 7:37pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/44 "2024-04-11T19:37:17Z")
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](https://www.techhub.training/uploads/short-url/kK4jaVQzPB89q21YTGCiKL6E8zG.xlsx) (6.8 MB) ---
### Author: ![britbraatz](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/britbraatz/32/3386_2.png) [@britbraatz](https://www.techhub.training/u/britbraatz) #### Post date: [April 11, 2024, 8:31pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/45 "2024-04-11T20:31:56Z")
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](https://www.techhub.training/uploads/short-url/g5ENs6XOMQYmPfqjT3tGhONSNvC.xlsx) (459.5 KB) ---
### Author: ![jason\_ng](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/jason_ng/32/7316_2.png) [@jason\_ng](https://www.techhub.training/u/jason_ng) #### Post date: [April 12, 2024, 6:00am UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/46 "2024-04-12T06:00:38Z")
It took me 20 minutes to complete. For me this is a medium difficulty. ![Screenshot (25)](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/0be22f502f853a11d4ed158260ec71d5733fa133.png) ---
### Author: ![Juliette\_Sorensen](https://avatars.discourse-cdn.com/v4/letter/j/5f9b8f/32.png) [@Juliette\_Sorensen](https://www.techhub.training/u/Juliette_Sorensen) #### Post date: [April 12, 2024, 10:36pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/47 "2024-04-12T22:36:57Z")
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. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a11c4ecbf7b525ad8c522deb327e5d07168a6f23.png) ---
### Author: ![Brayden\_Cook](https://avatars.discourse-cdn.com/v4/letter/b/c0e974/32.png) [@Brayden\_Cook](https://www.techhub.training/u/Brayden_Cook) #### Post date: [April 15, 2024, 8:21pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/48 "2024-04-15T20:21:44Z")
![Screenshot 2024-04-15 at 2.21.09 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/2/26a987aaa4af1489b994bbc5f7867caae33d0cfe.png) ---
### Author: ![Kassidy\_Robinson](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@Kassidy\_Robinson](https://www.techhub.training/u/Kassidy_Robinson) #### Post date: [April 16, 2024, 2:41am UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/49 "2024-04-16T02:41:22Z")
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](https://www.techhub.training/uploads/short-url/1XnnWhH7QgfyBOvbvVWxsM2uXdd.xlsx) (1.3 MB) ---
### Author: ![LaRee\_Cameron](https://avatars.discourse-cdn.com/v4/letter/l/ed655f/32.png) [@LaRee\_Cameron](https://www.techhub.training/u/LaRee_Cameron) #### Post date: [April 17, 2024, 3:01pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/50 "2024-04-17T15:01:42Z")
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](https://www.techhub.training/uploads/short-url/b8jhIvfPoamDGVkGB3WkzhtlGEt.xlsx) (13.3 KB) ---
### Author: ![Braxton\_Mearian](https://avatars.discourse-cdn.com/v4/letter/b/ecae2f/32.png) [@Braxton\_Mearian](https://www.techhub.training/u/Braxton_Mearian) #### Post date: [April 17, 2024, 7:20pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/51 "2024-04-17T19:20:16Z")
Time: 7 Minutes Rating: Not difficult This was a great challenge. Thanks! ![Screenshot 2024-04-17 at 1.19.42 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/08cadc22c53b3861b18967ed8bd5216e6f749026.png) [Challenge25\_Tax\_Prep\_Data.xlsx](https://www.techhub.training/uploads/short-url/3tyWBN2iNNf9aQ9fWjrIu7ZXGWt.xlsx) (7.1 MB) ---
### Author: ![Xiaofang\_Zhang](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/xiaofang_zhang/32/7258_2.png) [@Xiaofang\_Zhang](https://www.techhub.training/u/Xiaofang_Zhang) #### Post date: [January 24, 2025, 5:48am UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/52 "2025-01-24T05:48:05Z")
[Challenge25\_Tax\_Prep\_Data.xlsx](https://www.techhub.training/uploads/short-url/xuBbbI3pUrs327P6XpN8cXmMqaO.xlsx) (2.4 MB) ---
### Author: ![Caleb\_Spiers](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/caleb_spiers/32/7605_2.png) [@Caleb\_Spiers](https://www.techhub.training/u/Caleb_Spiers) #### Post date: [March 6, 2025, 2:58am UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/53 "2025-03-06T02:58:50Z")
![Screenshot 2025-03-05 195803](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/c/c4a7d54323129ee6fbca4de12b0f248f52a69ebc.png) This was an awesome challenge, albeit short! ---
### Author: ![alexalleweireldt](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/alexalleweireldt/32/7591_2.png) [@alexalleweireldt](https://www.techhub.training/u/alexalleweireldt) #### Post date: [March 6, 2025, 5:22am UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/54 "2025-03-06T05:22:26Z")
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!). ![Screenshot 2025-03-05 at 10.21.59 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/fe0fb83c6b883e988a4507df9d517437e36b6637.png) ---
### Author: ![Caden\_Vance](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/caden_vance/32/7587_2.png) [@Caden\_Vance](https://www.techhub.training/u/Caden_Vance) #### Post date: [March 6, 2025, 5:46pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/55 "2025-03-06T17:46:02Z")
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: ![Screenshot 2025-03-06 104116](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/5/5056912572459282cf0176f8b9d87f7410204692.jpeg) ---
### Author: ![Spencer\_McArthur](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/spencer_mcarthur/32/7409_2.png) [@Spencer\_McArthur](https://www.techhub.training/u/Spencer_McArthur) #### Post date: [March 8, 2025, 9:57pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/56 "2025-03-08T21:57:47Z")
TTC: 20 Ranking: Intermediate [Challenge25\_Tax\_Prep\_Data.xlsx](https://www.techhub.training/uploads/short-url/tNH69UL4m8BIgDNLoaXGnrK8pdK.xlsx) (14.9 KB) ---
### Author: ![Nate\_Hansen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/nate_hansen/32/7389_2.png) [@Nate\_Hansen](https://www.techhub.training/u/Nate_Hansen) #### Post date: [March 10, 2025, 5:45pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/57 "2025-03-10T17:45:48Z")
Time to complete: 10 Min Difficulty: Beginner Solution: [Challenge25\_Tax\_Prep\_Data.xlsx](https://www.techhub.training/uploads/short-url/aCNuM5qeXOtMA27ys8EzEnWgjHN.xlsx) (97.1 KB) ---
### Author: ![Harrison\_Briggs](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/harrison_briggs/32/7497_2.png) [@Harrison\_Briggs](https://www.techhub.training/u/Harrison_Briggs) #### Post date: [March 10, 2025, 6:03pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/58 "2025-03-10T18:03:00Z")
Great functionality I didn’t know Excel had. Thank you for the challenge. ![Screenshot 2025-03-10 120107](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a129269898a4cf48921506310e6c655844bac98d.png) ---
### Author: ![Mark\_Whisenant](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/mark_whisenant/32/7493_2.png) [@Mark\_Whisenant](https://www.techhub.training/u/Mark_Whisenant) #### Post date: [March 10, 2025, 7:17pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/59 "2025-03-10T19:17:36Z")
Time to complete: 5 minutes Difficulty: easy Solution: ![Screenshot 2025-03-10 131705](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/1d4be7a54fb1069b6c54e6ec07b6addccf03dcfe.png) ---
### Author: ![Kevin\_Guo](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/kevin_guo/32/7144_2.png) [@Kevin\_Guo](https://www.techhub.training/u/Kevin_Guo) #### Post date: [March 10, 2025, 8:16pm UTC](https://www.techhub.training/t/25-excel-tax-prep-startup/179/60 "2025-03-10T20:16:20Z")
Time spent: 10 min ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/0cfa5423a164e88ec60e5be265c0094879928219.png) Powerful tool to visualized region related data, not good as Tableau but easy to hand on. [Previous page](https://www.techhub.training/t/25-excel-tax-prep-startup/179.md?page=2) [Next page](https://www.techhub.training/t/25-excel-tax-prep-startup/179.md?page=4)