Goal Seek in What-If Analysis

December 10th, 2010 | Posted by iip in Spreadsheet tips - (Comments Off)

One of my favorite tips in Microsoft Excel 2007 is goal seek. The command can be found under What-If Analysis menu in data tools of  Data tab. Generally, what-if analysis provide us several different sets of values in one or more formulas to explore all the various results. Within what-if analysis, a series of process to change the values is running, enabling us to see how those change will affect the result of formulas.

There are several command in What-if analysis: goal seeks, scenarios and data table. Both scenarios and data tables need  sets of input values to determine possible results. If we only work with one or two variable then data table command is enough.  Meanwhile, a scenario  command has multiple variables and it addresses up to 32 values.

(more…)

, , , ,

How to create backup in Excel 2007

November 23rd, 2010 | Posted by iip in Spreadsheet tips - (1 Comments)

Nowadays, backup activities is a main part in modern management applying digital instruments. From the huge computer hardware of international network, flight arrangement system to our daily life of writing and documenting. Digital information has unique characteristics which is vulnerable from physical incident causing damage as well as data loss.

But computer industry keep growing and growing addressing such challenges. Smart ideas create innovation both in protection of hardware component and development of data recovery software. Developers from most-used software, such spreadsheet application, also improve the software regularly. They update the applications with backup and recovery function to make us more comfortable.

Here a brief note on how to use backup function in Microsoft Excel 2007:

(more…)

, , , , , , ,

How to address urban lifestyle side effect

October 27th, 2010 | Posted by iip in Earth - (Comments Off)

Urban lifestyle rises along the growing economy of a metro area where crwoded by new business centre, public facilities and high transportation activities. Improper planning of city development will lead to bad infrastructure, implicating higher stress experienced by the population.

Urban lifestyle has various side effects, one them are obesity. In this style, people are lack of exercise due to work load.  There are indications that urban people are experiencing obesity, in relation with consumption of high fat food as well and neglecting or nutrition balances for their body.

Instant is one critical symbol of urban lifestyle. In metro like London or New York, people are living in narrower hours, due to their work load. For the sake of productivity, they spend their time longer sitting in their office rather than maintain their body.

(more…)

, , ,