Excel- Advanced Formatting

Conditional Formatting in Excel

The following 2 videos will teach you about a cool tool in Excel that allows you to format a cell or a range of cells. You can use this tool to easily highlight important information in a spreadsheet.

Formatting Cells based on Values of other Cells
Very Imp- Formatting Cells in Matrix in One Step

SQL- Revision of Basic Queries

Revision- SQL So far

Time to quickly revise what you have learnt so far. The following videos will walk you through the basic SQL queries and also give you a feel for how a table is created using SQL. We encourage you to quickly watch the videos but in case you want to skip, go ahead and jump straight to the practice exercises.

Data in Action