Excel Database Tips
This is an interesting video I made for a colleague (Sheena) who needed some help in Excel. It contains some key tips on creating databases in Excel:
1) Adding automatic serial numbers
2) Working with tables
3)Adding cascading drop-down lists
4) Defining names (assigning names to cells)
5) Using data validation criteria