Worksheets

Hi Sandra,

Thank you for the forum question.

To have a sheet for each year is perfectly fine if you do not need to analyse across the years, but if you want to compare the last 5 years it will be a lot of work from separated sheets. If you have the data in one list on one sheet you can in 2 minutes analyse all your years in PivotTables.

Best practice organising a workbook as I mentioned on the course is to keep things separated. All source data on one sheet without any calculations. Just the raw data. One sheet for the output (the report, dashboard, or just the information you need to get from your data). If you need calculations to get the output use separated sheets to do this.

I have attached the best practice rules for Excel created by the Fast Standard organisation. I totally agree with the organisation.

If you organise the data on one sheet, they must be organised on a list. I have attached a workbook, where I on the top have organised the data in a non list and below the same data in a list.

Again if you do not need to calculate or analyse across the years just keep it as one year on each sheet.

I hope this makes sense.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector