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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » How do I use Solver in Excel?

How do I use Solver in Excel?

ResolvedVersion 2007

Wed 14 May 2008, 15:51 Edited on Thu 15 May 2008, 14:53 Delegate Ronnie said...

Ronnie has attended:
Excel Intermediate course
Excel Advanced course

How do I use Solver in Excel?

Tell me more about solver and how it works.

Thu 15 May 2008, 14:55 Trainer Richard said...

RE: How do I use Solver in Excel?

Hello Ronnie,

Hope you enjoyed your Microsoft Excel course with BEST Training.
Thank you for your question regarding Solver.

Solver is part of a suite of commands sometimes called what-if analysis tools. With Solver, you can find an optimal value for a formula in one cell

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

How do I use Solver in Excel?

How do I use Solver in Excel?

RE: How do I use Solver in Excel?

Excel articles

Excel tip:

Make macros work in newer versions of Excel