Get daily updated exchange rates in Excel
Posted onDo you have the need to get daily updated exchange rates in Excel and you’re like me and don’t want to type the exchange rates manually every day? Then this is the solution for you.
Managing risk as a project manager – simple Excel model
Posted onRisks can’t be avoided as a project manager, so the way to manage a project is to understand all risks involved in your project. Wikipedia says risk management is the identification, assessment, and prioritization of risks and in ISO 31000 defines risks as the effect of uncertainty on objectives.
Save to OneDrive directly from Excel, Word or PowerPoint
Posted onIn Office 2010 and later (Office 2013 etc) there’s a function (which according to me is way too hidden) where you can save directly to your OneDrive account without having OneDrive setup on the computer you’re using. This could be very useful if you’re working with a file at the office and need to have […]
99 days to eat 3 billion apples
Posted onWhen Russia banned import from Polish fruits and vegetables from Poland, citing a breach of food safety standards 1 about 3 billion apples needs to find new consumers. On Twitter there’s a campaign asking the Polish people to eat an apple a day, and the question is: how long would it take the Polish population […]
Project followup with Gantt charts in excel
Posted on
Gantt charts are great for getting an overview of projects (or even processes with multiple tasks that needs to be executed in order).
Actual outcome versus budget in charts
Posted on
A nice way of comparing a budget against the actual outcome is using column charts where you see the actual outcome as dark bars and the “unused” budget as a more transparent bar.
Display variances using waterfall charts
Posted on
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
Posted on
All ideas that you document and consider are good ideas even if you don’t accomplish to fulfill them at the moment.