ICAEW.com works better with JavaScript enabled.

Data handling

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

This section of the website provides advice and guidance to help you improve data handling, covering functions such as data validation, sorting and filtering, date and time, text, lookup and reference, logical and information, named ranges and macros.

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.

When text into numbers wont go

Recently someone sent me a small spreadsheet that included a column of formatted numbers. Unfortunately, the numbers weren't numeric values that had been formatted as numbers but had been entered (or more probably pasted from elsewhere) as formatted text, complete with commas and pound signs.

Sound FX

Excel’s functions can boost your processing power, but all too often their use causes significant errors. Simon Hurst guides you through the pitfalls

New Excel functions since 2013

Excel's built-in functions could me the key to winning the spreadsheet battle. Simon Hurst selects those to consider adding to your arsenal.

Spreadsheet competency

By utilising some of the more advanced features of Excel, productivity can be increased significantly. Simon Hurst highlights how this can be achieved.

Simple ways to improve efficiences in practice

It might be just the 30 years of banging my head against a particularly hard wall, but I always feel the need to emphasise that better spreadsheet skills are not only relevant to geeks, nerds, boffins and gurus, or whatever term to use for people who understand the difference between A1 and $A$1.

Finding Errors and Issues part 2

Although the built-in error tools in Excel can be useful, Simon Hurst considers some of the other tools and features available.

Finding errors and issues

Simon Hurst considers some ways to track down errors in Excel, starting with the built-in error-checking tools.

Showing 10 of 33 items