SKILLSHARE ULTIMATE EXCEL COURSE 6 VALIDATING AND PROTECTING EXCEL DATA-iLLiTERATE
Submitted by milohaze on Fri, 04/26/2019 - 16:10
Category:
Genre:
This class is #6 in a series called the Ultimate Excel Course.
In this class you will learn how to effectively validate data entry, and to protect important data on a spreadsheet in Excel.
These Excel skills are often overlooked as users want to learn how to create charts, PivotTables and powerful formulas. Yet without, clean and accurate data none of those Excel features will work correctly.
Although it is the responsibility of the user to correctly enter data and to avoid editing the wrong cell, mistakes happen. So if we can limit, or possibly prevent them from happening. It is important.
In this class we will look at some Data Validation rules that you can apply right away. We will also cover a clever technique to create dependent drop down lists (a commonly asked question on my training).
We then look at protecting parts of a spreadsheet from accidental editing. We lock down specific Excel features, but ensure the user is able to do what they need to.
In this class you will learn how to effectively validate data entry, and to protect important data on a spreadsheet in Excel.
These Excel skills are often overlooked as users want to learn how to create charts, PivotTables and powerful formulas. Yet without, clean and accurate data none of those Excel features will work correctly.
Although it is the responsibility of the user to correctly enter data and to avoid editing the wrong cell, mistakes happen. So if we can limit, or possibly prevent them from happening. It is important.
In this class we will look at some Data Validation rules that you can apply right away. We will also cover a clever technique to create dependent drop down lists (a commonly asked question on my training).
We then look at protecting parts of a spreadsheet from accidental editing. We lock down specific Excel features, but ensure the user is able to do what they need to.