Using Excel

Microsoft Excel is an essential tool for data analysis of any kind, but some aspects may be confusing or difficult to learn. This page covers elements of Excel that are required for this course and is by no means an exhaustive guide.

Add-ins
Excel supports several add-ins that provide extra tools from navigation to data analysis. Image
 * 1) To access the add-in menu, open Excel (and navigate to Home if needed) and click the 'Options' button at the very bottom of the left ribbon.
 * 1) Select 'Add-ins' from the left ribbon again, just above Trust Center. From here you can view all available plugins by their status.
 * 1) To activate a plugin, select the relevant category from the drop-down at the bottom and click 'Go'.

The most relevant add-in for this degree is 'Analysis ToolPak'.
 * 1) Select 'Excel Add-ins' from the dropdown.
 * 2) In the new dialogue box, tick the box for Analysis ToolPak and click OK.

Congratulations! You've just activated your first, and perhaps only, Excel add-in.