#ictactivelearner #0417ict
This channel will help you to learn about Cambridge IGCSE ICT 0417/P2/P3 contents.
Learn also
Conditional formatting : • Task 20X Conditional Formatting
Cell formatting: • Task 20w Cell Formatting to currency
Formatting cell 2: • Task 20v Formatting cells
Sorting: • Task 20u Sorting
Using wild card filter: • Task qrst (Use of wild card in filtering d...
Number & more criteria filtering: • Task qrst (Use of wild card in filtering d...
Text Filter • Task 20n Text filter
VLookup • Task 20m VLOOKUP
HLookup • Task 20L (Hlookup)
SUMIF Condition • Task 20K SUMIF Condition
Nested if Condition • Task 20J (Nested If condition)
If condition • Task 20i IF Condition
CountIF condition • Task 20h COUNTIF Function
Count & CountA • Task 20g (Count & CountA)
INT, Round function • Task 20f (INT, Round function)
Sum, MAX, MIN,AVERAGE: • Task 20e (SUM, AVERAGE, MAX, MIN)
Name cell or range of cells: • Task 20d Name a cell or range of cells
Addition of cells • Task 20c (Addition, subtraction, multiplic...
Creating Models • Task 20b Create data model