Excel Top Tip #1

Make sure your data is well organised with a column heading for each piece of information and each new instance of it stored as 1 row only. This is called a table. Tables can be filtered and summarised and form the input to the truly wonderful Pivottables we’ll look at later.

Setting up a Data Table with a heading for each column
Organise Your Data

Comments are closed.