Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

solver

ResolvedVersion 2003

Joseph has attended:
Excel Advanced course

Solver

When would you use this over the goal seek function

RE: Solver

Hi Joseph

Thanks for your post, sorry i have got back to you sooner

the main reason to use solver would be to do a more detailed version of the goal seek as you can change multiple cells and also constrain those cells which make it a bit more usable

Hope this helps you

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.