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.
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.
Excel’s functions can boost your processing power, but all too often their use causes significant errors. Simon Hurst guides you through the pitfalls
The option buttons that appear automatically in Excel after certain actions, such as pasting cells or dragging the fill handle, have not tended to be universally popular.
One of the great challenges of getting the best out of Excel functions is knowing whether Excel has a built-in function that does what you need.
Excel's built-in functions could me the key to winning the spreadsheet battle. Simon Hurst selects those to consider adding to your arsenal.
Not everyone immediately realises how they can make practical use of a particular Excel feature.
By utilising some of the more advanced features of Excel, productivity can be increased significantly. Simon Hurst highlights how this can be achieved.
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.
Although the built-in error tools in Excel can be useful, Simon Hurst considers some of the other tools and features available.
Simon Hurst considers some ways to track down errors in Excel, starting with the built-in error-checking tools.