Intermediate Excel

1.1 Efficient way of using Excel: Customising the setting of Excel 1 Quiz

1.2 Efficient way of using Excel: Working with Templates 1 Quiz

1.3 Efficient way of using Excel: Working with Short Cuts Keys 1 Quiz

1.4 Efficient way of using Excel: Working with Range Name 1 Quiz

1.5 Efficient way of using Excel: Working with Simple Array formulas 1 Quiz

1.6 Efficient way of using Excel: Using Multiple Logical Functions with Nested if [And/ OR/ NOT] 1 Quiz

1.7 Efficient way of using Excel: Database Functions 1 Quiz

1.8 Efficient way of using Excel: Sorting & Filtering 1 Quiz

2.1 Lookup and Reference function: Understanding VLOOKUP 1 Quiz

2.2 Lookup and Reference function: Understanding and Resolving Errors in VLOOKUP 1 Quiz

2.3 Lookup and Reference function: IFERROR and ISERROR with VLOOKUP 1 Quiz

2.4 Lookup and Reference function: Column and Match function with VLOOKUP 1 Quiz

2.5 Lookup and Reference function: Using the INDEX and MATCH function 1 Quiz

2.6 Lookup and Reference function: OFFSET Function 1 Quiz

2.7 Lookup and Reference function: Referencing using the INDIRECT function 1 Quiz

3.1 Conditional Formatting: Cell Styles 1 Quiz

3.2 Conditional Formatting: Lists and Tables 1 Quiz

3.3 Conditional Formatting: Comparitive Conditional Formatting 1 Quiz

3.4 Conditional Formatting: Conditional Formatting of Dates 1 Quiz

3.5 Conditional Formatting: Advanced Conditional Formatting 1 Quiz

4.1 Exploring Subtotals: Creating Single Subtotals 1 Quiz

4.2 Exploring Subtotals: Creating Multiple Subtotals 1 Quiz

4.3 Exploring Subtotals: Copying Subtotals 1 Quiz