Welcome to this guide on using Excel to clean and analyze data!
This guide includes information on --
- Keyboard Shortcuts
- Adjusting Your View
- References
- Using Data Cleaning Functions (TRIM, LOWER, CONCAT)
- Dealing with Missing Values (Find & Replace)
- Removing Duplicates
- Text-to-Column
- V-Look Up
- Data Validation
- Data Analysis Functions (AVERAGE, MEDIAN, CORREL, UNIQUE)
- Tables and Pivot Tables
