NAVIGATION ☰
Home Page
Find Data by Source ►
Topical Collections
By Author
Journal Archives
Ask Facebook Group
Find Data by Subfield ►
African Politics
American Politics
Comparative Politics
European Politics
International Relations
Law Courts & Justice
Public Opinion Surveys
Voting & Elections
Ask Facebook Group
Teach Data Analysis ►
Teaching Resources
Teaching Assistant
Live R Demos
Sample Syllabi
Excel Tutorials ►
1: Excel for Data Analysis
2: Descriptive Statistics
3: Transforming Variables
4: Making Comparisons
5: Graphing Relationships
6: Random Assignment & Sampling
7: Controlled Comparisons
8: Sampling Distributions
9: Hypothesis Tests with One or Two Samples
10: Chi-Square & ANOVA
11: Correlation & Bivariate Regression
12: Multiple Regression
13: Regression Residuals
14: Logistic Regression
15: Doing Your Own Analysis
R Demos & Resourcs
Analyze Data ►
Grade Level of Text
Surname Census Info
Calculate Federal Judge Ideal Points
Crosstabs with Circuit Court Data
Election Simulation
Share Findings ►
Political Science Blogs
Political Science Journals
Political Science Podcasts
Political Theory Journals
Public Administration Journals
Public Policy Journals
Legal Research
It's Better with Music
About ►
This Web Site
Barry C. Edwards
Excel Tips & Tutorials:
Transforming Variables
Suggest a Link
Alphabetize Page
Printer-Friendly List
Find data. Produce results. Tell the world.
Watch and Learn
Watch and Learn
Watch and Learn
Watch and Learn
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials
|
Chapter 3
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials
|
Chapter 3
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials
|
Chapter 3
Advanced Filter Options Using Criteria Ranges
Leila Gharani shows how to create interactive filters on worksheets (7:23)
Excel Tutorials
|
Chapter 3
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
Excel Tutorials
|
Chapter 3
How to Insert Column in Worksheet
Fundamental skill for creating new variables in dataset (2:39)
Excel Tutorials
|
Chapter 3
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials
|
Chapter 3
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
Excel Tutorials
|
Chapter 3
How to Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials
|
Chapter 3
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials
|
Chapter 3
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials
|
Chapter 3
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials
|
Chapter 3
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials
|
Chapter 3
Advanced Filter Options Using Criteria Ranges
Leila Gharani shows how to create interactive filters on worksheets (7:23)
Excel Tutorials
|
Chapter 3
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
Excel Tutorials
|
Chapter 3
How to Insert Column in Worksheet
Fundamental skill for creating new variables in dataset (2:39)
Excel Tutorials
|
Chapter 3
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials
|
Chapter 3
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
Excel Tutorials
|
Chapter 3
How to Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials
|
Chapter 3
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials
|
Chapter 3
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials
|
Chapter 3
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials
|
Chapter 3
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials
|
Chapter 3
Advanced Filter Options Using Criteria Ranges
Leila Gharani shows how to create interactive filters on worksheets (7:23)
Excel Tutorials
|
Chapter 3
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
Excel Tutorials
|
Chapter 3
How to Insert Column in Worksheet
Fundamental skill for creating new variables in dataset (2:39)
Excel Tutorials
|
Chapter 3
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials
|
Chapter 3
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
Excel Tutorials
|
Chapter 3
How to Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials
|
Chapter 3
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials
|
Chapter 3
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials
|
Chapter 3
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials
|
Chapter 3
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials
|
Chapter 3
Advanced Filter Options Using Criteria Ranges
Leila Gharani shows how to create interactive filters on worksheets (7:23)
Excel Tutorials
|
Chapter 3
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
Excel Tutorials
|
Chapter 3
How to Insert Column in Worksheet
Fundamental skill for creating new variables in dataset (2:39)
Excel Tutorials
|
Chapter 3
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials
|
Chapter 3
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
Excel Tutorials
|
Chapter 3
How to Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials
|
Chapter 3
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials
|
Chapter 3
Over 18,000 Members!