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
nicely getting in into december month things could shake up a bit when reaching month end if moving to new accomodation... meaning I will amend the monthly budget to reflect this so the whole next year projected budget for 2017 doesn't go South. Still hoping for a good finish and some money to play with … Continue reading Budget vs Time count
My 10 years bank statement database It's taking a while to crunch all these figures that I don't know now if this was a good idea in the first place, however, making all these analysis is quite fun, feels like diving in my past, rememebering what I actually did, where I went; ok not as … Continue reading In the making
Maintenant que nous avons un extrait de nos transactions bancaires, on va voir comment analyser rapidement les dépenses. Calcul du solde On calcule le solde de chaque opération qui permet de prendre en compte les mouvement débit et crédit dans une seule colonne: Ensuite, on insère une formule de calcul qui va permettre d'obtenir le … Continue reading Analyser ses dépenses (2)
Comment analyser ses comptes en utilisant Excel ?