Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Occupational Skills Programme: Advanced End User Computing – SP-240203
Quick Look Course Summary:Occupational Skills Programme: Advanced End User Computing – SP-240203
-
Next Public Course Date:
-
Length: 10 day(s)
-
Price: 1 Person Price on request 3 Person Price on request 10 Person Price on request
-
Certification Type:Awaiting QCTO Accreditation
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa
Get Free & personalised
Training Advice
Staff who automate repetitive work, analyse large datasets and build complex documents and presentations – with a QCTO certificate at NQF Level 5.
When staff spend hours formatting long reports by hand, rebuilding the same spreadsheet every month or struggling to make sense of large datasets, the cost adds up. This QCTO skills programme in advanced end user computing – the Occupational Skills Programme: Advanced End User Computing (SP-240203, NQF Level 5, 20 credits) – focuses on high-level word processing, spreadsheets and presentations, in response to growing demand for advanced digital literacy and problem-solving skills.
Learners who have completed the Intermediate programme learn to create and edit complex documents, spreadsheets and presentations, automate tasks, manage and analyse data, and collaborate securely. That means long documents with custom styles, tables of contents, indexes, mail merge and macros; spreadsheets with array and nested formulas, pivot tables, macros and VBA, KPI dashboards, scenario analysis and links to external data; and presentations built for interactivity, remote delivery and accessibility.
It is the third of three QCTO end user computing skills programmes, developed with the MICT SETA as Quality Partner and linked to the occupation Computer Operator. BOTI runs it as practical two-day blocks on the core applications, followed by an integration and assessment block that ends in a written and practical final assessment set, run and moderated by BOTI under QCTO rules. BOTI's accreditation for this QCTO skills programme is awaiting the QCTO's decision. Enrolment opens when accreditation is confirmed; enquiries and bookings for later dates are welcome.
Why this course
For your organisation
- Long and complex documents produced to a defined house style, with mail merge, macros and templates taking over repetitive work
- Large datasets cleaned, analysed and summarised with advanced formulas, pivot tables, scenario analysis and KPI dashboards
- Presentations that draw on other software, hold attention and can be delivered remotely
- Documents and data protected with passwords, permissions, digital signatures and two-factor authentication
- A registered QCTO credential of 20 credits at NQF Level 5
For your delegates
- A QCTO skills programme certificate: 20 credits at NQF Level 5
- Automation skills: macros, VBA and custom templates
- Data analysis skills that save hours of manual work
- Confidence presenting and collaborating remotely
What delegates will be able to do
- Define a document style with a custom style sheet and use advanced formatting, section breaks and page numbering
- Build long documents with tables of contents, indexes, footnotes, cross-references, bookmarks and mail merge
- Automate repetitive tasks with macros, VBA and custom templates
- Analyse data with array, conditional and nested formulas, pivot tables, scenario analysis, goal seek and regression
- Present data visually with custom charts, trend lines, data bars, colour scales and KPI dashboards
- Connect spreadsheets to databases and other external data sources
- Storyboard and deliver interactive presentations with multimedia, motion paths, custom shows and presenter view
- Collaborate securely through co-authoring, video conferencing and cloud storage, with passwords, permissions and two-factor authentication
Who should attend
Staff in accounting, finance, marketing, human resources, project management and administration who build complex documents, analyse data or present information; executive assistants and office managers; trainers and technical writers; entrepreneurs and small business owners; government employees; and graduates entering the job market. Entry: completion of Intermediate End User Computing (SP-240202), described in the curriculum as an NQF Level 3 qualification with intermediate end user computing skills, or access through recognition of prior learning (RPL).
Course outline
Days 1-2 – Advanced word processing (Microsoft Word)
Advanced word processing concepts (Knowledge Module 900240-000-00-KM-01, 4 credits)
- Custom styles, section breaks and advanced page numbering
- Tables of contents, indexes, footnotes and endnotes
- Track changes, co-authoring, PDF conversion, password protection and digital signatures
- Mail merge, macros and custom templates
- Accessibility features such as alt text
Complex documents in practice (Practical Module 900240-000-00-PM-01, 16 credits)
- A custom style sheet for a defined document style
- Columns, drop caps and text boxes
- Multimedia, advanced tables and charts
- Cross-references, hyperlinks, bookmarks and a table of contents
- Macros and automation, and reviewing with advanced editing tools
Days 3-4 – Advanced spreadsheets (Microsoft Excel)
Advanced formulas and automation
- Planning a spreadsheet for its purpose and audience
- Array, conditional and nested formulas, and functions such as IF, VLOOKUP and SUMIF
- Recording and editing macros, VBA and custom functions
- Connecting to databases and other external data sources
Analysis and visualisation
- Pivot tables for large datasets
- Scenario analysis, goal seek, optimisation and regression analysis
- Conditional formatting, data bars, colour scales, trend lines and custom charts
- KPI dashboards
- Co-authoring, passwords, user permissions, testing and revision
Days 5-6 – Advanced presentations (Microsoft PowerPoint)
Designing for impact
- Storyboarding for purpose and audience
- Custom themes, templates and slide layouts
- Embedded video and audio, animation, motion paths and special effects
- Accessibility in presentations
Interactive and remote delivery
- Hyperlinks, custom slide shows and interactive quizzes
- Real-time polling, audience response and live Q&A
- Presenter view, recording and webinars
- Revising a presentation on feedback
Days 7-8 – Digital communication and collaboration
Working together online
- Advanced messaging, shared documents and co-authoring
- Screen sharing, task management and calendar integration
- Video and audio conferencing
Security and remote work
- Security and privacy, including two-factor authentication and encryption
- Mobile and remote work with VPNs and cloud storage
- Protecting documents, spreadsheets and communications
Days 9-10 – Integration and final assessment
Integration
- Reports that combine documents and data visualisation
- Integrating applications to automate a process
- Cleaning, transforming, analysing and visualising a large dataset
- A presentation that draws on other software
Final Integrated Supervised Assessment (FISA)
- Written: real-life scenarios, up to 1 hour 30 minutes, pass mark 70%
- Practical: a three-hour brief on a computer, with questions from the assessor
- Marked against a rubric with compulsory sections to be declared competent
How it is delivered
Ten contact days, 08:30-16:00, in the same shape as the Intermediate programme at advanced level: two-day blocks on the core applications, followed by an integration and assessment block that ends with the final assessment. The blocks can run on consecutive days or be spread out. There is no work-experience module. Training runs at your offices anywhere in South Africa, at BOTI's venue in Sunningdale, Johannesburg, or live online, for one learner or a group of up to about 20. Every learner works on a computer throughout, and the practical assessment also needs a printer and internet access; laptops with the software can be supplied on request. Learner material is provided. Enrolment opens when BOTI's accreditation for the programme is confirmed.
Frequently asked questions
Is BOTI accredited to deliver this programme?
Not yet. Advanced End User Computing is a QCTO occupational skills programme (SP-240203, NQF Level 5, 20 credits), and BOTI's accreditation for it is awaiting the QCTO's decision. Enrolment opens when accreditation is confirmed; enquiries and bookings for later dates are welcome. Learners found competent in the final assessment receive a certificate issued by the QCTO. The QCTO's last date for enrolment on the programme is 29 February 2030.
What are the entry requirements?
Completion of the Intermediate End User Computing skills programme (SP-240202). Learners without it may gain access through recognition of prior learning (RPL), and learners who already have a module's competencies may be credited for it before the final assessment.
How is it assessed?
Continuously through quizzes, assignments, tests and practical tasks, with a formal assessment at the end of each module. The final assessment has a written part of up to 1 hour 30 minutes (pass mark 70%) and a three-hour practical brief marked against a rubric, with questions from the assessor.
Does it cover macros and VBA?
Yes. Learners record and edit macros, work with VBA and custom functions in spreadsheets, and use macros and custom templates to automate long documents.
Is there a non-accredited option?
Yes. BOTI's advanced Excel, Word and PowerPoint short courses cover single applications without the QCTO assessment; delegates receive a BOTI certificate of attendance.
Related courses
Frequently Asked Questions
Is this course accredited?
Yes. This is one of BOTI's accredited offerings. BOTI is accredited with the Services SETA (accreditation number 12582) and is a QCTO Quality Partner. The qualification or unit standard, its SAQA ID, NQF level and credit value are shown on this page.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Yes. As accredited training it counts toward the skills development element of your B-BBEE scorecard, and it can support Workplace Skills Plan, Annual Training Report and SETA grant claims. Where a learnership applies you may also access the Section 12H tax allowance.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.