Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Excel Basics
·
Module 3
Data Preparation and Cleaning
1
Sorting Data
Sort data by single and multiple criteria.
2
Filtering Data with AutoFilter
Apply AutoFilter to extract subsets of data based on values, text, and formatting.
3
Advanced Filters: Complex Data Extraction
Use advanced filters with a criteria range for complex data extraction.
4
Data Validation: Restricting Input and Guiding Users
Implement data validation rules to restrict cell input and guide users.
5
Deduplicate Your Data
Remove duplicate records from a dataset to ensure data quality.
6
Splitting and Reformatting Data with Text to Columns and Flash Fill
Use Text to Columns and Flash Fill to split and reformat data.
7
Wildcard Find and Replace for Bulk Data Correction
Use Find and Replace with wildcards for bulk data corrections.
8
Cleaning Data with TRIM, CLEAN, and SUBSTITUTE
Combine TRIM, CLEAN, and SUBSTITUTE to standardize messy text data.
Previous module
Advanced Functions and Data Retrieval
Next module
Structuring and Presenting Data