You can download the exercise file used in this video, and follow along here: ️https://www.simonsezit.com/article/designing-better-spreadsheets-in-excel-excel-tips-tricks/

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.

GET FOUR FREE COURSES! ️ https://www.simonsezit.com/four-free-courses

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

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)