Do 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.
Risks 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.
In 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 […]
Gantt charts are great for getting an overview of projects (or even processes with multiple tasks that needs to be executed in order).
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.
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).