September 22, 2014Excel, Featured, Project Management 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 […]
August 22, 2014Excel, Featured, PowerPivot, Word 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 […]
April 30, 2013Excel, Featured, Project Management 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 […]
April 19, 2013Controlling, Excel, Featured 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 […]
March 23, 2013Controlling, Excel, Featured 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).
March 23, 2013Featured, Office 365 Good ideas All ideas that you document and consider are good ideas even if you don’t accomplish to fulfill them at the moment.