Microsoft Training in Cape Town

Microsoft 365 is a comprehensive suite of cloud-based productivity and collaboration tools, incorporating Teams, OneDrive, Planner, and Copilot to streamline modern workplace operations.

This instructor-led training, available online or onsite, is designed for intermediate professionals looking to leverage Microsoft 365 capabilities to enhance productivity, governance, and cross-team collaboration.

Upon completing this course, participants will be equipped to:

• Configure and manage Teams to facilitate effective collaboration and meeting etiquette.
• Utilise OneDrive for secure file storage, sharing, and version control.
• Plan and track workloads using Planner, integrating tasks seamlessly into team workflows.
• Harness Copilot to accelerate document drafting, generate meeting summaries, and derive data insights.

Course Format

• Interactive demonstrations paired with guided, hands-on labs.
• Scenario-based exercises that reflect real-world organizational workflows.
• Practical sessions focusing on configuration, governance, and user adoption best practices.

Customisation Options

• We can tailor examples, governance checklists, and hands-on labs to align with your organization's specific policies and environment.

Microsoft 365 offers a robust suite of tools for building enterprise-grade knowledge management systems. By integrating SharePoint, Teams, Power Automate, and Power BI, organisations can effectively organise, link, and visualise information. This course examines how to design dynamic intranet dashboards, connect various data sources, and implement structured workflows to boost collaboration and knowledge sharing across teams.

This instructor-led, live training (available online or onsite) is designed for advanced-level professionals who wish to develop and manage sophisticated knowledge management frameworks using Microsoft 365 tools.

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

• Design advanced knowledge management systems using Microsoft 365 tools.
• Build interconnected SharePoint sites and Teams channels to facilitate information flow.
• Automate content workflows using Power Automate.
• Develop Power BI dashboards for knowledge visualisation and reporting.
• Optimise governance, access controls, and versioning across shared repositories.

Course Format

• Interactive lectures and discussions.
• Ample exercises and practical implementation opportunities.
• Hands-on configuration within a live Microsoft 365 environment.

Course Customisation Options

• To request bespoke training for this course, please contact us to make arrangements.

Microsoft Intune is a cloud-based endpoint management solution that enables organizations to securely manage users, devices, and applications. It provides comprehensive tools for configuration, compliance, and protection across Windows, macOS, iOS, and Android environments.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level IT professionals who wish to deploy, configure, and manage enterprise devices using Microsoft Intune and related Microsoft 365 technologies.

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

• Implement and manage Microsoft Intune for endpoint management.
• Configure device enrollment, compliance, and security policies.
• Deploy and protect enterprise applications using Intune.
• Integrate Intune with Microsoft 365, Entra ID, and Defender for Endpoint for unified management.

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 customized training for this course, please contact us to arrange.

Microsoft 365 offers a comprehensive suite of integrated productivity tools designed to facilitate collaboration, data-driven insights, and workflow automation through applications such as Excel, Word, PowerPoint, Outlook, and Copilot.

This instructor-led live training, available both online and onsite, targets intermediate-level professionals eager to master Microsoft 365 tools and AI-powered features to enhance decision-making, communication, and overall organisational efficiency.

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

• Apply advanced Excel techniques and automation tools to support business and leadership decisions.
• Design impactful PowerPoint presentations using storytelling and data visualization techniques.
• Create, format, and collaborate on professional documents in Word with the help of Copilot.
• Enhance productivity and time management using Outlook and AI-driven features across Microsoft 365.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and scenario-based practice.
• Practical application using Microsoft 365 tools in a live-lab environment.

Course Customization Options

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

Microsoft To Do is a cloud-based task management tool designed to help individuals and teams organize, prioritize, and manage tasks across devices, with seamless integration into Microsoft 365.

This instructor-led, live training (available online or onsite) is aimed at beginner to intermediate-level professionals who wish to leverage Microsoft To Do not only for personal productivity but also as a powerful collaborative tool integrated with Microsoft 365 applications.

Learning Objectives

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

