Excel

Excel remains a powerful software. 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 contains step-by-step instructions for using Excel to conduct the following analyses:

• 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 a metric independent variables and dummy variables

​
These websites are devoted to Excel:

• Chandoo
• Excel Charts
• Excel Easy​

Specific pages include good examples on:

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