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.
**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 ;-)
Видео Excel Tips & Tricks: Designing Better Spreadsheets - 1-hour Excel Tutorial канала Simon Sez IT
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 ;-)
Видео Excel Tips & Tricks: Designing Better Spreadsheets - 1-hour Excel Tutorial канала Simon Sez IT
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
SECRET Excel Named Range Shortcuts to Save TimeDo's & Don'ts of Excel Spreadsheet Design (with Examples)Advanced Excel Formulas (IF, IFS, INDEX, MATCH, SUMPRODUCT, XLOOKUP, OFFSET, CHOOSE)EXCEL PRO TIP: Color & Border DesignExcel Formatting Tips for Consultants50 Ultimate Excel Tips and Tricks for 2020Microsoft Excel Tutorial - Beginners Level 1Top 20 Microsoft Excel Tips & TricksCreating an Interactive Dashboard in Excel Using Pivot Tables, Pivot Charts and Slicers📊 How to Build Excel Interactive DashboardsHow To Optimize Amazon PPC Campaigns 2022 | Step By Step TutorialHow to Create Professional Looking Excel Spreadsheets14 Excel Formatting Tips (Make Excel BEAUTIFUL!)Properly Create Surveys with Microsoft Forms & Export to ExcelThe Golden Rules of Spreadsheet DesignHow to Beautify Tables in Microsoft ExcelExcel Tutorial for BeginnersExcel Tutorial - BeginnerAdvanced Excel Tutorial | Excel Training | Edureka