• Set up and configure Microsoft To Do across devices and integrate it with Microsoft 365.
• Create, organize, and prioritize tasks and lists for both personal and team use.
• Collaborate effectively by sharing lists, assigning tasks, and monitoring progress.
• Enhance workflows by using Microsoft To Do alongside Outlook, Teams, and Planner.
• Apply productivity best practices and advanced techniques for long-term adoption.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and guided labs.
• Practical team collaboration simulations.

Course Customization Options

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

Microsoft To Do is a cloud-based task management application designed to help individuals and teams organize, prioritize, and manage tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to use Microsoft To Do to manage tasks effectively, boost productivity, and collaborate better with teams.

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

• Set up and configure Microsoft To Do for personal and team use.
• Create, organize, and prioritize tasks efficiently.
• Integrate To Do with Outlook, Teams, and other Microsoft 365 tools.
• Apply productivity best practices using To Do features.

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 customized training for this course, please contact us to arrange.

Microsoft System Center Data Protection Manager (DPM) serves as Microsoft’s enterprise-grade backup and recovery solution designed to safeguard workloads including file servers, databases, and virtual machines.

This instructor-led training, available either online or onsite, is tailored for IT professionals with an intermediate skill set who aim to deploy, configure, and manage DPM to secure data and maintain business continuity.

Upon completing this training, participants will be capable of:

• Installing and configuring DPM servers and agents.
• Creating and managing protection groups.
• Executing backup and recovery operations.
• Integrating DPM with other disaster recovery solutions.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical application.
• Hands-on implementation within a live-lab environment.

Course Customisation Options

• To request customised training for this course, please contact us to make arrangements.

This instructor-led, live training in Cape Town (online or onsite) is aimed at beginner-level to intermediate-level business users who wish to improve their productivity and digital collaboration using Microsoft Teams, OneDrive, and Outlook.

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

• Effectively create, manage, and use teams and channels in Microsoft Teams.
• Leverage tags, mentions, and app integrations in Teams to streamline communication.
• Store, organize, and securely share files in OneDrive using best practices.
• Recover documents using version history and collaborate on files in real time.
• Use Outlook for advanced email management and shared calendar scheduling.

This instructor-led, live training in Cape Town (online or on-site) is aimed at beginner to intermediate users who wish to improve team productivity and streamline everyday workflows using Outlook, OneDrive, Teams, Planner, and Forms.

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

• Organise and manage communication effectively with Outlook.
• Store, share, and collaborate on files using OneDrive.
• Conduct meetings, chats, and team collaboration with Microsoft Teams.
• Plan and track tasks efficiently using Microsoft Planner.
• Create and analyse online surveys and quizzes with Microsoft Forms.

Microsoft Exchange Server serves as a robust messaging platform delivering comprehensive email, calendar, contact, and task management capabilities.

This instructor-led live training, available either online or onsite, is designed for intermediate-level IT professionals aiming to install, configure, manage, and troubleshoot Microsoft Exchange Server environments.

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

• Install and configure Microsoft Exchange Server.
• Implement disaster recovery protocols and anti-malware safeguards.
• Configure message transport and execute migration to Exchange Online.
• Troubleshoot technical issues and ensure optimal server availability.

Course Format

• Interactive lectures and group discussions.
• Extensive exercises and practical application.
• Hands-on implementation within a live-lab environment.

Customisation Options

• For those seeking a tailored training programme, please contact us to discuss your specific requirements.

Microsoft OneNote is a digital notebook application designed for organising, sharing, and collaborating on information across teams and devices.

This instructor-led live training (available online or on-site) targets professionals with limited or emerging experience in OneNote who manage or coordinate digital information. The course aims to help participants use Microsoft OneNote effectively to organise notes, coordinate team knowledge, and enhance collaborative workflows.

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

• Organise personal and team notes using notebooks, sections, and pages.
• Share and collaborate in real-time on OneNote content.
• Embed and link files, emails, and meeting notes into a unified workspace.
• Integrate OneNote with Microsoft 365 apps like Teams, Outlook, and Planner.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Microsoft OneNote in sample collaboration scenarios.
• Guided exercises focused on note-taking, content organisation, and teamwork.

Course Customisation Options

