Skip to content

AndreasBylund.com

The IT Controller

Toggle menu
October 25, 2014Excel

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 […]

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 […]

August 21, 2014Other

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 […]

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.

Recent Posts

  • Get daily updated exchange rates in Excel
  • Managing risk as a project manager – simple Excel model
  • Save to OneDrive directly from Excel, Word or PowerPoint
  • 99 days to eat 3 billion apples
  • Project followup with Gantt charts in excel

Recent Comments

  • Marie Sterne on Managing risk as a project manager – simple Excel model

Archives

  • October 2014
  • September 2014
  • August 2014
  • April 2013
  • March 2013

Categories

  • Controlling
  • Excel
  • Featured
  • Office 365
  • Other
  • PowerPivot
  • Project Management
  • Word

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2023 AndreasBylund.com. Proudly powered by Sydney