%PDF-1.3 1 0 obj << /Type /Catalog /Outlines 2 0 R /Pages 3 0 R >> endobj 2 0 obj << /Type /Outlines /Count 0 >> endobj 3 0 obj << /Type /Pages /Kids [6 0 R ] /Count 1 /Resources << /ProcSet 4 0 R /Font << /F1 8 0 R /F2 9 0 R /F3 10 0 R /F4 11 0 R >> >> /MediaBox [0.000 0.000 612.000 792.000] >> endobj 4 0 obj [/PDF /Text ] endobj 5 0 obj << /Creator (DOMPDF) /CreationDate (D:20210508154359+00'00') /ModDate (D:20210508154359+00'00') /Title (IT-artikels) >> endobj 6 0 obj << /Type /Page /Parent 3 0 R /Annots [ 12 0 R 14 0 R ] /Contents 7 0 R >> endobj 7 0 obj << /Length 3433 >> stream 0.702 0.800 0.816 rg 34.016 34.016 543.969 723.969 re f 1.000 1.000 1.000 rg 45.266 288.772 521.469 457.962 re f 0.773 0.773 0.773 RG 0.75 w 0 J [ ] 0 d 45.641 289.147 520.719 457.212 re S 0.773 0.773 0.773 rg 61.016 617.359 m 550.984 617.359 l 550.984 618.109 l 61.016 618.109 l f 1.000 1.000 1.000 rg BT 278.868 698.693 Td /F1 10.5 Tf [(POST LIST)] TJ ET 0.200 0.200 0.200 rg BT 212.789 670.111 Td /F1 14.4 Tf [(INFORMASIETEGNOLOGIE)] TJ ET BT 221.824 643.466 Td /F1 11.7 Tf [(INFORMATION TECHNOLOGY)] TJ ET BT 61.016 583.841 Td /F1 14.4 Tf [(ONLINE EXCEL TRAINING NOW AVAILABLE)] TJ ET 0.400 0.400 0.400 rg BT 61.016 564.033 Td /F3 9.0 Tf [(If you want to brush up on your Excel skills, we have just the solution for you.)] TJ ET BT 61.016 544.044 Td /F3 9.0 Tf [(You can now do an online Excel course which covers all the content of Microsoft Office Excel 2019 needed to become )] TJ ET BT 61.016 533.055 Td /F3 9.0 Tf [(internationally certified. It also aims to help with the navigation of Excel within the office 2019 and 365 environment.)] TJ ET BT 61.016 513.066 Td /F3 9.0 Tf [(The course takes place over four days and there are fixed training periods you can choose from. )] TJ ET BT 446.198 513.066 Td /F4 9.0 Tf [(The next session takes )] TJ ET BT 61.016 502.077 Td /F4 9.0 Tf [(place 24 to 27 August.)] TJ ET BT 61.016 482.088 Td /F3 9.0 Tf [(The only prerequisites are that you are computer literate, you have a desktop or laptop, Office365 and an internet )] TJ ET BT 61.016 471.099 Td /F3 9.0 Tf [(connection.)] TJ ET BT 61.016 451.110 Td /F3 9.0 Tf [(To enrol for the course, you can register on SUN-e-HR. Browse to )] TJ ET 0.373 0.169 0.255 rg BT 326.111 451.110 Td /F3 9.0 Tf [(my.sun.ac.za)] TJ ET 0.373 0.169 0.255 RG 0.18 w 0 J [ ] 0 d 326.111 449.959 m 379.130 449.959 l S 0.400 0.400 0.400 rg BT 379.130 451.110 Td /F3 9.0 Tf [(, click on the SUN-e-HR tab and log in )] TJ ET BT 61.016 440.121 Td /F3 9.0 Tf [(with your sun account. After logging in, you can go to)] TJ ET BT 61.016 429.132 Td /F3 9.0 Tf [(Training and development-> Learner Home->Information Technology and the Excel course will show there.)] TJ ET BT 61.016 409.143 Td /F3 9.0 Tf [(As soon as you've registered StellieTech, the company responsible for the training will contact you. Their trainers will )] TJ ET BT 61.016 398.154 Td /F3 9.0 Tf [(follow along with your training progress and assist you to make sure you are on track throughout the programme.)] TJ ET BT 61.016 378.165 Td /F3 9.0 Tf [(The training material that will be covered is exactly the same as the material covered in StellieTech training centres. All )] TJ ET BT 61.016 367.176 Td /F3 9.0 Tf [(aligned to the global industry standard and internationally accredited certification. On the platform, you will find their pre-)] TJ ET BT 61.016 356.187 Td /F3 9.0 Tf [(assessments, training videos, practice simulations, post-assessments, and downloadable workbooks & follow along files. )] TJ ET BT 61.016 345.198 Td /F3 9.0 Tf [(Everything is clearly laid out in the platform and very user friendly.)] TJ ET BT 61.016 325.209 Td /F3 9.0 Tf [(More detailed information on the )] TJ ET 0.373 0.169 0.255 rg BT 192.578 325.209 Td /F3 9.0 Tf [(Excel-course.)] TJ ET 0.18 w 0 J [ ] 0 d 192.578 324.058 m 247.091 324.058 l S 0.400 0.400 0.400 rg BT 61.016 306.720 Td /F3 9.0 Tf [(Posted in:News,Notices,Training | | With 0 comments)] TJ ET endstream endobj 8 0 obj << /Type /Font /Subtype /Type1 /Name /F1 /BaseFont /Helvetica-Bold /Encoding /WinAnsiEncoding >> endobj 9 0 obj << /Type /Font /Subtype /Type1 /Name /F2 /BaseFont /Helvetica /Encoding /WinAnsiEncoding >> endobj 10 0 obj << /Type /Font /Subtype /Type1 /Name /F3 /BaseFont /Helvetica-Oblique /Encoding /WinAnsiEncoding >> endobj 11 0 obj << /Type /Font /Subtype /Type1 /Name /F4 /BaseFont /Helvetica-BoldOblique /Encoding /WinAnsiEncoding >> endobj 12 0 obj << /Type /Annot /Subtype /Link /A 13 0 R /Border [0 0 0] /H /I /Rect [ 326.1107 450.2776 379.1297 459.4351 ] >> endobj 13 0 obj << /Type /Action /S /URI /URI (http://my.sun.ac.za) >> endobj 14 0 obj << /Type /Annot /Subtype /Link /A 15 0 R /Border [0 0 0] /H /I /Rect [ 192.5777 324.3766 247.0907 333.5341 ] >> endobj 15 0 obj << /Type /Action /S /URI /URI (http://blogs.sun.ac.za/it/files/2020/06/Excel-course.pdf) >> endobj xref 0 16 0000000000 65535 f 0000000008 00000 n 0000000073 00000 n 0000000119 00000 n 0000000305 00000 n 0000000334 00000 n 0000000469 00000 n 0000000558 00000 n 0000004043 00000 n 0000004155 00000 n 0000004262 00000 n 0000004378 00000 n 0000004498 00000 n 0000004626 00000 n 0000004697 00000 n 0000004825 00000 n trailer << /Size 16 /Root 1 0 R /Info 5 0 R >> startxref 4933 %%EOF Training « Informasietegnologie
Language:
SEARCH
  • Recent Posts

  • Categories

  • Archives

Training

3 day online Excel course

Monday, May 3rd, 2021

Due to Covid restrictions training will still be hosted online through our training partner Stellietech.

The following course dates are available on Sun-e-hr for staff members to enrol.

10-12 May 2021
17-19 May 2021
5-7 June 2021
7-9 June 2021
2-4 August 2021

Should you be interested in attending you must please apply via the Sun-HR System by following the steps below:

>employee self-service
     >>training and development
             >>>learner home
                     >>>>Information Technology
                                >>>>>Online Excel course

COURSE OUTLINE:

Import Data and Navigate workbooks

  • Import Data from Text Files
  • Import Data from CSV Files
  • Search for Data
  • Navigate to workbook Elements

Format worksheets and workbooks

  • Modify Page Setup
  • Adjust Row Height and Column Width.
  • Customise Headers and Footers

Customise Options and Views

  • Customise the Quick Access Toolbar
  • Explore Workbook Views
  • Freeze Rows and Columns
  • Change Window View
  • Modify Basic Workbook Properties
  • Display Formulas

Configure Content for Collaboration.

  • Set a Print Area
  • Save in Alternative File Formats
  • Configure Print Settings
  • Inspect Workbook for Issues.

Manipulate Data in Worksheets

  • Use Special Paste Options
  • Use Autofill to Fill Cells
  • Insert and Delete Rows and Columns
  • Insert and Delete Cells

Format Cells and Ranges

  • Merge and Unmerge Cells
  • Alignment, Orientation, and Indentation
  • Use the Format Painter
  • Wrap Text Within Cells
  • Apply Number Formats

 

 

Error reporting FAQs

Wednesday, October 7th, 2020

How do I report an IT problem, request or enquiry?

Option 1
Log a service request on our ICT Partner Portal
 with the following information:

1. Description of problem
2. Telephone number
3. Room Number
4. Department and building
5. Asset number of computer, laptop, printer, etc.

Requests will be logged automatically and reference number sent via email.

For video instructions on how to log a request on the ICT Partner Portal, click here. More information on our Service Catalogue.

Option 2
Contact the IT Service Desk – 021 808 4367

We require username and asset number in order to assist OR leave a voicemail message.


How do I follow up on the IT request I have logged?

Whether you have called the IT Service Desk at 0218084367, sent an email to help@sun.ac.za or logged a request via the ICT Partner Portal at https://servicedesk.sun.ac.za you can do the following:

  1. Log in at https://servicedesk.sun.ac.za with your username and password.
  2. Select: Requests, My requests. The status of all the requests that you have raised will be displayed.

How do I follow up if I sent an email to help@sun.ac.za?

If you send an email to help@sun.ac.za it automatically logs a request on the IT Service Portal. You can check on the status of your request as follows:

  1. Log in at https://servicedesk.sun.ac.za with your username and password.
  2.  Select: Requests, My requests. The status of all your requests will be displayed.

How do I follow up on a request I reported by calling the IT Contact Centre?

If you call the IT Contact Centre, the service agent will log a request on your behalf on the IT Service Portal. You can check on the status of your request as follow:

  1. Log in at https://servicedesk.sun.ac.za with your username and password.
  2. Select: Requests, My requests. The status of all your requests will be displayed.

Can you follow up on a request emailing help@sun.ac.za again?

If your request have already been logged and you have a reference number, please do not send another email to help@sun.ac.za. This will log a second, duplicate request which will only clog up the system and cause confusion. The same goes for replying to emails from help@sun.ac.za. Rather click on the request number and add your comment on the system.


How do I add a comment to my request?

  1. Log in at https://servicedesk.sun.ac.za with your username and password.
  2. Select: Requests, My requestsThe status of all the requests that you have raised will be displayed.
  3. Click on the reference number of a request to see its details.
  4. Type your comment in the text box and click on Add. The comment will be added to the request. You can also add screen shots for clarification

What does the different status options mean?

WAITING ON SUPPORT =you are waiting for a response / feedback from IT regarding your request.

WAITING ON CUSTOMER =IT is waiting on a response / feedback from you regarding your request.

IN PROGRESS = your request is being attended to.

ESCALATED =your request is escalated for further investigation.

RESOLVED =your request has been resolved.

CLOSED = your request has been closed.

 

 

Online Excel training now available

Monday, June 15th, 2020

If you want to brush up on your Excel skills, we have just the solution for you. 

You can now do an online Excel course which covers all the content of Microsoft Office Excel 2019 needed to become internationally certified. It also aims to help with the navigation of Excel within the office 2019 and 365 environment.

The course takes place over four days and there are fixed training periods you can choose from. The next session takes place 24 to 27 August.

The only prerequisites are that you are computer literate, you have a desktop or laptop, Office365 and an internet connection.

To enrol for the course, you can register on SUN-e-HR. Browse to my.sun.ac.za, click on the SUN-e-HR tab and log in with your sun account. After logging in, you can go to
Training and development-> Learner Home->Information Technology and the Excel course will show there.

As soon as you’ve registered StellieTech, the company responsible for the training will contact you. Their trainers will follow along with your training progress and assist you to make sure you are on track throughout the programme.

The training material that will be covered is exactly the same as the material covered in StellieTech training centres. All aligned to the global industry standard and internationally accredited certification. On the platform, you will find their pre-assessments, training videos, practice simulations, post-assessments, and downloadable workbooks & follow along files. Everything is clearly laid out in the platform and very user friendly. 

More detailed information on the Excel-course.

Online survey tool for SU staff and students

Tuesday, May 12th, 2020

 

The web-based e-Survey service (SUNSurveys) is available to support academic staff and students of the University of Stellenbosch using online surveys for their academic research. SUNsurveys is also regularly used for staff opinion polls, voting and service delivery surveys.

Information Technology uses Checkbox as platform for our surveys. Checkbox is an intuitive survey creation tool with real-time reporting which allows for surveys to be customised. 

To register for use on Checkbox and send out official Stellenbosch University surveys, you can apply for the service online. More information on our Service Catalogue.

Once you have registered, support will be provided throughout to enable you to set up your survey, as well as training if needed. Additionally Checkbox has detailed help guides which will assist you will any potential problems you may encounter.

Take note that before you are allowed to send out a survey for research purposes, you will need institutional permission. Full information on the process can be found on the Information Governance website 

If you have any enquiries, please log a request on our ICT Partner Portal at ICT Partner Portal.

Free digital literacy training

Tuesday, October 1st, 2019

Our training service provider, StellieTech is currently offering a 3 Day Digital Literacy Course (see below for more detail on content, requirements, etc.)

The course is free to all SU staff, but space is limited, so register as soon as possible if you’re interested.

To register, go Sun e hr-> SUN Employee Self service-> Training and Development-> Learner Home-> Information Technology and the course will be listed there.

 


 

Duration: 3 Days

Recommended Prerequisites: Basic computer skills

Certificate of training: StellieTech Certificate of Completion

Assessments: Graded pre and post assessments between lessons.

Overview: This course aims to equip the learner with the knowledge and appreciation of the business environment and to empower them to be efficient and effective in the office.

Course Objectives:

·         Gain an insight into working with the internet and being able to use these skills in the workplace.

·         Learning how to be an effective assistant by using technology to enhance your productivity.

·         Computer training and basic tasks needed as a certified computer user.Course Information

Course Outline

Session 1: Working with the Internet

  • Internet
  • Navigation and Media Literacy
  • Browser Functionality
  • Rights and Usage
  • Email Clients
  • Calendaring
  • Communication Methods
  • Digital Citizenship

Session 2: Fundamental basics

  • Hardware
  • Internet Basics
  • Mobile Devices
  • Software Architecture
  • File and Software Management
  • Troubleshooting Basics
 

© 2013-2021 Disclaimer: The views and opinions expressed in this page are strictly those of the page author(s) and content contributor(s). The contents of this page have not been reviewed or approved by Stellenbosch University.