75|EXCEL – Audit Schedule Solver

[Allyson_Smith]

Challenge75_Data.xlsx (11.5 KB)

[Alexander_Jimenez]

AlexJimenez_Challenge75_Data.xlsx (11.4 KB)

[sadie.gassaway]

here’s my solution!

[Carter_Ringger]

My solution:

s

[Mckay_Abbott]

Here is my solution!
Challenge75_Solution.xlsx (14.7 KB)

[Alex_Hersam]

Challenge75_Data completed.xlsx (11.5 KB)
SUMPRODUCT is a pretty great formula.

[James_Gerstner]

Here is a screenshot of my solution. Learning about the SUMPRODUCT function was really helpful.
I added in a row for percentage of hours used, in case there was additional info that could be beneficial to the firm. With this row, I used the Format Painter (ALT+H+FP) tool for the first time, which is another cool tool!

[Warren_Goodin]

Hey here is my code !

[Brooklyn_Angle]

Here is my solution! This was a good review for using solver!

Challenge75_Data Brooklyn.xlsx (11.5 KB)

[Morgan_M_Hansen]

This was very helpful for me with my assignment. I think that you listed all the parameters in detail. I did a summary but this was helpful to see all the steps needed to fix my solver.

[Austin_Burton]

Here is my solution! Solver is fun, because you can play with it until you get the result you’re looking for. Very helpful tool for efficient decision making.

[Michelle_Semadeni]

Challenge75_Data.xlsx (14.2 KB)

It was helpful to review how to use Solver. It also reminded me how important it is to format your data in a way that these tools and programs can read. Solver could help with a lot of different problems, but only if you organize your data in the right way

[Allison_Fischer]

I liked learning about SUMPRODUCT as I haven’t used that function in awhile.
0202_Fischer_Challenge75.xlsx (14.0 KB)

[Sean_Alder]

Challenge75_Data.xlsx (11.5 KB)

[Brayden_Cook]

Challenge75_Data.xlsx (11.5 KB)

I definitely needed to review solver!

[Gabrielle_Barney]

I forgot how fun solver can be! This was a good refresher on different excel functions for me

[Zach_Gardner]

This was a great reminder of how great solver is!

[Jack_Nelson]

Great challenge for review!

[Riley_Judy]

Solver is amazing!

[Joshua_Brown]

Challenge75_Data.xlsx (14.6 KB)
This was a great reminder of how to use solver