Data Preparation

• WORKBOOK

• EXCEL LINKS

• MISSING DATA
   

• TRANSFORMATIONS

• APPLY FUNCTION

• NORMAL SCORES

• STANDARDIZATION

• CONVERTING BETWEEN UNITS
   

• RANKING

• SORTING DATA TO NEW COLUMNS IN WORKSHEETS

• SORTING EXISTING CELLS WITHIN WORKSHEETS
   

• DATE & TIME INTERVALS

• PAIRWISE

• RANDOM NUMBERS

• ROTATE DATA BLOCK

• DUMMY VARIABLES

• TEXT TO NUMBERS

• SEARCH & REPLACE

• CLEAR MISSING DATA
   

• CATEGORISE

• EXTRACT VARIABLES

• COMBINE GROUPS AND CREATE A GROUP IDENTIFIER

• SPLIT BY GROUP IDENTIFIER

• TABULATE

• DETABULATE

• CROSSTABS

• FREQUENCIES