BA375 Cleaning Filtering and Random Sampling in Excel

This video walks through how to take a random sample and clean a dataset in Excel. Specifically, how to - reduce the dimensions of a larger dataset by selecting columns in excel - filter out blanks and unwanted values using the filter function - take a random sample using the =rand() function. 0:00 Introduction 0:30 Reducing Number of Variables by Selecting Columns 1:25 Removing Blanks using Filter Function 1:56 Filter out unwanted values like 0's or Negative Values using Filter 3:02 Taking a Random Sample with =rand() 4:55 Saving file as .csv and Conclusion