Excel Tips & Tricks: Designing Better Spreadsheets – 1-hour Excel Tutorial

Excel Tips & Tricks: Designing Better Spreadsheets – 1-hour Excel Tutorial

In this 1-hour class, we look at several excellent Excel tips and tricks to help you design your spreadsheets in the right way.

Good spreadsheet design is essential if your Excel workbooks are going to be used by multiple people. Once again, this class was hosted by the excellent Deborah Ashby for Simon Sez IT.


In this class, we teach you:

– How to layout your spreadsheet
– How to use summary sheets to direct users to the right areas of a workbook
– Cell styles and formatting in Excel
– Adding controls via Data Validation (Dropdown lists!) in Excel
– How to protect an Excel workbook or worksheet
– Using version control and setting up a version control system in Excel

This is a recording of a live training session held for Simon Sez IT members: https://www.simonsezit.com/membership/

To see more, free Advanced Excel tutorials, take a look at this 4.5 hour YouTube course: https://youtu.be/gjfjn8Lwa28

Other, free Microsoft 2019 playlists from Simon Sez IT:

Microsoft Project 2019 course playlist: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jo_PtA6h6LNhvMbWNtJsXL

Microsoft Excel 2019 Beginners playlist:

Microsoft Excel 2019 Advanced playlist:


Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
Twitter: https://twitter.com/SimonSezIT

If you enjoyed the video, please give a “thumbs up” and subscribe
to the channel 😉

Leave a Reply

Close Menu