ICAEW.com works better with JavaScript enabled.

Features and articles on Excel

Read the latest articles and features on Excel.

Unable to click on an item below?

Any items below that aren't hyperlinked are only available to Tech Faculty members, Faculties Online subscribers or Digital Essentials subscribers. To access them, you'll need to log in or subscribe.

Excel Tip of the Week #413 - Flattening and unfolding data

Hello all and welcome back to the Excel Tip of the Week! This week, we have a Creator level post in which we’re looking at how to take a column of data and unfold it into a table – or to do the reverse and flatten a table into a single column. These are some common data transformation tasks but there’s no single feature or function for doing them (with one notable exception) – but both are possible with some careful work.

Excel Tip of the Week #412

This week, we’re looking at how to best manage workbooks with a large number of worksheets in them. These kinds of workbooks are particularly common in some areas of accounting and modelling, and can make life pretty tricky.

Depending on Data Validation Lists

Liam Bastick explores data validation: one of the simplest and most intuitive ways to control what end users input into an Excel spreadsheet.

Excel Tip of the Week #411

Hello all and welcome back to the Excel Tip of the Week! This week we have a General User level post in which we are taking a fresh look at the handy Flash fill data reformatting tool.

Excel Escaping from cells

Principle 5 of the ICAEW 20 Principles for Good Spreadsheet Practice states that you should: "Before starting, satisfy yourself that a spreadsheet is the appropriate tool for the job". One of the most common transgressions of this principle is the use of a spreadsheet to input and manage data that would be better stored in a database application.

New tech features for Jun Aug 21

David Benaim

Our quarterly digest of new features across Microsoft 365 & other business tech products in written, images & video format.

Excel Tip of the Week #410 - Installing VBA redux

David Lyford-Smith

Hello all and welcome back to the Excel Tip of the Week! This week, we have a Developer level post in which we are making a definitive review of how to install VBA macros and user-defined functions in your Excel – even if you don’t know any VBA yourself.

Excel Community round-up August 2021

David Lyford-Smith

Here are all the new Excel articles and webinars from the Excel Community in August 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.

Excel Tip of the Week #409 - Controls redux

Hello all and welcome back to the Excel Tip of the Week! This week, we have a Developer post in which we’re making a comprehensive review of the various controls which you can use to drive your Excel spreadsheets – from Form controls to ActiveX controls, and a few other pieces besides.

Your Tech Faculty is changing

Kirstin Gillon August 2021

The Tech Faculty is changing. 2021 is the last year that we will be collecting subs and providing an additional, paid-for service for members. From 2022 onwards, all tech content will become available to all ICAEW members.

Showing 10 of 1052 items