Advanced Excel Training - Do You Work For Excel Or Does Excel Work For You?

The forms have been filed. The balances paid. Refunds are being issued. Except for a few late filers, the tax season has drawn to a close. The finance and accounting industries are breathing a collective sigh of relief and reflecting on this year's experiences.

 Two of these that are covered in advanced excel training courses in rawalpindi are Goal Seek and Solver.

Consider a simple example. You sell 100 units of a product per week for $10 each, giving you weekly revenue of $1,000. You want to increase your revenue to $1,200 per week while keeping the price constant. You would put this information into your spreadsheet then use Goal Seek to vary production in order to produce the desired revenue, revealing that you need to increase production to 120 units per week.

That's a deliberately trivial example that doesn't actually require this tool, but it illustrates how Goal Seek works. An advanced excel training courses in rawalpindi would use a more involved example such as air resistance.

A moving object's acceleration is affected by air resistance which in turn is affected by velocity which in turn is affect by acceleration. The problem of how much acceleration is required to accelerate a body to a specific speed in a certain time involves more than simple division. Goal Seek would iterate through the formula, trying different acceleration values until the desired time was reached.

Let's say your company produces a popular toy in three factories. Each factory has different production and distribution costs as well as production times and capacities. Christmas is approaching and you need to know how to produce 10,000 units within the next 30 days at the lowest cost.

Once you define the problem, Solver varies all inputs to find the optimal result. This result is going to either be the minimum, as in production costs, or the maximum, which would be the goal for return on investment. Excel has a number of powerful tools for numerical analysis that can reduce complicated problems into fairly simple answers. Two of these that are covered in advanced excel training courses in rawalpindi are Goal Seek and Solver.