• To request a customised training for this course based on your department's workflows or internal tools, please contact us to arrange.

This instructor-led, live training in Cape Town (online or onsite) is designed to assist participants in preparing for the Microsoft Azure Data Engineer certification exam (DP-203).

The curriculum explores the fundamentals of Azure data services and demonstrates how they can be utilised to process, store, and manage data within the cloud. Participants will gain skills in developing data processing solutions using Azure Data Factory, Azure Stream Analytics, and Azure Databricks, as well as working with NoSQL databases via Azure Cosmos DB.

This instructor-led, live training in Cape Town (online or onsite) is designed for beginner-level leadership teams who wish to effectively manage and coordinate tasks using Microsoft Planner and its related tools, leading to improved productivity and collaboration across the organisation.

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

• Effectively create, manage, and track tasks and projects using Microsoft Planner, thereby improving team coordination and project visibility.
• Organise and prioritise individual tasks, share task lists, and collaborate on tasks using Microsoft To Do.
• Utilise Microsoft Loop components for real-time collaboration, seamlessly integrating them into projects and meetings to enhance communication and information sharing among team members.
• Design and manage custom lists tailored to specific project requirements, automate workflows, and integrate Lists with other Microsoft 365 tools for more efficient task tracking.

This instructor-led, live training in Cape Town (online or onsite) is designed for beginner-level business professionals who wish to acquire the skills necessary to utilise Teams, Word, and Excel effectively in a management context.

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

• Gain a comprehensive understanding of Microsoft 365
• Navigate and utilise Microsoft Teams for communication, collaboration, and project management.
• Develop proficiency in creating, formatting, and managing Word documents.
• Use Excel for data entry, manipulation, and analysis.
• Explore how to integrate Microsoft 365 applications for seamless workflows.

This instructor-led, live training in Cape Town (online or on-site) is designed to assist participants in preparing for the Microsoft Azure DevOps Engineer certification exam (AZ-400).

The course explores the fundamentals of DevOps methodologies and their application within the Azure environment. Attendees will gain proficiency in using Azure DevOps to oversee code repositories, construct and manage build and release pipelines, and execute continuous integration and continuous delivery (CI/CD) strategies.

This instructor-led, live training in Cape Town (online or onsite) is designed to help participants prepare for the Microsoft Azure Solutions Architect Expert (AZ-305) certification exam.

The course covers advanced concepts of cloud computing and Azure services. It provides a comprehensive introduction to Azure solutions architecture, including its principles, components, and services. Participants will also learn how to design and deploy Azure solutions using best practices and industry standards.

This course covers the essential methods and best practices aligned with business and technical needs for modelling, visualising, and analysing data using Power BI. It demonstrates how to access and process data from various sources, including both relational and non-relational systems. Participants will also learn how to implement robust security standards and policies across the Power BI ecosystem, covering datasets and groups, as well as how to manage and deploy reports and dashboards for effective sharing and content distribution.

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 to assist participants in preparing for the Microsoft Azure Security Engineer Associate (AZ-500) certification exam.

The course covers various security topics related to Azure, including identity and access management, platform protection, data and application protection, and operations management.

Microsoft System Center Operations Manager (SCOM) is a monitoring solution engineered to guarantee the availability, performance, and reliability of IT services across data centres and applications.

This instructor-led live training (delivered online or onsite) targets intermediate-level IT professionals who wish to deploy, configure, and manage SCOM for enterprise-grade monitoring and alerting.

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

• Install and configure System Center Operations Manager.
• Set up monitoring rules, alerts, and reports.
• Integrate SCOM with other System Center components.
• Troubleshoot and optimize performance in monitored environments.

Course Format

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

Course Customization Options

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

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 intermediate-level IT professionals who wish to manage and secure an organization's IT environment using Microsoft 365.

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

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Manage Microsoft 365 security services such as Microsoft Secure Score, Exchange Online Protection, Safe Attachments, and Safe Links.
• Implement compliance solutions using Microsoft Purview, data loss prevention, and sensitivity labels.

This instructor-led, live training in Cape Town (online or onsite) is designed to help participants prepare for the Microsoft Azure Developer Associate (AZ-204) certification exam.

