Microsoft Office Training in Cape Town

This instructor-led, live training in Cape Town (online or onsite) is aimed at This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level business professionals, educators, and marketers who wish to integrate DeepSeek with PowerPoint to automate and optimise their presentations.

By the end of this training, participants will be able to:

• Automate the creation of text-based content in PowerPoint slides using DeepSeek.
• Generate data-driven visuals and infographics powered by DeepSeek models.
• Use AI to summarise long reports and turn them into presentation-ready slides.
• Integrate DeepSeek with PowerPoint for streamlined, dynamic presentations.

Excel is a powerful spreadsheet application designed for data entry, analysis, reporting, and automation.

This instructor-led live training, available online or on-site, is designed for users ranging from beginners to advanced levels who wish to build confidence and proficiency across Excel’s essential, intermediate, and advanced capabilities.

Upon completing this training, participants will be prepared to:

• Work confidently with spreadsheets, formulas, and formatting.
• Utilise intermediate tools such as tables, charts, and conditional logic.
• Apply advanced functions, data analysis features, and automation techniques.
• Create professional worksheets that support business decision-making.

Course Format

• Instructor-led demonstrations and guided explanations.
• Extensive workbook exercises and hands-on practice.
• Practical lab activities using real-world spreadsheet scenarios.

Course Customisation Options

• For tailored coverage based on your department’s workflows, please contact us to arrange a customised version of this course.

This instructor-led, live training in Cape Town (online or onsite) is designed for beginner to intermediate-level professionals seeking to master Microsoft Word, Excel, and PowerPoint to enhance document creation, data analysis, and presentation skills.

Upon completion of this training, participants will be capable of:

• Creating, formatting, and managing documents effectively in Microsoft Word.
• Utilising Excel for data entry, analysis, and visualisation.
• Designing professional and engaging presentations in PowerPoint.
• Exploiting collaboration features across Microsoft Office applications.

Excel is a widely used spreadsheet application for data organisation, analysis, and automation.

This instructor-led, live training (online or onsite) is aimed at intermediate-level Excel users who wish to apply Excel for inventory control, budgeting, reporting, and automation using real-world datasets.

By the end of this training, participants will be able to:

• Use formulas such as SUMIF, IF, VLOOKUP, and SUMIFS for inventory and purchasing scenarios.
• Handle and analyse large datasets of 5,000+ rows efficiently.
• Create and interpret pivot tables for monthly and accumulated tracking.
• Automate repetitive reporting tasks using macros.
• Track material purchases versus consumption with structured templates.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customised training for this course, please contact us to arrange.

This instructor-led, live training in Cape Town (online or onsite) is aimed at anyone who wishes to learn and use the software and services available in the MS Office suite to enhance their work productivity.

By the end of this training, participants will be able to:

• Learn and use the different software in the MS Office suite.
• Enhance work productivity and collaborate effectively using MS Office tools and services.

This instructor-led, live training in Cape Town (online or in-person) is designed for data analysts at beginner to advanced levels who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.

By the end of this training, participants will be able to:

• Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
• Apply advanced formulas, functions, and conditional formatting for data analysis.
• Create and manage pivot tables and charts for data visualisation.
• Use tools like Power Query, Power Pivot, and perform data analysis.
• Automate tasks using macros and VBA to streamline workflows.

