This webinar recording from July 2020 has lots of tips and suggestions to help you create better spreadsheets.
These are techniques that I have used successfully on a regular basis and can recommend to other users.
The guidelines will help you use and create spreadsheets that
- are more reliable
- identify errors
- are easier to use and understand
- have more flexible formulas (can be copied to more places)
- are more structured
- are easy to navigate
Along the way you’ll pick up shortcuts and quick ways to do many different tasks.