The EXPLORE Tool in GOOGLE SHEETS does so much work for you! Select your data, click on EXPLORE, and see what it does!
Be sure to select some data before you click on Explore. You can type a question or choose from the questions listed. In my example, Google Explore created a pivot table in response to my question. If a formula is used to create an answer, you can click on "See Formula" and it will show the formula that was used. This is a great way to learn the formulas. Explore is also available in Google Docs and Google Slides. Wait until you see what you can do with Explore in Docs and Slides!