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.
Follow
javascript: SP.SOD.executeFunc('followingcommon.js', 'FollowDoc', function() { FollowDoc('{ListId}', {ItemId}); });
0x0
0x0
ContentType
0x01
1100
Compliance Details
javascript:if (typeof CalloutManager !== 'undefined' && Boolean(CalloutManager) && Boolean(CalloutManager.closeAll)) CalloutManager.closeAll(); commonShowModalDialog('{SiteUrl}'+
'/_layouts/15/itemexpiration.aspx'
+'?ID={ItemId}&List={ListId}', 'center:1;dialogHeight:500px;dialogWidth:500px;resizable:yes;status:no;location:no;menubar:no;help:no', function GotoPageAfterClose(pageid){if(pageid == 'hold') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+
'/_layouts/15/hold.aspx'
+'?ID={ItemId}&List={ListId}'); return false;} if(pageid == 'audit') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+
'/_layouts/15/Reporting.aspx'
+'?Category=Auditing&backtype=item&ID={ItemId}&List={ListId}'); return false;} if(pageid == 'config') {STSNavigate(unescape(decodeURI('{SiteUrl}'))+
'/_layouts/15/expirationconfig.aspx'
+'?ID={ItemId}&List={ListId}'); return false;}}, null);
0x0
0x1
ContentType
0x01
898
Document Set Version History
/_layouts/15/images/versions.gif?rev=40
javascript:SP.UI.ModalDialog.ShowPopupDialog('{SiteUrl}'+
'/_layouts/15/DocSetVersions.aspx'
+ '?List={ListId}&ID={ItemId}')
0x0
0x0
ContentType
0x0120D520
330
Send To other location
/_layouts/15/images/sendOtherLoc.gif?rev=40
javascript:GoToPage('{SiteUrl}' +
'/_layouts/15/docsetsend.aspx'
+ '?List={ListId}&ID={ItemId}')
0x0
0x0
ContentType
0x0120D520
350
The Postgraduate Skills 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.
