Legal academics have a well-known aversion to numbers. But Excel – for all its faults – can be a huge help when managing large amounts of data, be it numbers or words. I have used Excel to analyse cases, build tables and charts, and manage all sorts of data. We spoke with Christina Ward, Liaison Librarian (Research) at Melbourne Law School, about essential tips for using Excel for academic research. Our tips: To swap rows and columns in a table, copy the table, select “paste special” and click transpose. To reverse rows or columns in a table, try this trick. To manage data, the sort and filter functions are incredibly…