This instructor-led, live training in Cape Town (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

By the end of this training, participants will be able to:

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Cape Town (online or onsite) is designed for data analysts or anyone keen to learn how to use Excel to build data models for analysis.

Upon completion of this training, participants will be able to:

• Analyse and resolve business problems using structured problem-solving techniques.
• Navigate Excel tools with confidence.
• Set up, format, and present data effectively.
• Understand the logical structure of Excel models and apply the correct functions.

Microsoft Word serves as a robust word-processing application designed for the creation, formatting, and management of professional-grade documents.

This instructor-led training session, available both online and onsite, targets users ranging from beginner to advanced levels who aim to develop comprehensive skills in creating, editing, formatting, and automating documents within Microsoft Word.

Upon completing this course, participants will be able to:

• Produce professional documents with consistent and polished formatting.
• Utilise intermediate features including styles, templates, and collaborative tools.
• Apply advanced functionalities such as mail merge, reference management, and automation.
• Boost productivity by leveraging Word's advanced layout options and document management capabilities.

Course Format

• Engaging demonstrations coupled with guided instruction.
• Extensive practical exercises and skill-building activities.
• Real-time document creation and refinement within a live training environment.

Course Customisation Options

• Should you require a bespoke version of this training, please contact us to discuss customisation possibilities.

Upon completion of this course, participants will be adept at leveraging advanced data analysis tools, including what-if analysis scenarios and pivot tables. They will also master date and text-processing functions for complex calculations and learn to create and customise macros to streamline spreadsheet tasks.

Excel is a popular spreadsheet program developed by Microsoft. It is used to store, organise, and analyse data in tabular form. Here are some key features and functions of Excel: 1. Spreadsheets: Consists of sheets, where each sheet is an array composed of cells arranged in rows and columns. Allows the creation of multiple sheets within one file, enabling the organisation of various data sets. 2. Calculations and formulas: Enables various mathematical, statistical, and logical calculations using formulas. Includes a wide range of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data formatting and appearance: Provides tools for formatting data, including changing fonts, colours, styles, as well as creating charts, pivot tables, and diagrams. 4. Sorting, filtering, and grouping: Allows sorting data according to specific criteria. Enables filtering data to display only selected information. Capability to group data depending on requirements. 5. Data analysis: Tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros. 6. Data sharing: Facilitates sharing and collaborating on data in real time, allowing multiple users to work on the same data simultaneously. 7. Task automation: Ability to create macros and automate tasks using the VBA (Visual Basic for Applications) programming language. Excel is widely used in various fields, from business to science and education. Its versatile functions allow for data analysis, report creation, budgeting, scheduling, data management, and many other applications.

This instructor-led, live training in Cape Town (online or onsite) is designed for data analysts who want to utilise advanced VBA in Excel for task automation.

Upon completion of this training, participants will be able to:

• Develop advanced object-oriented applications
• Convert text files
• Utilise external data sources
• Integrate external libraries

This instructor-led, live training in Cape Town (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

• Record and edit macros as required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle an event (opening worksheet cell update etc.) by means of the handler.
• Create a form.

This instructor-led, live training in Cape Town (online or on-site) is designed for data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.

By the end of this training, participants will be able to:

• Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
• Use DAX formulas in Power BI for complex calculations.
• Create and use visualizations and charts for particular analysis cases.
• Import with Power View to move from Excel based Power BI to independent Power BI.

Data analytics plays a pivotal role in modern business environments. This course emphasises the development of practical, hands-on data analysis skills. Its primary objective is to equip participants with the ability to provide evidence-based answers to key questions:

What has happened?

• processing and analysing data
• producing informative data visualisations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimising processes

Automate workflows and build robust desktop applications with VBA across Microsoft Excel and Access. This comprehensive VBA training covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.

Microsoft Excel serves as a robust spreadsheet application designed for the organisation, analysis, and visualisation of data.

This instructor-led, live training (available online or onsite) is tailored for beginner-level data analysts who aim to utilise Excel for data analysis and reporting purposes.

Upon completion of this training, participants will be able to:

• Create and manage spreadsheets within Excel.
• Format and organise data to enhance clarity and efficiency.
• Employ formulas and functions to automate calculations.
• Visualise data through the use of charts, tables, and conditional formatting.
• Collaborate and share workbooks securely within Microsoft 365.

Course Format

• Interactive lectures and discussions.
• Numerous exercises and practical sessions.
• Hands-on implementation in a live-lab environment.

Customisation Options for the Course

• To request a bespoke training session for this course, please contact us to arrange accordingly.

This Excel training for financial analysis equips finance professionals with advanced spreadsheet techniques. Topics include lookup functions, search formulas, PivotCharts, conditional formatting, external data workflows, and securities analysis. The course explores practical methods for evaluating the time value of money, identifying market trends, constructing financial forecasting models, and utilising Excel's comprehensive analytical toolkit for complex financial computations and reporting.

Analysing Financial Data in Excel empowers financial analysts and accountants with advanced techniques for automating complex calculations and reports. Covers core principles of financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and external data integration. Dives into Goal Seek, Solver, Analysis ToolPak, and VBA macros for automating recurring workflows. Helps professionals transform raw figures into actionable financial insights and accurate forecasts for strategic planning.

This course expands on the foundational concepts introduced in Microsoft® Office Excel® 2019: Part 1, guiding you towards developing advanced workbooks and worksheets that enhance your comprehension of organisational intelligence. The capacity to analyse vast quantities of data, extract actionable insights, and present these findings to decision-makers is fundamental to building a successful organisation capable of competing at the highest levels.

Learning Objectives

Upon successful completion of this course, you will be equipped to harness the power of data analysis and presentation to facilitate informed and intelligent organisational decision-making.

You will:

• Work with functions.
• Work with lists.
• Analyse data.
• Visualise data with charts.
• Use PivotTables and PivotCharts.

This course provides the foundational knowledge and skills necessary to excel in Microsoft Excel, serving as a stepping stone toward becoming an expert in data manipulation. Excel empowers you to organize, calculate, analyze, review, update, and present data in ways that assist organizational decision-makers in guiding your team effectively. Furthermore, it streamlines these tasks, allowing you to complete them more quickly and efficiently than traditional pen-and-paper methods or non-specialized software would permit.

Learning Objectives

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks to effectively work with and analyze the critical data that drives organizational success.

• You will:
• Get started with Microsoft Office Excel 2019.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Building on the fundamental and intermediate concepts covered in the Microsoft® Office Excel® Basic and Microsoft® Office Excel® Intermediate courses, this module is designed to help you maximise the value of your Excel experience. By mastering the skills to collaborate with colleagues, automate complex or repetitive processes, and apply conditional logic to develop intricate formulas and functions, you will place the full power of Excel within your reach. As you deepen your understanding of how to leverage Excel for heavy lifting, you can dedicate more time to extracting the critical insights you need from the vast volumes of data generated by your organisation.

Learning Objectives

Upon successful completion of this course, you will be equipped to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

• You will:
• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.

This one-day course is tailored for information workers who currently utilise or will be utilising Office 365. The curriculum provides participants with the necessary knowledge and skills to effectively employ Office 365 in their daily operations. Designed around practical, real-world scenarios, the course covers the usage of Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. Upon completion, students will be proficient in navigating Office 365 and leveraging its full suite of features.

Learning Objectives

In this course, you will master the fundamental skills of Word.

• Key competencies include:
• Navigating Word and executing essential tasks such as opening, viewing, editing, saving, and printing documents, alongside configuring application settings.
• Formatting text and paragraphs effectively.
• Carrying out repetitive operations efficiently by utilising tools like Find and Replace, Format Painter, and Styles.
• Improving lists through sorting, renumbering, and customising list styles.
• Creating and formatting tables.
• Inserting graphic objects into documents, including symbols, special characters, illustrations, pictures, and clip art.
• Enhancing the overall appearance of a page via page borders and colours, watermarks, headers and footers, and page layout adjustments.
• Leveraging Word’s features to identify and rectify issues related to spelling, grammar, readability, and accessibility.

TARGET AUDIENCE

This course is designed for individuals who wish to acquire basic Word 2019 skills, including creating, editing, and formatting documents, inserting simple tables, creating lists, and applying various techniques to improve the appearance and accuracy of document content.

Upon completion of this course, participants will be equipped to perform a wide range of calculations with clarity and precision, effectively arranging and presenting their results. They will learn to utilise various mechanisms to streamline and expedite spreadsheet creation, while also safeguarding their calculations and outcomes from unauthorised access.

Participants will master the most efficient methods for creating, consolidating, and managing data. By leveraging a range of tools designed to streamline workflows, you can significantly reduce the time spent on existing tasks and design applications capable of performing new, automated functions.

Participants will gain the skills to produce clean, professional documents, including all types of official correspondence, and effectively utilise basic features that ensure clear and efficient information flow in both concise and extensive documents.

Take command of advanced document workflows by fully leveraging Microsoft Word's capabilities. Gain expertise in customising styles, performing mail merges from external databases, recording macros, and developing templates. Participants will master section-level layout control, dynamic tables of contents, indexes, hyperlinks, content controls, document comparison, and version tracking. This course empowers professionals to construct automated reporting systems, standardised enterprise templates, cross-referenced documents, and SharePoint-integrated workflows.

Elevate your VBA expertise to an intermediate proficiency by mastering custom interfaces, complex data structures, conditional logic, loop constructs, and professional debugging methodologies. This practical Excel VBA training programme focuses on implementing robust error handling, optimising performance, designing VBA UserForms, and automating workflows through real-world scenarios. Designed to bridge the gap between basic macros and advanced automation solutions, it empowers data analysts, reporting specialists, and business professionals to leverage enterprise-grade spreadsheet capabilities.

Achieve mastery in Microsoft Excel through this professional training course, designed to significantly boost your spreadsheet efficiency and productivity. Acquire essential skills such as editing worksheets, managing workbooks, constructing complex formulas with powerful functions, formatting cells, creating professional charts and graphs, utilising PivotTables and data lists, and handling graphic objects. This course is ideal for business analysts, accountants, data handlers, and office professionals aiming to elevate their Excel proficiency from intermediate to expert level. Enhance your data analysis capabilities, streamline reporting workflows, and unlock the full potential of Microsoft Excel for improved decision-making and workplace productivity.

This instructor-led live training in Cape Town (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

This 5-day Advanced Excel for Sales Professionals course is tailored to empower sales teams with the essential skills to manage, analyze, and automate sales data effectively. Participants will master advanced Excel functions, data analysis techniques, and automation tools to improve reporting precision, construct dynamic dashboards, and forecast sales outcomes. Through practical, hands-on exercises, sales professionals will acquire actionable insights into developing interactive sales reports, automating routine tasks, and utilizing advanced utilities such as Power Query, Power Pivot, and Macros. This programme is ideally suited for individuals aiming to harness Excel to propel data-driven sales strategies.

Going beyond the fundamentals of PowerPoint unveils the techniques for creating professional, scalable presentations that truly capture attention. This course explores slide and handout master customization, template development, the use of SmartArt for visual process mapping, and in-depth Excel integration for live-linked data dashboards and charts. It empowers professionals with advanced workflows using add-ins such as Office Timeline and Poll Everywhere to speed up complex deck creation, streamline review processes, and deliver high-impact business presentations.

Professionals aiming to create polished presentations can greatly benefit from advanced slide design techniques that elevate standard content into compelling visual narratives. This course explores the fundamental principles of slide composition, the creation of charts and infographics, and image editing. It also develops practical skills in the visual distribution of elements, the emphasis of critical information, and the personalization of the workspace. Participants will gain actionable strategies for designing clean, impactful slides and delivering confident presentations using structured public speaking methods.

This advanced PowerPoint training programme is tailored for professionals aiming to enhance their presentation abilities and produce striking, visually engaging slides. Over two days, learners will acquire practical expertise in sophisticated PowerPoint capabilities, encompassing business presentation strategies, infographic creation, animation, consistent theme formulation, and the embedding of digital media. Furthermore, the curriculum addresses data analysis and presentation methodologies utilizing the PwC framework, empowering attendees to communicate intricate information clearly to their audiences.

Objective:

Enhancing the ability to create engaging presentations using PowerPoint and other tools

Target Audience:

Sales representatives, consultants, research and teaching staff, managers, teachers, corporate employees, SMEs and public institutions, for whom the challenge is to stand in front of a group of people, say to them, arousing interest

This instructor-led live training in Cape Town (online or onsite) is designed for beginner to intermediate-level business analysts and data analysts who wish to leverage Excel for data analysis and reporting in their projects and daily tasks.

Upon completing this training, participants will be able to:

• Utilise Excel formulas and functions to perform calculations and manipulate data.
• Employ Excel data analysis tools, such as PivotTables, What-If Analysis, and Forecasting, to summarise and visualise data effectively.
• Create and customise data visualisations using Excel charts and graphs.
• Implement Excel data validation and conditional formatting to ensure data quality and highlight key insights.
• Use Excel data import and export features to connect with external data sources and share data with others.

Gain insight into Office 365 Management, covering the essential components of Office 365, strategies for transitioning an organisation to Office 365, configuration techniques, and methods for overseeing Office 365 ProPlus deployments.

Audience profile

This course is tailored for individuals aspiring to the Microsoft 365 Enterprise Admin role who have completed one of the Microsoft 365 role-based administrator certification pathways.

Skills gained

• Office 365 overview
• Transitioning an organisation to Office 365
• Configuring Office 365
• Managing Office 365 ProPlus deployments

This one-day training session is tailored for individuals who utilise SharePoint as power users, acting as SharePoint site owners and/or Site Collection administrators.

Course objectives include:

• Configuring site navigation
• Viewing site activity reports
• Customising lists and libraries
• Working with Site Columns and Site Content Types
• Configuring check-out/check-in, Content Approval, and versioning
• Creating and modifying pages and web part pages

This one-day training session is tailored for individuals who utilise SharePoint as end-users and wish to gain insight into its advanced capabilities. Attendees who require a comprehensive understanding of functions such as team collaboration, document management, and the social aspects of Microsoft SharePoint 2013 should enrol in this course.

This course is ideal for:

• SharePoint Site Owners and users

Course objectives include:

• Managing Sites and Site Collections
• Adding users and groups, and managing security for sites, lists, folders, and items
• Adding and configuring web parts
• Configuring site options, including theme, title, description, and icon

Constructing impactful financial slide presentations serves as the vital link between intricate financial data and executive-level communication, leveraging PowerPoint effectively. This module delves into design methodologies covering slide architecture, treemap and sunburst visualisations, budget chart layouts, and streamlined reporting tables that accentuate essential financial metrics. Participants will learn to master Excel integration for dynamic data manipulation, selectively highlight key figures, and craft persuasive financial narratives that secure stakeholder buy-in.