NAVIGATION ☰
Home Page
Find Data by Subfield ►
African Politics
American Politics
Asian Politics
Comparative Politics
European Politics
International Relations
Latin American Politics
Law Courts & Justice
Methodology
Migration & Citizenship
Political Behavior
Teaching & Learning
Voting & Elections
Find Data by Source ►
Topical Collections
By Author
Journal Archives
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 & Resources
Analyze Data ►
Grade Level of Text
Surname Census Info
Calculate Federal Judge Ideal Points
Crosstabs with Circuit Court Data
Election Simulation
Share Findings ►
Blogs
Peer-Reviewed Journals
Podcasts
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
Watch and Learn
Watch and Learn
Watch and Learn
Watch and Learn
How to Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials
|
Chapter 3
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials
|
Chapter 3
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
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 Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials
|
Chapter 3
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials
|
Chapter 3
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials
|
Chapter 3
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials
|
Chapter 3
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
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 Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials
|
Chapter 3
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials
|
Chapter 3
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
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 Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials
|
Chapter 3
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials
|
Chapter 3
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials
|
Chapter 3
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials
|
Chapter 3
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
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 Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials
|
Chapter 3
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials
|
Chapter 3
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
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 Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials
|
Chapter 3
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials
|
Chapter 3
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials
|
Chapter 3
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials
|
Chapter 3
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
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 Use Autosum, Average, Max, Min, Count & Autofill Functions
From Organic Chemistry Tutor (6:46)
Excel Tutorials
|
Chapter 3
Calculating the Difference between Two Columns
Simple example of change in test scores (1:34)
Excel Tutorials
|
Chapter 3
How to Use STANDARDIZE Function
Demonstration with student GPAs (1:39)
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 Create Dummy Variables
Taylor Smith demonstrates by converting categorical variable into dummy variables (7:25)
Excel Tutorials
|
Chapter 3
How to Normalize and Standardize Data
Demonstration with stock and bond prices (18:48)
Excel Tutorials
|
Chapter 3
How to Convert Measurement Units
Using the EXCEL function (5:54)
Excel Tutorials
|
Chapter 3
Filter Options Basics
With time saving tips from Leila Gharani (10:45)
Excel Tutorials
|
Chapter 3
How to Filter Using Numbers in Custom Range
From Excel4Business (1:28)
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
Over 18,000 Members!
Over 18,000 Members!
