there you go another YTD report before summer vacation time kicks in
Récemment j'ai publié un post sur mon dernier rapport de dépense du trimestre en cumul sur 3 mois glissants. Voilà le détails sur comment je m'y prends pour
currently working on rearranging my dashboard for year-end reports. The regular day to day dashboard is ready and works well, but so far it was still tied to the underlying pivot-tables. As some of you may know, Excel version for Mac is not as advanced as the latest on PCs, so I am using old-fashioned tricks instead of … Continue reading Dashboard changes
I've talked earlier about different methods to do your own budget, clearly using a pencil and a sheet of paper and a calculator is the way to go if you are no too familiar with spreadsheets. Interestingly enough though, spreadsheets are not that new... Digging the past The first time ever you could use a … Continue reading Spreadsheets
How long before retiring, how much to save ? Two crucial questions that a bit of spreadsheet magic can help answering... Let say you start work at 25, with 35KE p/a, free of debt, and ten year later you manage to get paid 45KE p/a Your budget on average might look like this: Then we … Continue reading A few calculations
why complicate things ?
Yes I am spending more time than I should on my personnal dashboard. First off I like it. It's never been easier to get you hand on some tutorial on-line helping you with pretty much every construction steps on Excel. I also use Excel at work so it makes it easier I guess to start … Continue reading The benefits of a dashboard