Name: Excel Tutorial Videos, Chapter 3 | PoliSciData
Channel: Barry Edwards, JD, PhD, poliscidata.com
Description: Excel tutorial videos for Creating & Transforming Variables from A Microsoft Excel Companion to Political Analysis.

Watch & Learn: Creating & Transforming Variables

►
How to Use Autosum, Average, Max, Min, Count & Autofill Functions i
From Organic Chemistry Tutor (6:46).
►
Advanced Filter Options Using Criteria Ranges i
Leila Gharani shows how to create interactive filters on worksheets (7:23).
►
How to Filter Using Numbers in Custom Range i
From Excel4Business (1:28).
►
Filter Options Basics i
With time saving tips from Leila Gharani (10:45).
►
How to Normalize and Standardize Data i
Demonstration with stock and bond prices (18:48).
►
How to Use STANDARDIZE Function i
Demonstration with student GPAs (1:39).
►
How to Create Dummy Variables i
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25).
►
How to Insert Column in Worksheet i
Fundamental skill for creating new variables in dataset (2:39).
►
How to Convert Measurement Units i
Using the EXCEL function (5:54).
►
Calculating the Difference between Two Columns i
Simple example of change in test scores (1:34).

Streaming Excel Tutorial Videos for Creating & Transforming Variables