Project 2013: Burndown charts help track work

what's new in office 2013Project 2013 comes with a brand new set of pre-designed reports and dashboards to help you better understand your data. You can visualise performance and analyse resources in ways that weren’t previously possible in Microsoft Project.

The burndown report is a much-requested feature that will be especially interesting to those of you practicing agile and Scrum-based methodology. Typically updated every day, this report is a common focal point of the daily scrum meeting.

Previously to see a burndown chart you had to employ some hacks and Excel templates to achieve the desired result. From Project 2013 it’s available as a standard report type.

Burndown charts in Project 2013

Select Report > Dashboard > Burndown

Burndown in Microsoft Project 2013

Usually the chart tracks work remaining (in time, effort points or quantity of tasks) against the date. One line represents how much work has been completed, a baseline of when to complete and the ‘perfect’ trajectory of task completion.

How is this chart useful?

Instead of tracking the amount of things done, the burndown chart reports on the amount of ‘effort’ or work left in the project phase. In other words you are ‘burning down’ the work. It will also predict based on current work rate whether the project will hit the target completion date. You’ll discover very soon whether the team is working at a fast enough rate. It’s great to get advance notice of how things are progressing and be able to adapt your project or adjust expectations sooner rather than later.

It can also be used to see whether a project team is over-performing and going to finish early. While this is usually good news this information can prove very useful in your next post-mortem. Do the team need to work on their task estimations? Or was the work completed to a less acceptable standard?

Find out more great advice like this with a Best STL course on Microsoft Project training London and UK wide.

Excel Training 2013: Sparklines through Quick Analysis

new feature for microsoft office 2013Introduced in Excel 2010, Sparklines create charts within a cell. It can help to show one figure in context with others and illustrate trends. In this example a blank column is created for the sparklines before selecting the adjacent data.

In Excel 2013 the Quick Analysis feature has now brought Sparklines to the fore. Perfect for tracking performance over time, this new way of accessing them will give a quick insight into your data.

Sparklines in Excel 2013

How to: Highlight some Excel data in a table and look for the Quick Analysis tag to float over the bottom-right corner of your selection. Put your mouse over this icon to explore the options.

For more tips and features on Excel 2013 and other versions, browse Microsoft Excel training courses from STL, available London and UK wide. With our instructor-led training, you’ll be able to manipulate your data in ways you never thought possible, helping you save time and money. Choose your preferred course ranging from beginner to advanced level.