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 provides example code for the 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
• Handling missing values
• Detecting outliers in the dataset
• Transforming metric to nonmetric data (e.g., binning)
• Running and cleaning descriptive statistics
• Chi-Square test for independence, along with Cramer's V effect size, in Part 1 and Part 2
• T-tests with Marketing examples, running the T-test, and finding the effect size (Cohen's d)
• 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​
• Statology

Specific pages include good examples of:

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