0 student

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