solver
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » SOLVER

SOLVER

resolvedResolved · Low Priority · Version 2007

replyReply Wed 17 Aug 2011, 16:55Delegate Asif said...

Asif has attended:
Excel Advanced course

SOLVER

How do install solver?

For upcoming training course dates see: Pricing & availability

replyReply Thu 18 Aug 2011, 09:39Trainer Paul said...

RE: SOLVER

1.Click the File tab, and then click Options.
2.Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3.Click Go.
4.In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
1.Tip If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
2.If you get prompted that the Solver add-in is not currently installed on your computer, click Yes to install it.
5.After you load the Solver add-in, the Solver command is available in the Analysis group on the Data tab.

Wed 24 Aug 2011: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel computer training london and other Microsoft training courses.

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard