When you work with digits, it's crucial how you round them. It doesn't depend on what exactly you
are rounding - decimals, thousands, or millions. You can see very different amounts after summing
the figures, rounded in different ways:
For the analysis of the investment portfolio, it is helpful to see the unrealized gain or loss.
These amounts show how many you will receive or lose if you realize all available stocks right now.
Sure, there are some fees for the operations that can decrease gain or increase loss, but, at least,
you want to see the least approximate amounts:
Many financial and non-financial companies like Yahoo provide investment portfolio tracking services
but do not offer the ability to change the appearance of the charts. Microsoft Excel gives you full
flexibility by providing different types of customizable charts. E.g., there are a few variations of
the Area chart for tracking the value and costs of your portfolio.
One of the essential parts of any work with data is presenting results. You can use many different
charts, diagrams in Microsoft Excel or PowerPoint.
A Gantt chart is one of the most popular tools in project management. It illustrates project schedules
by showing activities, like tasks and events, against time.
When you work with data in Excel, you often need to add more and more new data. However, it
takes some time to update formulas, charts, tables, when you add new data. Excel proposes functions
that can help to customize your data and avoid routine updating. This tip is about creating an
automatically extended (also known as dynamically updated or just dynamic)
To calculate the age of a person, a pet, a project, or even some device, you need to compute a
number of complete years. The issue is that it doesn't seem enough to calculate a year's difference.
Excel proposes a very useful formula that can help you to calculate that very fast.
Sometimes it is necessary to calculate a lifetime for some devices, things. Usually, a lifetime
calculates in full months, for example, to check a warranty or guaranty period. Excel proposes
a very useful formula that can help calculate that time.
For some projects or tasks, you might need to calculate how many days, months, or years left to
some date or how many days, months, or years passed from some date till today. Excel proposes a very
useful formula that can help you to calculate that very fast.