Below is a list of formulas and functions.

Example of Excel Features and Functions

Average

Bar Chart

Conditional Formatting

Consolidate

Count IF

CountA

Filter

Flash Fill Function

Hyperlink

IF Function

Line Chart

Medium, Minimum and Max

Pie Chart

PMT Function

Safeguarding a Workbook

Screen Shots

Sort

Sum Function

SUMIF Function

SUMPRODUCT

Vlookup

AVOID: Advanced Functions i$.$e$.$ INDEX$/$MATCH

One such example includes using the TEXTJOIN function. The TEXTJOIN function in Excel merges strings of text from multiple cells into one cell.

Someone might attempt to explain that, for example, the TEXTJOIN function can join a person's first and last name that are in two different cells into

one cell like a marriage license joins two single people who live in two different homes into one home.