#Excel expenses tracker how to#
#Excel expenses tracker series#
#Excel expenses tracker download#

I ask the audience to estimate the values of the wedges or bars. I lecture regularly on creating effective graphs and often show 3D charts with the labels removed. This is a reply to the comment by Saman who said,' 3d charts work very well here and along with the numerical values can work very well in general too, there is a reason they are included in Excel, if some people find them hard to read doesn’t mean everyone else does too.' Would love to take part in the next contest. Option 6 could also do with better space utilization in my opinion, however, it’s simple and easy to read. Option 5 is just awesome, wonderfully laid out and readable. Option 4 has the same problem as Option 3 and makes it more confusing for me by adding so many colours, go easy on the colours! Option 4 could do with better summary and presentation. The presentation is simple however, there is a lot of space wastage and poor symmetry of the layout. Option 3 does not give any of the information that I would have chosen for the main sheet. Option 2 screenshot is not ideal but the template is plain and simple and with good formatting. I disagree with Naomi, 3d charts work very well here and along with the numerical values can work very well in general too, there is a reason they are included in Excel, if some people find them hard to read doesn’t mean everyone else does too. Love the presentation of the Option1, I don’t like the use of blue at the top as it makes the data a bit harder to read but the overall layout is excellent, even if I am not a big fan of dark colours in spreadsheets. I admit that I did not take the time to evaluate this so I am only voting on the presentation of the results. I admit that the vote should be based on how useful the trackers are and if they contain the information one would want to track. I'd like the labels moved away from zero on the top chart, but I consider that defect less serious than the others. Option 6 is out since I don't like stacked bar charts. Option 5 uses too many dollar signs and ignores the roughly 8% of the male population that shows would not be able to distinguish the colors on the graph. I can't vote for Option 3 since the numbers are left adjusted. Option 2 uses too many percent signs that make the numbers more difficult to read. Also, the decimal points don’t line up in the table. I think that the ability to handle multiple currencies is important, but I cannot vote for a dashboard that uses 3D pies, so that rules out Option 1.

Please share your opinions and reviews using the comments section of this post. I have included 3 comments against each entry based on my understanding of the tracker. Please note that these files are copyrighted to original authors and you cannot use them for commercial purposes. ( find out more about the exact model and specs here )

#Excel expenses tracker series#

The winner (option getting maximum votes) will get Toshiba Mini 300 Series Netbook. Tell me which one you liked most by posting a comment with the option number.

#Excel expenses tracker download#

You can download the source workbooks and play with the trackers yourself. Click on the images to see them in bigger versions. Each entry includes a small image of the tracker along with few other thumbnails.

#Excel expenses tracker how to#

How to vote?Įach of the 7 entries start with a title including authors name.

Personally I have learned several useful formula and tracker related tricks from this. Thanks everyone for participating and making this a huge learning experience for you and I. I have received 7 excellent entries in this contest, each capable of making expense tracking a breeze while providing good analytics of the expense data to understand how you spend. So I asked you to prepare a personal expense tracker as part of our 10,000 RSS Subscriber Milestone contest. Keeping track of your expenses is one of the fundamentals of living good life.