| Session | Module | Domain | Description | E-Learning | Assessment | Handouts |
| 19 | MS Excel – Formatting, Basic formulas and functions | Data Management and Analysis | Changing cell fill, font and border | VIEW | ATTEMPT | DOWNLOAD WNS2DOWNLOAD EXCEL MAGIC BOOK |
| Merging and wrapping cells, content alignment | ||||||
| Format painter, Paste Special & Conditional formatting (Group, Hyperlink) | ||||||
| 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 |