You are Staff Member and you want to use the data stored in you Excel file to calculate an answer.
Solutions:
- You can use one of many existing Excel Formulas (e.g. SUM, AVERAGE, COUNT, VLOOKUP, Etc.) to calculate the answer you are looking for. This answer will be stored in another cell in your Excel file.
Steps:
Watch this video from Pip on how to use Formulas in Excel:
Further Information:
Overview of formulas in Excel: