Skip to content

AndreasBylund.com

The IT Controller

Author: andreasbylund

October 25, 2014Excel

Get daily updated exchange rates in Excel

Do you have the need to get daily updated exchange rates in […]

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

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

August 21, 2014Other

99 days to eat 3 billion apples

When Russia banned import from Polish fruits and vegetables from Poland, citing […]

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

April 19, 2013Controlling, Excel, Featured

Actual outcome versus budget in charts

A nice way of comparing a budget against the actual outcome is […]

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

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