-
How to Excel (with Excel)
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…
-
Be brave: how to negotiate open access rights with your publisher
For Open Access Week 2020, I spoke with Dimity Flanagan (Manager, Scholarly Communications) at the University of Melbourne about why open access is important and the practicalities of making research open. My thoughts (originally published here) are reposted below. Q. Why is it important to you to take the extra time to make sure more of your research is available open access? For me, open access is important for a number of reasons. First, it is a way in which we can ensure that publicly-funded research is made accessible to the public. Second, open access extends the reach and impact of our scholarship. I have discovered this somewhat by accident:…
You May Also Like
Making the most of a grant
