ICAEW.com works better with JavaScript enabled.

Data analysis

Do you have trouble keeping up-to-date with the latest changes in Excel or not had time to attend formal training courses?

Join the Excel Community

For full access to all Excel materials.

Join online now
This section of the website provides advice and guidance to help you improve data analysis in Excel, covering topics such as mathematical functions, summarising data, pivot tables, formulae auditing, what-if analysis and business modelling.

If you cannot access the items, then join the Excel Community for full access to all Excel materials.

Remember to login to access premium content here and on the Excel Community news and forum site.


Consolidated accounts

Expanding on his article in the last edition of Chartech, Simon Hurst looks at using the Power Query Tool in detail

Sorting nominal codes automatically

A common criticism of Excel training and learning resources is that they teach the technical details of how Excel functions work without considering how they might be used in practice.

Power Query v Excel formulae

It’s always useful to be able to base an article on a practical issue, so thanks to Chris Scanlon for providing the inspiration in this case.

Reasons to update to Excel 2016 Part 1

Back in the 1990s Excel included a built in mapping feature called Microsoft Map. From the Excel 2000 version Microsoft Map was removed from Excel and replaced by a separate, chargeable Add-in called MapPoint.

Power Query – unpivot

Power Query could end up being the most significant of the many data analysis/BI features that Microsoft has been pouring into Excel recently.

Filling in blank cells in a set of data

Clever as many of the data analysis features in Excel now are, if your underlying data isn’t properly structured, it can be very difficult to make best use of many of those features.

All MOD () cons

Simon Hurst looks at one of the functions that may be more useful than you think.

PivotTables: tips and techniques

Large volumes of data can be intimidating and time-consuming to summarise. In this first instalment, Simon Hurst explains how this important Excel feature can help you turn numbers into decisions PivotTables are an increasingly important part of Excel.

Excel 2013 - Power View

Power View, along with PowerPivot and Inquire, is one of the Excel 2013 features that Microsoft has decided to limit to those that have the Professional Plus edition of Excel or Office. If you do have the right edition, you should see Power View in the Reports group of the Insert ribbon.

Showing 10 of 16 items