Array formulas make excel calculations much quicker and easier. Check it out for yourself!
You already learned about some inbuilt functions like SUM(), MAX() etc. The following video walks you through more interesting functions.
SQL- More Queries
Using UPDATE query
Learn how to update entries in a table using UPDATE SQL query.
Practice more SQL
To brush up on SQL queries, practice from "SQL AND/OR" to "SQL UPDATE"