Working with accounts data in Excel 2010 and 2013

iStock_Rawpixel Ltd_spreadsheet
Share this content

The last few Excel upgrades have enhanced the way it works with data imports and analysis. Simon Hurst shows how they can help you in the first of a series of updates to our catalogue of classic pivot table tutorials.


Changes in Excel 2010 and 2013 have the potential to transform the way we work with accounting data. The Excel 2010 PowerPivot addin and the inclusion of the PowerPivot ‘Data model’ within Excel 2013 itself should ensure that working with external data is easier, more automatic and, perhaps most importantly, more reliable. In addition, the Tables feature introduced in Excel 2007 provides similar improvements when it’s necessary to manipulate the data in some way.

Carter revisited

Nearly 6 years ago David Carter contributed a seminal article on working with accounting data in Excel entitled Create a P&L from monthly balances with a pivot table. The article was based on pre-2007 versions of Excel. To demonstrate how things have changed, we will repeat some of the steps the tutorial covered and explore how they can be improved using more recent Excel capabilities.

Register for free and log into AccountingWEB to read the full tutorial, which includes step-by-step instructions on:

  • Get Data
  • Excel 2013 Data Model
  • Excel 2010 PowerPivot
  • Get data from other sources

Further reading and tutorials


Please Login or Register to read the full article

The full article is available to registered members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

About Simon Hurst

Simon Hurst

Simon Hurst is the founder of technology training consultancy The Knowledge Base and is a past chairman of the ICAEW's IT Faculty.



Please login or register to join the discussion.

By Trev7
20th Mar 2013 19:46


Thanks (0)
20th Mar 2013 21:56



Thanks (0)