ICAEW.com works better with JavaScript enabled.

Presentation

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 your presentation using Excel, covering topics such as cell formatting, number formatting, conditional formatting, graphs and charts, reviewing and page and print set-up.


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.

Power BI Desktop - Part one

Power BI Desktop offers new ways to visualise and present data. In part one of his guide, Simon Hurst uses Facebook posts to demonstrate some of its capabilities.

excel emojis

Although it's generally a good idea to keep reports as simple and clear as possible, the sparing use of unusual graphics can sometimes add to impact.

Keep your clients in the picture

Pictures and charts can be extremely useful in accounting to get a point across more clearly. Simon Hurst explores Excel’s graphic-based options

Tart up your chart

Most of the time there is a great deal to be said for keeping charts as simple and as clear as possible. Many chart adornments, such as using 50% more dimensions than you really need, or overenthusiastic use of different colours and fonts, can reduce how effectively your chart communicates its underlying message.

Bright sparklines

Simon Hurst looks at the various features and benefits of using Sparklines in your spreadsheets and dashboards.

Excel Chart Part 3

This is exclusive item - please log in or subscribe to view this item.

Training specialist and IT Faculty past Chair, Simon Hurst, continues his series of articles that promote the more efficient use of commonly used office software.

Number formats part 2

This is exclusive item - please log in or subscribe to view this item.

In this short series we will look at the basics of number formatting and some less obvious features and options. Part 2 considers how best to make our number formats available to all our Excel spreadsheets.