test question

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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?

resolvedResolved · Low Priority · Version 2007

Edited on Thu 15 May 2008, 14:53

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.

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:

Use Paint Brush to Format More than one Cell

To copy a format to many cells or ranges

1. Select the cell with the format that you want to copy

2. Double-click on the paint brush

When you move to the cell where you want to paste the format you will notice that a paint brush follows the cursor.

Paste the format to all the cells or ranges you need to format.

When finished go back to the paint brush on the tool bar and single click on it to deactivate the function.

View all Excel hints and tips


Server loaded in 0.09 secs.