Excel Magic

This handout contains a variety of functions and tricks that can be used for cleaning and  analysing data in Excel. This handout refers to data in an Excel file called"ExcelMagic.xlsx".

Here is a diagram to guide you on how to display your data appropriately.