Michael A. Levin
Excel remains a powerful software. Most people do not expect you to know every subcommand. This page offers tips and suggestions related to Excel.
provides formulae for accounting functions.
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
along with post-hoc analysis
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:
Specific pages include good examples on:
Add arrows to lines
Classification of chart types
Create data tables