- DOWNLOADS: Course Resources
- How and why you should use Excel tables with formulas
- The YEAR, MONTH, and DAY functions
- The DATE and EOMONTH functions
- The IF function
- The SUMIFS and COUNTIFS functions
- The LEFT, RIGHT, MID, FIND, and LEN functions
- The TEXTSPLIT function
- The TEXTBEFORE and TEXTAFTER functions
- The FILTER function
- The XLOOKUP Function