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 4 Jun 2008, 15:51Delegate Sunita said...

Sunita has attended:
Excel Advanced course

Solver

need more understanding on solver especisally solversam

For upcoming training course dates see: Pricing & availability

replyReply Thu 5 Jun 2008, 08:24Trainer David said...

RE: Solver

Sunita

Microsoft includes an Excel file named Solvsamp.xls with every hard installation of the application. The spreadsheet goes through a complete explanation of several interrelated examples using Microsoft Excel Solver.

I suggest you look at the sample sheets in the solvsamp.xls file and choose the one most appropriate to yourself, and follow the logic trying material that may be suitable for your company.

If you have any problems locating the file please let me know and i will upload one.

regards

Best Training team

Attached files...

SOLVSAMP.XLS

 

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

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

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