Excel tips: Using dynamic arrays to transform your Excel experience
Simon Hurst explains how to take your Excel expertise to a whole new level with the gradual introduction of dynamic array functions.
Office software
Resources to help you make the most out of Office software.
In this section
Excel tips the thrill of the drill down and up buttons
Simon Hurst explains how PivotTables can drive management reporting and the creation of interactive dashboards.
Keeping up with new features in Excel
Simon Hurst explains how you can avoid the Fear Of Missing Out when it comes to new features in Excel through the ICAEW Excel Community.
Microsoft Outlook and email
Top template tips part 5
Simon Hurst shows us how to increase efficiency and productivity by getting to grips with the template feature in Microsoft Outlook.
Using Outlook effectively: 3 – emails
Outlook isn’t just an email engine. It includes tools that help you organise, prioritise and delegate work.
Using Outlook effectively: 2 – tasks
Most accountants use Outlook for emails but often overlook the tasks feature. Making the most of tasks saves time, repetition and the fear of forgetting something.
Using Outlook: 1 – the calendar
Most accountants use Outlook for most of their appointments but few know how powerful the calendar function really is. This first in a series of three articles on using Outlook (2007) effectively focuses on how to make use of this function.
Data presentation
Power BI Desktop - Part two
Simon Hurst continues his guide to data display with some tips on how to keep up to date with changes and enhancements to customise your content.
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.
Microsoft Word
Automating Word documents with content controls
Inspired by a couple of recent consultancy assignments, this month we are making one of rare forays beyond the confines of Excel and out into the wild frontier of Microsoft Word.
Get Smart
Simon Hurst guides us through SmartArt for business diagrams
Beyond the basics: Template for success part 3
Simon Hurst looks at setting up and getting the most out of templates beyond Excel, in Microsoft Word.
Custom Lego - making the most of Building Blocks
Although you are most likely to come across ‘Building Blocks’ in Word, the principles covered also apply to the other Office applications.