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.
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
- Excel 2013: Where the productivity gains are
- Excel 2013: Up close and personal
- Excel 2010: Simon Hurst’s greatest tips
- Excel FAQs: Working with accounts data
- AccountingWEB pivot table tutorial archive
About 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.