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