Dashboard changes

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

The benefits of a dashboard

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

Analyser ses dépenses (2)

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)