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. This article gives a 'real world' use of the VLOOKUP() function

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 2

It is already possible to add ‘Trendlines’ to some types of Excel chart to create a forecast of results based on the existing set of figures. Excel 2016 introduces some new functions for creating forecasts

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.

All MOD () cons

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

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.

Excel 2013 More power view

Last time we looked at some of the basic features of the new Power View data visualisation feature in Excel 2013. We’ll look at some of the less obvious features this time.

(DAX) Part 2

Introduction to power pivot data analysis expressions (DAX) part 2 - considering the use of the CALCULATE() DAX expression in practice.

Showing 10 of 11 items