Beyond Task List – Add a duration column

The Need

We have already seen that work is best executed using the Task folder. But just making a list of tasks with deadlines is not enough. We need more information – how much time will each task ACTUALLY REQUIRE to execute. Duration can then be used to sort / filter pending tasks and choosing the right task depending upon time available at hand.

Here is how you do it…

Continue reading

Excel – Impact Analysis – Trace Dependents

The Need

Excel workbooks are complex. Multiple persons share and handle the same file. We keep mailing them to each other. Often the person who created the file has left the organization long back. There is never any documentation available about exactly how a file works.

Due to all this, it is almost impossible to remember which value is used in which formula. When you are about to change a value or add more data to existing block, it is absolutely necessary to ensure that all the related formulas are updated. If you forget to update the formula, the results shown there will be outdated and WRONG. This can hamper decisions and can have severe side effects.

What we need is a way to find out which formulas to update when any data changes or grows. Excel has provided this facility since 25 years. Unfortunately, very few people are even aware of it – leave alone using it!

Continue reading

… Are you noticing these “cool” / “awesome” menu options?

image

Photo credit: Donald Jusa / Foter / CC BY

In today’s world of mobile phones and apps, finding options is becoming more and more difficult. These weird looking symbols have now become the default of showing menus with more options. I realized that many of us do not notice these symbols and therefore lose out on lots of nice features. Hence this article.

Continue reading