Excel- Functions

Array Formulas

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"

Data in Action