Data Analysis with Excel – 1 – → 1.1 Creating a Drop-down List

Expand all sectionsCollapse all sections

Module 1 - Data Validation
Data validation is a form of data cleansing that enables you to check the accuracy and quality of source data before using, importing or otherwise processing it. Different types of validation can be performed depending on destination constraints or objectives. The focus of this lesson is to ensure that you can use data validation to restrict the type of data or values you enter in a cell during data entry, and to ensure the integrity of the data file.
3
Module 2 - Sorting and Filtering
Sort and Filter tools are some of the most commonly used Excel features to help you analyze data. Sort feature makes it easy for you to rearrange the records or even the fields in your table of data or data list. You use filter to focus on a specific set of your data where you can then copy, format, or print it, without having to do any sorting. This lesson discusses how you can use sort and filter features, without any prior skills in Excel formula and functions, to manipulate records of any complex data file.
2
- 2.1
  2.1 Sorting a Data File
- 2.2
  2.2 Filtering a Data File
2.1 Sorting Records of an Excl Table
0
2.2 Filtering Records of an Excel Table
0
Quiz
1
- 6.1
  Data Quiz 2
  10 Minutes0 Questions

This content is protected, please and enroll in the course to view this content!

1.2 Adding a Data Validation Rule