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.

Excel - cumulative totals

There are many situations where you might want to calculate a cumulative total in an Excel spreadsheet, from a straightforward running total for a list of bank transactions to cumulative values for use with an Excel chart that is animated over time.

When text into numbers wont go

I often get sent spreadsheets containing issues to try and sort out. Sometimes, it's the seemingly straightforward problems that can prove to be the most difficult to solve

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.

Excel challenge - allocate income to future periods

Using Power Query requires a different way of thinking about spreadsheet problems but the additional techniques it makes possible should allow Excel to cope with additional types of problem and to make existing solutions more automatic and much quicker.

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. in this article I am going to look at how knowing a bit more about copy and paste can save hours.

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.

Showing 10 of 20 items