Get daily updated exchange rates in Excel
Do you have the need to get daily updated exchange rates in Excel and you’re like me and don’t want to type […]
Managing risk as a project manager – simple Excel model
Risks can’t be avoided as a project manager, so the way to manage a project is to understand all risks involved in […]
Save to OneDrive directly from Excel, Word or PowerPoint
In Office 2010 and later (Office 2013 etc) there’s a function (which according to me is way too hidden) where you can […]
99 days to eat 3 billion apples
When Russia banned import from Polish fruits and vegetables from Poland, citing a breach of food safety standards 1 about 3 billion […]
Project followup with Gantt charts in excel
Gantt charts are great for getting an overview of projects (or even processes with multiple tasks that needs to be executed in […]
Actual outcome versus budget in charts
A nice way of comparing a budget against the actual outcome is using column charts where you see the actual outcome as […]
Display variances using waterfall charts
As a controller you’re always asked to explain variances in the monthly results against for example budget or a forecast, and a great way of doing this with a chart is creating a waterfall chart (or sometimes called stair chart).
Good ideas
All ideas that you document and consider are good ideas even if you don’t accomplish to fulfill them at the moment.