Skip to Main Content

Cleaning & Analyzing Data in Excel

This guide complements the Cleaning & Analyzing Data in Excel workshop


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

The Data File

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.