Accessible Excel (implementation guide)

4.4. Complex tables

Complex tables (more than 2 dimensions) are divided into several simple tables.

What is meant by this?

Complex tables are tables that contain a larger number of columns and rows and may represent multiple levels of data and information. They can be used, for example, in scientific reports, financial reports or in data analysis. Complex tables often contain different types of data, including numerical, textual and graphical data.

Why is it important?

A clear breakdown of tables is essential to ensure that they are accessible to all. This is particularly important for visually impaired recipients who hear the document read aloud.

By splitting complex tables into simpler tables with clear headings and structures, the readability and comprehensibility of the document can be improved. Recipients with other impairments such as concentration problems or learning difficulties also benefit from this structure.

An example of this could be a financial report table that shows various key financial figures such as turnover, profit and loss. If this table is very extensive and contains a lot of complex information, it can be difficult to interpret for some recipients. By splitting it into several tables, for example a table for turnover, a table for profit and a table for loss, the information can be presented in a clearer and more understandable way.

How can I implement/check it?

Splitting a complex table into several simple tables in Excel is relatively simple and can be done in the following steps:

1. Identify the parts of the table that are to be split into simpler tables.
2. Select the data to be moved to a separate table.
3. Left-click and drag the mouse pointer over the relevant cells to select them.
4. Right-click on the selected cells and select "Cut" from the context menu.
5. Click on the cell in which you want to insert the data to create a new table.
6. Right-click in the selected cell and select "Paste" from the context menu.
7. Repeat this process to create each separate table with the corresponding data.
8. Check each new table to ensure that the data has been placed correctly and clearly.

To check your Excel file for complex tables, take a look at the tables in the document. Are there any tables that you think are complex? Think about how you can split the information into several, simple tables.