[:en]

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.

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

[:af]

Weens COVID-regulasies word opleiding steeds aanlyn aangebied met behulp van ons opleidingsvennoot Stellietech.

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

As jy dit graag wil bywoon, doen asseblief aansoek op die Sun-HR stelsel deur die stappe onder te volg:

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

KURSUSRAAMWERK:

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

[:]

[:en]

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.

[:af]

As jy jou Excel-vaardighede wil opskerp het ons net die oplossing vir jou.

Jy kan nou ʼn aanlyn Excel-kursus volg wat al die Microsoft Office Excel 2019 inhoud dek wat jy nodig het om internasionaal gesertifiseer te wees. Dit sal kursusgangers ook help om hulleself te orienteer binne die Office 2019 en 365-omgewing. 

Die kursus vind plaas oor vier dae en daar is vaste opleidingsperiodes waaruit jy kan kies. Die volgende sessie vind 24 tot 27 Augustus plaas.

Die enigste vereistes is dat jy rekenaargeletterd is en oor ʼn tafel- of skootrekenaar, Office365 en ʼn internetverbinding beskik. 

Om in te skryf vir die kursus, kan jy registreer op SUN-e-HR. Navigeer na my.sun.ac.za, kliek op die my.sun.ac.za oortjie en teken aan met jou sun-rekeningdetails. Nadat jy aangeteken het, gaan na Training and development-> Learner Home->Information Technology en die opsie vir die Excel-kursus sal sigbaar wees.

Sodra jy geregistreer is sal StellieTech, die maatskappy verantwoordelik vir die opleiding, jou kontak. Hulle instrukteurs sal saam met jou jou vordering met die opleiding monitor, jou bystaan en sekermaak dat jy op die regte spoor bly met die program.

Die opleidingmateriaal wat gedek word, is presies dieselfde materiaal wat gedek word in StellieTech opleidingsentrums. Al hierdie sentrums voldoen aan globale industriestandaarde en internasionaal geakkrediteerde sertifisering.

Op die platform sal jy julle pre-toetse vind, opleidingsvideo’s, oefen-simulasies, post-toetse en aflaaibare werkboeke. Al die inligting is duidelik uiteengesit op die platform en baie gebruikersvriendelik. 

Meer gedetailleerde inligting oor die Excel-kursus.

[:]