The course covers the principles of developing Azure solutions, including Azure compute, storage, and security features. It provides a comprehensive introduction to Azure development, covering tools and services for building, testing, and deploying applications.

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 aimed at intermediate-level IT professionals who wish to manage and secure an organisation's IT environment using Microsoft 365.

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

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Apply best practices for Microsoft 365 administration and security.

This instructor-led, live training in Cape Town (delivered online or on-site) is designed to assist participants in preparing for the Microsoft Azure Administrator Associate (AZ-104) certification examination.

The curriculum addresses the essential competencies needed to manage Azure resources, encompassing Azure virtual machines, storage solutions, and Azure network administration.

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.

This instructor-led, live training in Cape Town (online or onsite) is designed to help participants prepare for the Microsoft Azure Fundamentals (AZ-900) certification exam.

The course covers the basic concepts of cloud computing and Azure services. It provides a comprehensive introduction to Azure, including its architecture, pricing and support, and the most commonly used Azure services.

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 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.

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.

About This Course

Over the course of five days, this programme equips you with the essential knowledge and skills required to plan and administer a Microsoft SharePoint 2016 environment. You will learn how to deploy, manage, and troubleshoot your SharePoint setup. The course also provides guidelines, best practices, and key considerations to help you optimise your SharePoint deployment.

This is the first of two courses designed for IT professionals, aligned with the SharePoint 2016 IT Pro certification path.

Audience Profile

This course is targeted at experienced IT professionals keen on learning how to install, configure, deploy, and manage SharePoint 2016 installations in either a data centre or cloud environment.

Typically, students have over one year of hands-on experience* in planning and maintaining SharePoint, alongside two years’ experience with other core technologies that SharePoint relies on. These include Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

A minimally qualified candidate typically:

• Is an IT professional responsible for planning, implementing, and maintaining a multi-server deployment of SharePoint 2016.
• Has a working knowledge of, and preferably hands-on experience with, SharePoint Online.
• Has broad familiarity with SharePoint workloads.
• Has experience with business continuity management, including data backup, restoration, and high availability.
• Has experience with authentication and security technologies.
• Has experience with Windows PowerShell.

* The hands-on or job experience should stem from a solutions-based role where the candidate has worked on multiple solutions within the SharePoint space, including document management, content management, and search.

At Course Completion

• Describe the key features of SharePoint 2016.
• Design an information architecture for a SharePoint 2016 deployment.
• Design a logical architecture for a SharePoint 2016 deployment.
• Design the physical architecture for a SharePoint 2016 deployment.
• Install and configure SharePoint 2016.
• Create and configure web applications and site collections.
• Plan and configure service applications for a SharePoint 2016 deployment.
• Manage users and permissions, and secure content in a SharePoint 2016 deployment.
• Configure authentication in a SharePoint 2016 deployment.
• Configure platform and farm-level security in a SharePoint 2016 deployment.
• Manage information taxonomy in SharePoint web applications and site collections.
• Configure and manage user profiles and audiences.
• Configure and manage the search experience in SharePoint 2016.
• Monitor, maintain, and troubleshoot a SharePoint 2016 deployment.

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.

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.

This course equips IT Professionals with the skills to manage Azure subscriptions, secure identities, administer infrastructure, configure virtual networking, connect Azure to on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor solutions.

Designed for Azure Administrators, this training covers the management, implementation, and monitoring of identity, governance, storage, compute, and virtual networks within a cloud environment. Azure Administrators will learn to provision, size, monitor, and adjust resources as required.

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.

This course is tailored for individuals aspiring to the Microsoft 365 Administrator role who have completed at least one of the Microsoft 365 role-based administrator certification paths.

This five-day instructor-led programme is tailored for IT professionals who already possess some experience with Windows Server. It targets professionals responsible for managing identity, networking, storage, and compute resources using Windows Server 2019, and who need to understand the applicable scenarios, requirements, and options available for Windows Server 2019. The course equips IT professionals with the fundamental administration skills necessary to deploy and support Windows Server 2019 within most organisations.