ICAEW.com works better with JavaScript enabled.
Exclusive

Design and format

Creating a good landing page

Author: David Lyford-Tilly

Published: 03 Feb 2023

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.

In this article, we consider how to create a good landing page with an ‘About’ or ‘Welcome’ sheet to document the spreadsheet.

This article was originally published in 2016 as Excel Tip of the Week #128.

It has been edited to reference latest Excel developments.

What's the need for an About sheet?

Landing in a larger Excel workbook for the first time can be pretty disorienting. There can be many sheets, lots of data, and documentation / explanation is often lacking. Furthermore, certain information - like the version history or the spreadsheet's creator - is often omitted altogether. Having a standardised process for including this kind of data can go a long way towards making it easier for future users of your spreadsheets to get on with things. Even if you aren't expecting others to use it, a good About sheet can be a lifesaver if you have to pick up a long-dormant project of your own.

What should be included in an About sheet?

The exact contents will vary depending on your organisation's size, the spreadsheet's size and purpose, and who the spreadsheet will be distributed to. Below is a shopping list of different inclusions, roughly ranked in order of how likely to be needed they are.

Spreadsheet's name, purpose, and version number

This is the absolute essentials - and should always be included. As well as a version number, you may wish to include a version history - i.e. a list of the major changes from version to version - to help people identify what version they need to use.

Creator's details

This might be the organisation, or the specific creator, including contact details. This gives future users a possibility of contacting you to ask questions about your work.

Workbook contents index

Consider including a list of all the worksheets within the workbook, with a brief explanation of the purpose of each and how it is connected to other sheets. You can use hyperlinks to link the index into a clickable map that will take the user directly to the sheet they are interested in. More information on how to create a hyperlinked table of contents using VBA is covered in tip #263, while friend of the community David Benaim has produced a video showing how new Excel functionality can be used to build a dynamic table of contents in Excel with formulas.

Summary of error checks

If the workbook is of any significant size and/or complexity, it should contain error checks throughout. A summary of these should be clearly shown on the landing page - either showing the error status tab-by-tab, or if appropriate just a whole-of-workbook summary.

Instructions about use

If there are any particular instructions the user should know, list them. For example - how can they add new data? How can they update any charts or PivotTables within the workbook? Where can they see the options for any dropdown menus? Is there any part of the workbook they should not change or move?

Key to formats

If consistent formatting for different types of cells (e.g. inputs, calculations, outputs) is used, consider including a key explaining which is which.

Scope / assumptions

If the workbook is a model of some kind, then the landing page is a good place to list any key assumptions or limitations in scope that might be relevant - you don't want the user to falsely assume that the model is relevant to their scenario if it might not be.

Other information

There are plenty of other things that you might want to put on your landing page! A landing page is one of the Twenty principles for good spreadsheet practice and should be kept in mind when considering good design and format.

Archive and Knowledge Base

This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.

Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250