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

solver

ResolvedVersion 2007

Sunita has attended:
Excel Advanced course

Solver

need more understanding on solver especisally solversam

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

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

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.