| Session | Module | Domain | Description | E-Learning | Assessment | Handouts |
| 25 | Excel 2 | Changing cell fill, font and border Merging and wrapping cells, content alignment Format painter, Paste Special & Conditional formatting (Group, Hyperlink) |
VIEW | ATTEMPT | DOWNLOAD | |
| Importance of aesthetics in a worksheet | ||||||
| Exercises on Filtering, freezing, formatting spreadsheets SUM, AVERAGE, COUNT, SUMIF, AVERAGEIF, COUNTIF, MIN, MAX |
||||||
| If function with nested if Text functions : Right, left, mid, trim, concatenate Absolute and relative cell referencing Case study exercises on using basic formulas and functions |