Here are some handy little things you can do with Excel.
I learnt these when helping my friend with a spreadsheet he was using for his company.
You will learn:
- Drop down lists
- Creating a list with a reference
- Fixing errors with the drop down list
- Dealing with a Math error when dividing by zero
- How to have two items determine the contents of another cell
- Fix the #N/A Error