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.