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
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/
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:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg
Microsoft Excel 2019 Advanced playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9
**GET FOUR FREE COURSES!** ►
https://www.simonsezit.com/four-free-courses
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 😉
