[{"id":282,"title":"Excel for Researchers","url":"https://staging.dresa.org.au/materials/excel-for-researchers-7a896911-154c-4a7a-a245-293d89aed964.json","description":"Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. And sometimes there’s too much of it. Frequently, it has errors. We’ll use one of the most widespread data wrangling tools, Microsoft Excel, to import, sort, filter, copy, protect, transform, summarise, merge, and visualise research data.  \n  \n While aimed at novice Excel users, most attendees will walk away with new tricks to work more efficiently with their research data.\n\n‘Clean up’ messy research data  \n Organise, format and name your data  \n Interpret your data (SORTING, FILTERING, CONDITIONAL FORMATTING)  \n Perform calculations on your data using functions (MAX, MIN, AVERAGE)  \n Extract significant findings from your data (PIVOT TABLE, VLOOKUP)  \n Manipulate your data (convert data format, work with DATES and TIMES)  \n Create graphs and charts to visualise your data (CHARTS)  \n Handy tips to speed up your work\n\nIn order to participate, attendees must have a licensed copy of Microsoft Excel installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software.  \n  ","doi":"10.5281/zenodo.6423556","remote_updated_date":null,"remote_created_date":null,"scientific_topics":[],"operations":[]},{"id":270,"title":"Beyond Basics: Conditionals and Visualisation in Excel","url":"https://staging.dresa.org.au/materials/beyond-basics-conditionals-and-visualisation-in-excel.json","description":"After cleaning your dataset, you may need to apply some conditional analysis to glean greater insights from your data. You may also want to enhance your charts for inclusion into a manuscript, thesis or report by adding some statistical elements. This course will cover conditional syntax, nested functions, statistical charting and outlier identification. Armed with the tips and tricks from our introductory Excel for Researchers course, you will be able to tap into even more of Excel’s diverse functionality and apply it to your research project.\n\n- Cell syntax and conditional formatting\n- IF functions\n- Pivot Table summaries\n- Nesting multiple AND/IF/OR calculations\n- Combining nested calculations with conditional formatting to bring out important elements of the dataset\n- MINIFS function\n- Box plot creation and outlier identification\n- Trendline and error bar chart enhancements\n\nFamiliarity with the content of Excel for Researchers, specifically: \n\n- the general Office/Excel interface (menus, ribbons/toolbars, etc.)\n- workbooks and worksheets\n- absolute and relative references, e.g. $A$1, A1.\n- simple ranges, e.g. A1:B5","doi":null,"remote_updated_date":null,"remote_created_date":null,"scientific_topics":[],"operations":[]},{"id":226,"title":"Excel for Researchers","url":"https://staging.dresa.org.au/materials/excel-for-researchers.json","description":"Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. And sometimes there’s too much of it. Frequently, it has errors. We’ll use one of the most widespread data wrangling tools, Microsoft Excel, to import, sort, filter, copy, protect, transform, summarise, merge, and visualise research data.  \n  \n While aimed at novice Excel users, most attendees will walk away with new tricks to work more efficiently with their research data.\n\n‘Clean up’ messy research data  \n Organise, format and name your data  \n Interpret your data (SORTING, FILTERING, CONDITIONAL FORMATTING)  \n Perform calculations on your data using functions (MAX, MIN, AVERAGE)  \n Extract significant findings from your data (PIVOT TABLE, VLOOKUP)  \n Manipulate your data (convert data format, work with DATES and TIMES)  \n Create graphs and charts to visualise your data (CHARTS)  \n Handy tips to speed up your work\n\nIn order to participate, attendees must have a licensed copy of Microsoft Excel installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software.  \n  ","doi":"10.5281/zenodo.6423556","remote_updated_date":null,"remote_created_date":null,"scientific_topics":[],"operations":[]},{"id":225,"title":"Getting Started with Excel","url":"https://staging.dresa.org.au/materials/getting-started-with-excel.json","description":"We rarely receive the research data in an appropriate form. Often data is messy. Sometimes it is incomplete. And sometimes there’s too much of it. Frequently, it has errors.   \n  \n This webinar targets beginners and presents a quick demonstration of using the most widespread data wrangling tool, Microsoft Excel, to sort, filter, copy, protect, transform, aggregate, summarise, and visualise research data.\n\nIntroduction to Microsoft Excel user interface  \n Interpret data using sorting, filtering, and conditional formatting  \n Summarise data using functions  \n Analyse data using pivot tables  \n Manipulate and visualise data  \n Handy tips to speed up your work\n\nThe webinar has no prerequisites.","doi":"10.5281/zenodo.6423545","remote_updated_date":null,"remote_created_date":null,"scientific_topics":[],"operations":[]}]