Do you know all the ADVANCE FEATURE in Excel??? (Except VBA)

LMF

Board Regular
Joined
Mar 16, 2002
Messages
73
I really want to use advance feature in excel for my project, but the thing is I don't get some of them, such as

solver
multiple scenarios
goal seek

can anyone show me some good example on what they do please? (in excel)

Please help me!

:)
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Goal Seek is fairly straight forward, (is the only one i know of these! haha)

lets say you have a whole bunch of data and equations. Lets say if you change the value in cell A1 the formula that carry through from this cell or the range that includes it, will also change as they recalculate based on your new value.

Now lets say you have a bunch of numeric values throughout column A. In column B you have a formula to give the participation of each figure in relation to the whole data set, eg.

...cell B2...
=A2/SUM(A:A)

so that against each figure you can see it as a percentage of the group.

Now imagine you want to change the cell A2 value so that the participation becomes exactly 35%. You go to goal seek function, and tell it to change the contents of cell A2 until the value in cell B2 is equal to 35% (or 0.35), and it will calculate the required value for you.

hope this gives you a head start, if you create an application for it where formula operate on other formula, it can be quite powerful.
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top