Date & time
Tuesday, May 12, 2026
3 p.m. – 4 p.m.
3 p.m. – 4 p.m.
Workshops & seminars
Share this event:
MS Excel for research: Master data cleaning, transformation and visualization (GradProSkills workshop)
Speaker(s)
Alana Rivera Matos, Santiago Valencia Ibañez
Cost
This event is free.
Organization
Contact
Where
Online
This training is offered by GradProSkills. It is only open to current graduate students and postdoctoral fellows.
Advance registration is required.
Do you have data you'd like to analyze? Would you like to gain insights from your data without having to rely on complex programming languages? Are you tired of manually filtering and cleaning your data? If the answer to any of these questions is "Yes!", then this workshop is for you. Join us in learning more about the user-friendly and classic data software that is Excel. Usually, the starting point of any data analysis, Excel is a widely known data analysis tool used in many different fields, ranging from finance to biology analytics.
In this all-in-one course, you’ll first learn all the basics of data formatting, cleaning and management in Excel. We’ll then move on to basic functions and the construction of graphs and charts within the software. Once the foundations are settled, more advanced functions, such as VLOOKUP/HLOOKUP, will be explored along with everything related to pivot tables! At last, you’ll be equipped with the tools to make eye-catching dashboards and will learn to generate basic statistical analysis to communicate your findings.
This workshop has a collaborative and interactive structure, leveraging Udemy, Moodle, and live weekly Q&A sessions.
- Navigate and utilize workbook structure and key navigation features in Excel to manage spreadsheet efficiently.
- Format and structure datasets using alignment, borders, numbers formatting to enhance readability and organization.
- Organize and clean data effectively by applying inserting, filtering, and replacing data, using advanced tools such as TRIM and REMOVE DUPLICATES.
- Perform calculations and retrieve data using basic and advanced Excel functions including SUM, AVERAGE, and COUNTIF, VLOOKUP and HLOOKUP.
- Create and customize figures and charts to visually represent data effectively.
- Construct and manipulate Pivot Tables to summarize and analyze datasets.
- Design and develop data visualization using Excel’s charting and dashboard tools to communicate key findings.
- Analyze and interpret datasets using Excel’s statistical tools to support data-driven decision making.