Time: 30 min
Moderately easy difficulty
Time To Complete: 1 hour for both parts
Difficulty: Intermediate
I enjoyed the first part and learned some new tools for changing text to columns.
Continuing the discussion from 164|EXCEL – Keyboard Shortcuts:
Time to complete: 40 mins
Rating: Intermediate
I had some difficulties with the solver but I was able to get it figured out.
75 minutes.
Much more difficult than I imagined but fun. I did have to use my mouse quite a few times to look up how not to use my mouse. Generative AI was very handy.
Time to Complete: 45 mins
Difficulty: Medium
Definitely need to practice this more to improve my efficiency.
Time to complete: 30 minutes
Difficulty: Beginner
Great job Ben! This is a great challenge for beginners in Excel to learn shortcuts.
Time to Complete: 1 Hour
Difficulty: Intermediate
Solution:
Challenge164_Data2.xlsx (107.5 KB)
Time to complete: roughly 30 minutes
(I didn’t bother with the tracker but held myself accountable and used my keyboard as much as possible, leading to learning a few more shortcuts)
Difficulty: not too hard
Time to complete: 45
Rating: Intermediate
I enjoyed the first part, and practicing some formulas that I don’t use a lot.
| # Ordered | Sale Price | Cost to Buy | Commissions | Min demand | Max demand | |
| 540 | Base System | $500.00 | $150.00 | $175.00 | 500 | 650 |
| 280 | Plus System | $1,000.00 | $300.00 | $350.00 | 200 | 300 |
| 70 | Full System | $2,000.00 | $500.00 | $700.00 | 50 | 70 |
| Total Account Used | $200,000.00 | |||||
| Total Account Avail | $200,000.00 |
