This site uses cookies
By clicking accept or continuing to use this site, you agree to our use of cookies. For more details about cookies and how to manage them, please see our Privacy Notice.
Retrieving books from our closed stacks will take longer due to ongoing renovation & improvement works. Do cater an additional day or two for your requests to be fulfilled. We apologise for the inconvenience & appreciate your understanding. For assistance or queries, contact loans@nus.edu.sg.
-
Borrowing & Requests
Borrowing & Requests
Recommend Articles, Books & Other Materials for Purchase
Can’t find a resource you need in our libraries? Send us your request and we’ll source for it
Intralibrary Loan
Request for a book to be sent to another library within NUS Libraries for collection
-
Services & Help
Services & Help
Guides & Tools
Discover our many resources for research, learning and teaching - from how-to guides, to databases and other powerful tools!
Research Starter-kit
Learn about research tools such as Proxy Bookmarklet, BrowZine, Citation Managers and FindIt! with Google Scholar
-
Spaces
Spaces
-
Collections
Collections
- What's on
Does This Spreadsheet Spark Joy? Tidy Data in Practice
2 Sep 2026 (Wed), 2pm - 2.30pm
Does this sound familiar? You open a spreadsheet and find multiple values squeezed into one cell, numbers spread across separate columns, and tables that look perfectly fine—until you start to analyse them.
In this beginner-friendly session, we’ll introduce the principles of tidy data and show you how to recognise common features that can make analysis difficult. You’ll learn how to turn messy Excel and CSV files into tables that are ready to be analysed, using tools you already have: Microsoft Excel and Power Query. We’ll also explore how tidy data can make it easier to filter data, create PivotTables and charts, and generate simple summaries. If time permits, we’ll demonstrate how the same process can be applied in a programming environment such as R.
After the session, you are welcome to join us at a clinic session, where you can bring your own datasets, spreadsheet problems or data-cleaning questions for discussion and troubleshooting.
Speaker
Cheng Eng Aun
Cheng Eng Aun
Library Data Analytics and Procurement Manager
Eng Aun is the Data Analytics and Procurement Manager at NUS Libraries. He makes extensive use of R and AI tools in analysing library administrative data which helps colleagues make better decisions. He previously served in Library Technical Services and as the Economics resource librarian.
Disclaimer
All information provided on the presentations is on an “as is” basis and you agree that you use such information entirely at your own risk. NUS Libraries does not in any way, expressly or implicitly, endorse any third party products, processes
or services.
The views and opinions expressed by the speaker(s) are their own and do not represent the views and opinions of the National University of Singapore or any of its subsidiaries or affiliates.
NUS Libraries prohibits the use of presentation slides without permission.
The views and opinions expressed by the speaker(s) are their own and do not represent the views and opinions of the National University of Singapore or any of its subsidiaries or affiliates.
NUS Libraries prohibits the use of presentation slides without permission.
Terms & Conditions
By registering for this event, you hereby consent to National University of Singapore (NUS) collecting, using, retaining and/or disclosing your personal data to certain approved third parties for the purpose of processing, handling and managing your
participation in the event.
