Excel Lecture-3

1. Freeze PanesàWindowsàFreeze Panes
2. How to filter DataàFilter (Use the file “Roster” in F:\user\Alam\Assignments-Test-pick)
3. Text Alignment and OrientationàRight ClickàFormat Cell
4. Wrap TextàRight ClickàFormat Cell
5. How to input Text file DataàGet external data (Use the file “ExcelInput” in F:\user\alam\Assignments-Test-pick)
6. How to validate data? Use drop down menu to give an example DataàValidationàList
7. How to validate data? Use Text Length to give an example

DataàValidationàText Length

8. Delete Conditional Format
9. Spell Check