Google Sheets is truly a game changer. Those formulas can do anything, and I truly mean ANYTHING. So, I had to make sure my team was using this tool to its full capability by having a list of the formulas they could use for their projects. Every day for a couple of hours, I would research various formulas to make a master list. I described the formula’s function, as well as provided an example. To help my team understand the formulas, I even created a few games.

The best part of Google Sheets formulas is the continuous learning. There’s always so much more to learn, and the endless possibilities are what makes Google Sheets an invaluable tool for researching projects. Check out my formulas library below: