Do you know all the ADVANCE FEATURE in Excel??? (Except VBA)
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

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

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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!


  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.

    <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;"> DALEY :P </td></table>

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com