Division for Research Development
Welcome to Stellenbosch University

MS Excel for Research Data Management

​​This is not an entry-level course, and only users experienced with the basic features of Excel should enrol.

Description

This workshop is suitable for those wishing to learn how to use Microsoft Office Excel to develop data spreadsheets into charts, making use of templates, graphics and basic formulas etc. The workshop covers how to use the following MS Excel functions (amongst others) effectively:

  • Worksheet Editing & Formatting
  • Rows & Columns
  • Find and Replace
  • Referencing in Excel
  • Function Entry Dialog Box
  • Pivot Tables
  • Calculating data across worksheets
  • Tables
  • Sorting and Filtering Data
  • Charts
  • Sparklines

Target audience

SU postgraduate students working on their thesis or dissertation who need Excel skills to manage and organise their research data effectively.

Cost

This workshop opportunity is funded by the Postgraduate Office. There is no cost involved for registered SU postgraduates who sign up and attend, however, in the case of late cancellations or non-attendance, applicants will be responsible for the full workshop fee since late cancellations and non-attendance have considerable cost implications for our office.

Contact and booking details

Booking is essential and places are limited. Please note that we will confirm your place on receipt of your application. 
 
This workshop is offered in both an online and face-to-face format. Face-to-face workshops are held on Stellenbosch campus. The venue will be confirmed with the enrolled participants directly.

Online course format

Participants have an introductory live session via Microsoft Teams on the first day of the workshop. Course content is then made available to the enrolled participants via SUNLearn. Participants have seven days to work through the course material and exercises on SUNLearn at their own pace before the final live question and answer session via Teams on the last day of the workshop. The live sessions allow participants to ask the facilitator questions and receive feedback on their exercises.

 
The instruction sessions via Microsoft Teams consists of one introductory and closing meeting from:
 09:00-11:00 

In-person (hybrid) course format

Participants will have an in-person opening session taking place on SU central campus, on Monday. After seven days of self-study participants will have a closing session online via MS Teams, the following Monday​. 
Venue: Stellenbosch central campus (final venue information will be sent to confirmed participants).
Time: 9:00-12:00​​

Click on a date below to sign up.​​
 
  
  
Description
  
  
  
  
In-person 15 May 202315 May 2023 (In-person)
Sign up form online MS Excel 15 May 2023In page navigation
Online 10-17 July 202310 July and 17 July 2023 (Online)
Sign up form online MS Excel 10 July 2023 and 17 July 2023 In page navigation

The Postgraduate Skill​s Programme reserves the right to move a workshop forward or cancel it if there is not enough interest. Registrations close five days prior to a workshop. 

​For enquiries please email pgskills@sun.ac.za.