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.

This video contains step-by-step instructions for conducting 1-way or single factor ANOVA along with post-hoc analysis.

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