Excel

Excel remains a powerful software. However, most people do not expect you to know every subcommand. This page offers tips and suggestions related to Excel.

This document provides formulae for accounting functions. This document gives example code related to IF, Search, and Range functions. Plus, it incorporates good CRAP design.

I have created several videos that contain step-by-step instructions for using Excel to conduct the following analyses:

• Sampling (or subsetting) as well as imputing for missing nominal variables
• Removing duplicate numbers and looking for out-of-range values
• Imputing missing nominal variables
• Converting text to numbers and numbers to text
• Chi-Square test for independence, along with Cramer's V effect size, in Part 1 and Part 2
• 1-way or single-factor ANOVA along with post hoc analysis
• Correlation table including how to interpret the r-value or correlation coefficient value, along with running descriptive statistics
• Multiple variable regression, including metric independent variables and dummy variables. Here is another video that covers a similar topic but uses a sample of the data from the larger dataset that the other video uses.
• Standardized regression.

​
These websites are devoted to Excel:

• Chandoo
• Excel Charts
• Excel Easy​

Specific pages include good examples of:

• Add arrows to lines
• Classification of chart types
• Create data tables
• Pivot tables