Computer Courses: Microsoft Office, Excel & PC Skills
These computer courses are for people who use a computer all day and need to work faster and with fewer errors: administrators, analysts, finance and HR teams, managers who build their own reports, and new staff still finding their way around Windows and Microsoft 365. Every course is hands-on, and on most of the two-day courses delegates spend the second day working on their own files and data.
Courses run from one to five days. Excel, Word, PowerPoint and Outlook follow a clear ladder from Essentials to Advanced, and several two-day courses also run as a one-day version. Training runs in-house at your premises, at BOTI's venue in Sunningdale, Johannesburg, or online. For ChatGPT and Copilot, see Artificial Intelligence & Copilot.
Most popular
- Microsoft Excel Intermediate · 2 days. IF, SUMIFS, XLOOKUP and tables, then pivot tables, conditional formatting and a real departmental report.
- Microsoft Excel Advanced · 2 days. INDEX/MATCH, dynamic arrays, what-if analysis and Power Query, then Power Pivot and a dashboard built on your own data.
- Microsoft Excel Essentials · 2 days. Entering and formatting data, basic formulas and charts, then three working spreadsheets built on delegates' own data.
- Microsoft Power BI Basics · 3 days. Turn spreadsheets and databases into interactive dashboards and business reports.
- Microsoft Word Essentials to Intermediate · 2 days. Formatting, styles and tables, then long documents, mail merge, track changes and your own corporate template.
- Microsoft PowerPoint Essentials to Intermediate · 2 days. Slides, layouts and images, then slide masters, corporate templates, Excel charts and presenter tools.
Showing 1–16 of 38 results
All courses in this category
Computer basics, Word, PowerPoint and Outlook
- Introduction to Computers and Microsoft Office Basics · 2 days (1-day version available). Windows, files and folders, internet and email safety, then first steps in Word, Excel and Outlook.
- Microsoft Office All-in-One · 5 days. Computer basics, then a day each of Word, Excel, and PowerPoint with Outlook.
- Improving Your Typing Skills · 1 day. Move from hunt-and-peck to ten-finger touch typing, measured in words per minute.
- Microsoft Word Essentials to Intermediate · 2 days (1-day version available). Styles, layout and tables, then tables of contents, sections, mail merge and track changes.
- Microsoft Word Advanced: Long Documents, Templates and Automation · 2 days (1-day version available). Styles architecture, references, forms and fields, then templates, building blocks, rules-based mail merge and macros.
- Microsoft PowerPoint Essentials to Intermediate · 2 days (1-day version available). Build clear slides, then corporate templates, charts from Excel and animation used with restraint.
- PowerPoint Advanced with Presentation Skills · 2 days (1-day PowerPoint Advanced available). Design, master templates and data visuals on day 1; structure, delivery and on-camera coaching with your own deck on day 2.
- Microsoft Outlook Essentials to Advanced · 2 days (1-day version available). Mail, calendar, contacts and tasks, then rules, Quick Steps, shared mailboxes and delegation.
- National Certificate: IT End User Computing (SAQA 61591) · for learners already enrolled. Closed to new enrolments; see the accredited route below.
Excel, data and Power BI
- Microsoft Excel Essentials · 2 days (1-day version available). The starting point for people new to spreadsheets.
- Microsoft Excel Intermediate · 2 days (1-day version available). Lookups, conditional totals, data validation and pivot tables.
- Microsoft Excel Advanced · 2 days (1-day version available). Power Query, Power Pivot, what-if analysis and dashboards.
- Microsoft Excel Beginners to Advanced · 3 days. Essentials, Intermediate and Advanced compressed into three days for a cohort.
- Excel Pivot Tables, Dashboards and Power Pivot · 2 days. Pivot tables, slicers and pivot charts, then the Power Pivot data model, DAX measures and a dashboard.
- Advanced Excel and Financial Modelling for Accountants · 2 days. Advanced Excel for finance, then a three-statement model with scenarios and sensitivity tables.
- Excel Macros with VBA · 2 days. Record and edit macros, write VBA with variables and loops, and automate a real report.
- Microsoft Power BI Basics · 3 days. Interactive dashboards and reports from your own data. A 1-day masterclass is available for large groups on request.
- Apply Basic Knowledge of Statistics and Probability · 3 days. Basic statistics and probability used to investigate real-life and business problems.
Project, Visio, SharePoint and Access
- Microsoft Project Essentials to Advanced · 2 days. Tasks, dependencies and resources, then baselines, progress tracking and reports on a real project.
- Microsoft Visio Essentials to Advanced · 2 days. Flowcharts and organisation charts, then data-linked process maps of your own processes.
- Microsoft SharePoint End User (Microsoft 365) · 2 days. Sites, libraries, lists and co-authoring, then permissions, views, Power Automate basics and Teams.
- Microsoft Access Essentials to Intermediate · 2 days. Tables, relationships, forms, queries and reports; delegates build a small working database.
- Microsoft Access Advanced · 2 days. Advanced queries and forms, macros, basic VBA, and splitting and securing a database.
Databases, programming and IT support
- SQL Server Fundamentals and Querying · 3 days. Core SQL Server skills for people who look after databases or write queries against them.
- SQL Server Reporting Services · 2 days. Build, manage and deploy reports straight from SQL Server databases.
- Python Short Course · 3 days. A practical introduction to Python for scripting, automation and data work.
- Python Programming · 5 days. Beginner to advanced Python: coding, data analysis and automation.
- Java Short Course · 3 days. The foundations of Java, a portable, object-oriented programming language.
- CompTIA A+ PC Technician · 5 days. PC hardware, operating systems and troubleshooting; prepares delegates for the CompTIA A+ exam.
- CompTIA Network+ Networking · 4 days. Network concepts, cabling, protocols and connections; prepares delegates for the CompTIA Network+ exam.
Also in this category
- Excellent Customer Service: A Practical Approach · 1 day. Greeting, listening, questioning and resolving customer issues. More customer care courses are in Sales, Marketing & Customer Care.
Accredited route
Accredited computer skills
- The National Certificate: IT End User Computing (SAQA 61591) closed to new enrolments on 30 June 2026. Learners already registered have until 30 June 2029 to complete.
- Its replacement is the set of QCTO End User Computing skills programmes: Basic (SP-240201, NQF 3, 30 credits), Intermediate (SP-240202, NQF 4, 20 credits) and Advanced (SP-240203, NQF 5, 20 credits). BOTI's accreditation to offer them is pending; we will publish the programme pages once it is confirmed. Contact us if you would like to hear when they open.
- See every accredited qualification and skills programme you can enrol in today on Qualifications.
Guides
- The importance of computer literacy in the workplace. Why everyday computer skills matter at work, and where to start.
- Boost your skills and career with Excel mastery. Key Excel formulas for finance and data analysis, with worked examples.
- End user computer training. What end user computing covers, from computer basics to Microsoft Office.
- Microsoft Excel training in Johannesburg. How on-site Excel training works for teams in Johannesburg.
What our clients say
“The facilitator effectively encouraged participation and used practical examples, discussions and interactive activities to ensure that the concepts were understood and could be applied in the workplace.”
“Business Optimization Training Institute facilitated Microsoft Excel Training for our company. The course was efficiently scheduled and planned around our timetable. We were impressed by the quality of training.”
“The training was very informative and practical, leaving our employees feeling confident in their ability to leverage Excel more effectively.”
Frequently asked questions
Which Excel course should my team start with?
Start with Essentials if people are new to formulas. Choose Intermediate if they already write basic formulas and now need lookups, SUMIFS and pivot tables. Advanced suits people who use those every day and want Power Query, Power Pivot and dashboards. If a whole cohort needs all three levels, Excel Beginners to Advanced covers them in three days.
Is there a one-day version?
Yes, for Excel Essentials, Intermediate and Advanced, both Word courses, both PowerPoint courses, Outlook and Introduction to Computers. The two-day version adds a second day in which delegates apply the skills to their own work.
Can you train our team at our offices or online?
Yes. Every course here runs in-house at your premises, at BOTI's venue in Sunningdale, Johannesburg, or online. Tell us how many people need training and where they are, and we will quote for the group.
Are these courses accredited?
No. Apart from the National Certificate listed for enrolled learners, the courses in this category are not accredited. They are delivered as professional skills programmes, and delegates receive a BOTI certificate of attendance. For credit-bearing training, see the accredited route above.
Tell us your team's goal and we will recommend the course
Tell us what your people do in Excel, Word or Outlook today and what you need them to be able to do, and we will recommend the right level and format. Call 011 882 8853 or email [email protected].