I’ve created a video demonstrating how to do some intermediate functions in Excel.

To follow along, please download the following file: Example Worksheet