Excel helps us saved huge time in tracking and strategies our investment. Some people do not use them and sometimes demeans it as manual and unprofessional. I know of many great computer companies today still use Excel in majority of their daily work. Without it will be horrific. Human kind probably will be step back 30 years in advancement.Today I learned a new trick on creating chart with multiple records on different rows just by playing around with it. This is how friendly Excel can be even for a novice.
Table 1 : Below an actual Dividends Multi-Year Tracker that feeds from my Portfolio automatically
|Table 1 : Dividends Recorded across Multiple Rows to fit into Blog|
Table 2 is Cells selection to compute Cumulative dividends from this year dividends refer. to last year final number. For most excel user, this is simple…