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

excel training in uk - solver it

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in uk - Solver - where is it?

excel training in uk - Solver - where is it?

ResolvedVersion Standard

Solver - where is it?

I cannot find the Solver utility on any of my Menus, why is this, and where can I find it?

RE: Solver - where is it?

Answer to the question;
The Solver Utility is not installed by default, it is one of the Excel Add Ins which are User Installation items, so if your Solver Utility is not visible on the Tools Menu, take a look about two thirds of the way down and you will see an option named Add-Ins, click on this and the Add-Ins dialog box will open, click against the option for Solver, when you close the dialog box and return to your Tools menu you will see the option for Solver. Note: The "What If" utilities (Goal Seeker, Solver and Scenarios) are covered on the Excel Advanced course

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

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.12 secs.