Category Archives: Uncategorized

Excel 2016: PivotTable and Power pivot changes

This is the sixth and final part of Simon Hurst’s series looking at the changes and new features in Excel 2016.  In the first part we looked at an overview of the changes and covered those that related to the … Continue reading

Posted in Uncategorized | Leave a comment

ICAEW addresses spreadsheet competence challenge

Following the success of their 20 Principles for Good Spreadsheet Practice initiative, the ICAEW has embarked on what is perhaps an even more ambitious project: the Spreadsheet Capability Framework. David Lyford-Smith, Technical Manager in the ICAEW’s IT Faculty, outlined the … Continue reading

Posted in Uncategorized | Leave a comment

Excel 2016: Investigate hierarchy charts

Excel 2016 has introduced some useful new chart types. In this article Simon Hurst looks at the new hierarchy charts – Treemap and Sunburst and the long-awaited Waterfall chart. Introduction This is the fourth part of our series looking at … Continue reading

Posted in Uncategorized | Leave a comment

Excel tip: Convert .xls files to .xls in two clicks

Are you still tormented by mysterious messages and strange behaviour working with older .xls files? David Ringstrom is here to help. Even though it’s almost a decade since Microsoft Excel abandoned the old .xls format, many people persist in using … Continue reading

Posted in Uncategorized | Leave a comment

Excel 2016: Explore the new chart types

Simon Hurst investigates the three new Excel 2016 charts: Histograms, Pareto charts and Box and Whisker charts, which are all in the Statistical Charts section. This is the fifth part of our series looking at the changes and new features … Continue reading

Posted in Uncategorized | Leave a comment

Excel tip: When Freeze Panes is disabled

The Freeze Panes command is useful when you need to lock certain rows or columns while scrolling the rest of the worksheet. But if an Excel glitch disables this command you could be in a situation where you can’t scroll … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Office joins the cloud add-on club

Microsoft is returning to the world of small business accounting through alliances with cloud platforms such as QuickBooks Online and Xero. The focus for this activity is Office 365, the web-friendly evolution of Microsoft’s productivity pack. But when Xero told … Continue reading

Posted in Uncategorized | Leave a comment

Excel 2016: Create instant forecasts with the new Forecast Sheet feature

Simon Hurst has a quick look at Excel’s existing forecasting capabilities before looking in detail at what the new Forecast Sheet feature, and new forecast functions, add. Introduction This is the third part of our series looking at the changes … Continue reading

Posted in Uncategorized | Leave a comment

Enable e-signatures in Excel

E-signatures have already been marked out as one of the technology trends accountants should watch out for in 2016. For those who don’t want to sign up to software, follow AccountingWEB.com’s walkthrough guide and enable e-signatures in Excel. As recently explored on AccountingWEB, … Continue reading

Posted in Uncategorized | Leave a comment

Spreadsheet users resolute in the New Year

The New Year inspires many people to pledge their goals and resolutions for the year ahead. This is no different for Diane Robinett, who wishes that the New Year will bring an end to spreadsheet shaming. Robinett, Incisive CEO, a … Continue reading

Posted in Uncategorized | Leave a comment