BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Business Institute - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel Business Institute
X-ORIGINAL-URL:https://excelbi.co.za
X-WR-CALDESC:Events for Excel Business Institute
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20260101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20270201T090000
DTEND;TZID=UTC:20270205T130000
DTSTAMP:20261111T182449
CREATED:20260416T083201Z
LAST-MODIFIED:20260416T083201Z
UID:10000897-1801472400-1801832400@excelbi.co.za
SUMMARY:Workshop: PC Support
DESCRIPTION:Overview\nTo equip learners with the practical skills and knowledge to configure\, maintain\, troubleshoot\, and secure end-user computing devices and software within a modern business environment\, while providing effective user support. \nTarget Audience:\nIndividuals pursuing a career in IT support\, career changers\, and current employees looking to formalize their technical support skills. \nOutline\nModule 1: Computer System Configuration\n\nHardware Components: Identification\, function\, and installation of core PC components (CPU\, RAM\, storage\, PSU\, motherboard\, peripherals).\nHardware Compatibility: Understanding form factors\, interfaces (SATA\, NVMe\, PCIe)\, and system requirements.\nOperating System Installation: Clean installation and configuration of Windows and a Linux distribution.\nDriver Management: Sourcing\, installing\, and updating hardware device drivers.\nSystem Configuration: Using BIOS/UEFI firmware and OS tools to optimize system performance and boot settings.\n\nModule 2: User Support and Troubleshooting\n\nTroubleshooting Methodology: Applying a structured approach to problem-solving (e.g.\, Identify the problem\, Establish a theory\, Test\, Plan action\, Implement solution\, Verify functionality\, Document findings).\nDiagnostic Tools: Utilizing built-in OS utilities (e.g.\, Task Manager\, Device Manager\, Event Viewer) and hardware diagnostics.\nCommon Issues: Resolving problems related to boot failures\, blue screens\, performance slowdowns\, and peripheral devices.\nSoft Skills: Developing communication skills\, active listening\, professionalism\, and managing user expectations in a support context.\n\nModule 3: Software Installation and Management\n\nSoftware Types: Understanding application software\, utilities\, and system software.\nInstallation & Configuration: Installing licensed\, freeware\, and web applications; configuring application settings.\nSoftware Management: Using built-in OS tools (Programs and Features) and package managers for installation and uninstallation.\nUpdate Management: Configuring and deploying software updates and patches for operating systems and applications.\nVirtualization Basics: Introduction to using application virtualization for software compatibility and testing.\n\nModule 4: Network Essentials\n\nNetworking Fundamentals: Core concepts of TCP/IP\, IPv4 addressing\, DNS\, DHCP\, and gateway.\nNetwork Setup: Configuring wired and wireless (Wi-Fi) network connections on a client PC.\nNetwork Troubleshooting: Using command-line tools (ipconfig\, ping\, nslookup\, tracert) to diagnose connectivity problems.\nResource Sharing: Setting up and connecting to shared network resources like printers and file shares.\nRemote Access: Using remote desktop tools to provide remote support to users.\n\nModule 5: Security Practices\n\nSecurity Fundamentals: Understanding core principles (Confidentiality\, Integrity\, Availability) and common threats (malware\, phishing\, social engineering).\nEndpoint Protection: Installing\, configuring\, and updating antivirus/anti-malware software.\nSystem Hardening: Configuring user account controls (UAC)\, firewall settings\, and enabling disk encryption (e.g.\, BitLocker).\nAccess Control: Managing user accounts\, groups\, and permissions; implementing strong password policies.\nData Security: Educating users on security best practices; performing secure data disposal and backups.
URL:https://excelbi.co.za/event/workshop-pc-support/2027-02-01/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/pc-support.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270201T090000
DTEND;TZID=UTC:20270205T130000
DTSTAMP:20261111T182449
CREATED:20260416T093128Z
LAST-MODIFIED:20260416T093128Z
UID:10000966-1801472400-1801832400@excelbi.co.za
SUMMARY:Certificate: Business Analysis
DESCRIPTION:Course Overview:\nThis course provides the foundational methodologies and practical skills to analyze business needs\, define requirements\, and support effective solution implementation. \nTarget Audience:\nAspiring Business Analysts\, Project Coordinators\, Career Changers. \nOutline\nModule 1: Introduction to Business Analysis\n\nRole and Value of the Business Analyst.\nThe Business Analysis Lifecycle.\nCore Concepts: Requirements\, Stakeholders\, Solutions.\nIntroduction to Key Frameworks (BABOK®).\n\nModule 2: Techniques for Gathering Requirements\n\nElicitation Techniques: Interviews\, Workshops\, Surveys.\nDocumenting User Stories and Acceptance Criteria.\nAnalyzing and Prioritizing Requirements.\nManaging Requirements Traceability.\n\nModule 3: Process Analysis and Design\n\nMapping As-Is Processes.\nIdentifying Process Inefficiencies and Improvements.\nDesigning To-Be Processes.\nUsing Standard Notation (e.g.\, BPMN).\n\nModule 4: Solution Evaluation and Implementation\n\nValidating Solutions Against Requirements.\nSupporting User Acceptance Testing (UAT).\nPlanning for Change Management.\nEvaluating Solution Performance.\n\nModule 5: Communication and Documentation Skills\n\nStakeholder Analysis and Engagement.\nCreating Effective Requirements Documentation.\nVisual Modeling for Communication.\nFacilitating Meetings and Presentations.
URL:https://excelbi.co.za/event/certificate-business-analysis/2027-02-01/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Business Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Business-Analysis-1.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270201T090000
DTEND;TZID=UTC:20270212T130000
DTSTAMP:20261111T182449
CREATED:20260415T094811Z
LAST-MODIFIED:20260415T094811Z
UID:10000499-1801472400-1802437200@excelbi.co.za
SUMMARY:Mastering Project Leadership and Communication
DESCRIPTION:Overview\nThis advanced course moves beyond traditional project management to focus on the human side of delivering projects. Develop the essential leadership\, communication\, and influence skills required to inspire high-performance teams\, navigate complex conflicts\, manage diverse stakeholders\, and lead successful organizational change. \nTarget Audience: \nSenior Project Managers\, Program Managers\, Project Leaders\, and anyone tasked with leading project teams and managing key stakeholder relationships in complex environments. \nUpon completion\, students will be able to: \n\nAdapt leadership styles to motivate teams and navigate different project situations.\nApply advanced conflict resolution and negotiation techniques to achieve project goals.\nDevelop and execute a sophisticated stakeholder engagement and influence plan.\nImplement effective communication strategies for co-located\, hybrid\, and fully virtual teams.\nFoster a collaborative\, accountable\, and high-performing team culture.\nLead people through project-related change and drive innovation.\n\nOutline\nModule 1: Advanced Leadership Styles and Their Application to Projects \n\nLeadership vs. Management: Distinguishing between managing tasks and leading people.\nSituational Leadership® Model: Adapting your leadership style (Directing\, Coaching\, Supporting\, Delegating) based on team maturity and task complexity.\nServant Leadership & Transformational Leadership: Applying frameworks that focus on empowering teams and inspiring change.\n\nModule 2: Conflict Resolution and Negotiation Strategies \n\nSources of Project Conflict: Identifying common causes (e.g.\, schedules\, priorities\, resources\, personality).\nConflict Resolution Models: Applying the Thomas-Kilmann Conflict Mode Instrument (TKI) to choose the right approach (Competing\, Collaborating\, Compromising\, etc.).\nPrincipled Negotiation: Using strategies from “Getting to Yes” (focus on interests\, not positions) to achieve win-win outcomes.\n\nModule 3: Stakeholder Engagement and Influence Skills \n\nStakeholder Analysis & Mapping: Advanced techniques for identifying power\, interest\, influence\, and attitude.\nDeveloping Influence Strategies: Building coalitions\, crafting compelling arguments\, and using the Cialdini principles of persuasion (e.g.\, reciprocity\, scarcity\, authority).\nCreating a Stakeholder Engagement Plan: Moving from analysis to actionable engagement activities.\n\nModule 4: Advanced Communication Strategies for Virtual Teams \n\nThe Virtual Communication Challenge: Addressing proximity bias\, building trust\, and fostering inclusion remotely.\nChoosing the Right Channel: Matching the communication medium (email\, video\, chat\, collaborative tools) to the message’s complexity and sensitivity.\nRunning Effective Virtual Meetings: Designing and facilitating engaging virtual meetings that achieve their objectives.\n\nModule 5: Building and Sustaining High-Performance Project Teams \n\nTuckman’s Model Deep Dive: Actively guiding a team through Forming\, Storming\, Norming\, and Performing stages.\nCreating Psychological Safety: Establishing a team culture where members feel safe to take risks and voice opinions.\nMotivation & Recognition: Applying motivational theories (e.g.\, Herzberg\, Pink’s Drive) and designing effective recognition systems for project teams.\n\nModule 6: Leading Change and Driving Innovation Within Projects \n\nChange Management Models: Applying frameworks like ADKAR (Awareness\, Desire\, Knowledge\, Ability\, Reinforcement) to project initiatives.\nOvercoming Resistance: Identifying the root causes of resistance and developing strategies to address them.
URL:https://excelbi.co.za/event/mastering-project-leadership-and-communication/2027-02-01/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Mastering-Project-Leadership-and-Communication.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270202T090000
DTEND;TZID=UTC:20270203T130000
DTSTAMP:20261111T182449
CREATED:20260415T073906Z
LAST-MODIFIED:20260415T073906Z
UID:10000330-1801558800-1801659600@excelbi.co.za
SUMMARY:Microsoft Outlook Fundamentals
DESCRIPTION:Course Overview:\nThis practical course equips you with the essential skills to use Microsoft Outlook effectively. Learn to navigate the interface\, manage your inbox\, organize contacts\, schedule meetings\, and track tasks to boost your daily productivity. \nTarget Audience:\nOffice workers\, students\, administrative staff\, and anyone new to Outlook or looking to strengthen their foundational skills. \nUpon completion\, students will be able to:\n\nConfidently navigate and customize the Outlook interface.\nCompose\, format\, and send professional emails\, including attachments.\nImplement strategies to organize and find emails efficiently.\nCreate\, manage\, and categorize contacts and contact groups.\nSchedule\, update\, and respond to calendar appointments and meetings.\nCreate and track personal tasks and reminders.\n\nOutline\nModule 1: Navigating the Outlook Interface \n\nThe Outlook Ecosystem: Overview of Mail\, Calendar\, People (Contacts)\, Tasks\, and Notes.\nThe Ribbon and Folders Pane: Understanding context-sensitive tabs and navigating your folder hierarchy.\nCustomizing Your View: Using the Reading Pane\, arranging messages\, and adjusting layout and view settings.\nPractical Activity: Navigate to each main module (Mail\, Calendar\, Contacts) and customize the Reading Pane location.\n\nModule 2: Composing and Sending Emails \n\nCreating a New Message: Using the To;\, Cc;\, and Bcc; fields appropriately. Writing clear subject lines.\nFormatting & Professionalism: Basic text formatting\, adding signatures\, and setting importance levels.\nWorking with Attachments: Attaching files and items from OneDrive. Understanding file size limits.\n\nModule 3: Organizing Emails with Folders \n\nFolder Management: Creating\, renaming\, and moving folders and subfolders for project- or sender-based organization.\nRules: Introduction to creating basic rules to automatically move\, flag\, or delete incoming messages.\nSearch and Filters: Using the instant search box and the Search Tools tab to find old emails quickly.\n\nModule 4: Using Contacts and Address Book \n\nCreating & Editing Contacts: Adding new contacts manually\, filling in key details\, and adding a photo.\nContact Groups (Lists): Creating a distribution list to send emails to a group of people at once.\nFinding and Using Contacts: Using the Address Book while composing an email and categorizing contacts for easy sorting.\n\nModule 5: Calendar Management Basics \n\nDifferent Appointment Types: Creating new appointments (for yourself) and meetings (inviting others).\nScheduling Assistant: Using the Scheduling Assistant to find a time that works for all attendees.\nManaging Invitations: Responding to meeting invites (Accept\, Tentative\, Decline) and adding notes.\n\nModule 6: Setting Tasks and Reminders \n\nThe Tasks Module: Creating a new task\, setting a due date\, priority\, and status.\nFlags and Reminders: Using the Follow Up flag to create quick email-based reminders.\nThe To-Do Bar: Understanding how Tasks\, Flagged Emails\, and your Calendar integrate in the To-Do Bar view.
URL:https://excelbi.co.za/event/microsoft-outlook-fundamentals/2027-02-02/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Outlook-Basic.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270208T090000
DTEND;TZID=UTC:20270212T130000
DTSTAMP:20261111T182449
CREATED:20260415T080424Z
LAST-MODIFIED:20260415T080424Z
UID:10000428-1802077200-1802437200@excelbi.co.za
SUMMARY:Introduction to Project Management
DESCRIPTION:Overview\nThis foundational course provides the essential principles and practices of project management. Learn the project life cycle\, key terminology\, and core skills needed to initiate\, plan\, and execute projects successfully\, on time and within budget. \nTarget Audience \nAspiring project managers\, team members\, students\, and professionals in any industry who want to understand the discipline of project management. \nUpon completion\, students will be able to: \n\nDefine project management and articulate its value and key concepts.\nIdentify and describe the phases of a standard project life cycle.\nUnderstand the core responsibilities and skills of a project manager.\nUtilize basic project management tools for planning and tracking.\nDevelop a simple project plan\, schedule\, and budget.\nIdentify basic project risks and understand mitigation strategies.\n\nOutline\nModule 1: Definition and Importance of Project Management \n\nWhat is a Project?: Distinguishing projects from ongoing operations.\nWhat is Project Management?: Defining the discipline and its key objectives (scope\, time\, cost\, quality).\nThe Value of PM: Understanding how effective PM delivers benefits and reduces risks for organizations.\n\nModule 2: Project Life Cycle and Key Phases \n\nThe Project Life Cycle: Overview of the typical phases: Initiation\, Planning\, Execution\, Monitoring & Controlling\, Closing.\nInitiation Phase: Defining the project goal\, scope\, and stakeholders. The project charter.\nClosing Phase: Handing over the final deliverable\, releasing resources\, and conducting lessons learned.\n\nModule 3: Roles and Responsibilities of a Project Manager \n\nThe PM’s Key Duties: Leading the team\, managing communication\, mitigating risks\, managing the triple constraint (scope\, time\, cost).\nEssential Skills: Communication\, leadership\, negotiation\, problem-solving\, and stakeholder management.\nAuthority vs. Responsibility: Understanding the challenge of leading projects without direct authority over team members.\n\nModule 4: Basic Project Management Tools and Techniques \n\nVisual Tools: Introduction to Gantt charts\, Kanban boards\, and calendars for tracking progress.\nCommunication Tools: The RACI chart (Responsible\, Accountable\, Consulted\, Informed) for defining roles.\nDocumentation: Overview of key documents like the project charter\, scope statement\, and status reports.\n\nModule 5: Introduction to Project Planning and Scheduling \n\nWork Breakdown Structure (WBS): Decomposing project deliverables into smaller\, manageable tasks.\nSequencing and Dependencies: Determining the order of tasks and which tasks depend on others.\nEstimating Duration: Techniques for estimating how long tasks will take.\n\nModule 6: Overview of Budgeting and Resource Allocation \n\nCost Estimating: Top-down vs. bottom-up estimating techniques.\nCreating a Baseline Budget: Aggregating the estimated costs of individual activities to establish a total budget.\nResource Allocation: Identifying what people\, equipment\, and materials are needed and when.\n\nModule 7: Introduction to Risk Management \n\nIdentifying Risks: Brainstorming techniques to find potential threats and opportunities.\nRisk Analysis: Assessing the probability and impact of risks (Qualitative Analysis).\n\nRisk Response Planning: Basic strategies for dealing with risks: Avoid\, Mitigate\, Transfer\, Accept.
URL:https://excelbi.co.za/event/introduction-to-project-management/2027-02-08/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Introduction-to-Project-Management.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270208T090000
DTEND;TZID=UTC:20270212T130000
DTSTAMP:20261111T182449
CREATED:20260415T123727Z
LAST-MODIFIED:20260415T123727Z
UID:10000598-1802077200-1802437200@excelbi.co.za
SUMMARY:Certificate: Information Technology: Systems Support
DESCRIPTION:Course Overview:\nThis certificate provides the foundational knowledge and hands-on skills required to install\, maintain\, troubleshoot\, and secure computer systems and networks in a business environment. Graduates will be prepared for roles such as Systems Support Specialist\, Network Administrator\, and IT Technician. \nTarget Audience:\nIndividuals aiming to start or advance a career in corporate IT support and system administration. \nOutline\nModule 1: IT Support Fundamentals\n\nIntroduction to Enterprise IT Environments\nCore Hardware Components and Server Architecture\nOperating Systems Overview (Windows Server\, Linux)\nVirtualization Fundamentals (Hyper-V\, VMware)\nIT Service Management (ITSM) and ITIL Foundations\nDocumentation and Standard Operating Procedures\n\nModule 2: Network and System Administration\n\nTCP/IP Networking and Subnetting\nConfiguring Network Services (DHCP\, DNS)\nDirectory Services (Microsoft Active Directory)\nFile and Print Server Management\nNetwork Infrastructure (Switches\, Routers\, Firewalls)\nIntroduction to Cloud Services (IaaS\, SaaS)\n\nModule 3: Software and Hardware Troubleshooting \n\nAdvanced Troubleshooting Methodology\nDiagnosing OS and Application Failures\nHardware Diagnostics and RAID Configuration\nRemote Troubleshooting Tools and Techniques\nScripting for Automation and Remediation (PowerShell/Bash)\nPerformance Monitoring and Analysis\n\nModule 4: User and Access Management\n\nUser Account Lifecycle Management\nGroup Policy Management (GPOs)\nPrinciples of Least Privilege and Role-Based Access Control (RBAC)\nManaging Shared Resources and Permissions (NTFS/Shared Permissions)\nAuthentication Methods (Multi-Factor Authentication)\n\nModule 5: Security and Backup Solutions\n\nCybersecurity Threats and Vulnerability Management\nImplementing Local and Network Security Policies\nFundamentals of Firewall and Endpoint Security\nData Backup Strategies and Technologies\nDisaster Recovery Planning and Execution\nSecurity Auditing and Log Analysis
URL:https://excelbi.co.za/event/certificate-information-technology-systems-support/2027-02-08/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/IT-systems-support.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270209T090000
DTEND;TZID=UTC:20270210T130000
DTSTAMP:20261111T182449
CREATED:20260415T064620Z
LAST-MODIFIED:20260415T064620Z
UID:10000005-1802163600-1802264400@excelbi.co.za
SUMMARY:Microsoft Excel Basics
DESCRIPTION:Microsoft Excel Basics\nCourse Overview\nThis beginner-friendly course introduces learners to the essential features of Microsoft Excel. Participants will learn how to navigate the Excel interface\, enter and edit data\, and use basic formulas and functions to perform calculations. The course also covers creating and formatting tables\, building simple charts to visualize data\, and applying basic sorting and filtering techniques to manage information effectively. \nBy the end of the course\, learners will be able to confidently create and organize spreadsheets\, apply simple calculations\, and present data in a clear\, professional format. \nOutline\nModule 1: Getting Started with Excel \n\nOverview of Microsoft Excel and its uses\nNavigating the Excel interface (Ribbon\, Tabs\, Workbook\, Worksheet)\nUnderstanding cells\, rows\, and columns\nCustomizing the Quick Access Toolbar\n\nModule 2: Entering and Editing Data \n\nInputting text\, numbers\, and dates\nEditing and clearing cell content\nUsing AutoFill and Flash Fill\nUndo\, Redo\, and basic shortcuts\n\nModule 3: Basic Formulas and Functions \n\nIntroduction to formulas (equals sign\, cell references)\nPerforming basic calculations (addition\, subtraction\, multiplication\, division)\nCommon functions: SUM\, AVERAGE\, MIN\, MAX\nUnderstanding relative vs. absolute cell references\n\nModule 4: Creating and Formatting Tables \n\nCreating simple data tables\nApplying table styles and formatting\nAdjusting column width and row height\nMerging cells\, borders\, and shading\nFormatting numbers (currency\, percentages\, decimals)\n\nModule 5: Introduction to Charts \n\nCreating basic charts (column\, line\, pie)\nCustomizing chart elements (titles\, legends\, labels)\nChanging chart styles and layouts\nChoosing the right chart for your data\n\nModule 6: Sorting and Filtering Data \n\nSorting data (ascending\, descending\, custom sort)\nApplying filters to view specific data\nUsing AutoFilter options\nClearing filters and resets\n\nFinal Practice & Wrap-Up \n\nBuilding a simple data sheet with formulas\, table formatting\, and a chart\nReviewing key features covered\n\nQ&A and further learning resources
URL:https://excelbi.co.za/event/microsoft-excel-basics/2027-02-09/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/03/Excel-Basic.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270209T090000
DTEND;TZID=UTC:20270210T130000
DTSTAMP:20261111T182449
CREATED:20260415T074155Z
LAST-MODIFIED:20260415T075859Z
UID:10000349-1802163600-1802264400@excelbi.co.za
SUMMARY:Microsoft Outlook Intermediate
DESCRIPTION:Overview\nTransform your inbox from reactive to proactive. Master advanced organization\, automation\, and management tools to streamline your workflow\, manage complex calendars\, and take control of your communication. \nTarget Audience: \nUsers comfortable with Outlook basics who manage high email volume\, complex calendars\, or need to optimize their workflow for efficiency. \nUpon completion\, students will be able to: \n\nImplement advanced email organization and cleanup strategies.\nManage complex meeting requests\, voting buttons\, and delegate access.\nCreate and manage contact groups and electronic business cards.\nUtilize advanced search (Search Folders) and categorization for rapid information retrieval.\nAutomate email management with sophisticated Rules and alerts.\nConfigure AutoArchive and use Outlook effectively offline.\n\nOutline\nModule 1: Advanced Email Features and Organization \n\nCleanup Tools: Using Clean Up Conversation\, Ignore Conversation\, and Sweep to manage email threads.\nAdvanced Message Options: Setting importance\, sensitivity\, delivery receipts\, and voting buttons.\nQuick Steps: Creating and using one-click Quick Steps to perform multi-action tasks (e.g.\, “Move to Project X & Flag”).\n\nModule 2: Managing Meetings and Appointments \n\nMeeting Options: Scheduling online meetings (Teams)\, setting up presenter options\, and using the Scheduling Assistant for large groups.\nManaging Responses: Tracking attendee responses and proposing a new time for a meeting.\nCalendar Delegation: Granting permissions for a delegate to manage your calendar and send meetings on your behalf.\n\nModule 3: Using Advanced Contacts Features \n\nContact Groups (Distribution Lists): Creating\, updating\, and using groups for frequent team communication.\nElectronic Business Cards: Customizing and sharing your digital business card via email.\nLinking Contacts: Linking multiple entries for the same contact (e.g.\, from an email and a meeting) to create a unified view.\n\nModule 4: Categorizing and Searching Emails \n\nColor Categories: Creating and applying custom color categories to emails\, calendar items\, and tasks for visual organization.\nAdvanced Find & Search Folders: Using the Search Tools ribbon to build complex search queries.\nCreating Search Folders: Setting up dynamic\, virtual folders that automatically gather emails based on specific criteria.\n\nModule 5: Setting Up Rules and Alerts \n\nAdvanced Rules: Creating server-side rules that run even when Outlook is closed\, using “AND/OR” logic for complex conditions.\nDesktop Alerts: Customizing desktop notification settings for new messages.\nManaging Rules: Editing\, re-ordering\, and troubleshooting existing rules for optimal performance.\n\nModule 6: Email Archiving and Offline Management \n\nAutoArchive: Understanding and configuring AutoArchive settings to automatically move old items to an archive (.pst) file.\nManual Archiving: Manually moving or exporting items to an archive file for backup or storage.\nOffline Use: Using Cached Exchange Mode\, working offline\, and managing OST files.
URL:https://excelbi.co.za/event/microsoft-outlook-intermediate/2027-02-09/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Outlook-Intermediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270217T130000
DTSTAMP:20261111T182449
CREATED:20260415T074448Z
LAST-MODIFIED:20260415T074448Z
UID:10000368-1802682000-1802869200@excelbi.co.za
SUMMARY:Microsoft Outlook Advanced
DESCRIPTION:Overview\nBecome an Outlook power user. Leverage advanced automation\, master complex calendar orchestration\, integrate seamlessly with the Microsoft ecosystem\, and implement robust security protocols for ultimate productivity and data protection. \nTarget Audience: \nExecutives\, administrative assistants\, project managers\, IT professionals\, and any power user who manages multiple priorities\, requires deep automation\, and needs to enforce strict security and organization. \nUpon completion\, students will be able to: \n\nDesign and implement sophisticated automation rules and Quick Steps for complex email management.\nDelegate calendar access and manage scheduling for others with detailed permissions.\nImplement a strategic mailbox cleanup and archiving plan to maintain performance and compliance.\nIntegrate Outlook with Teams\, OneNote\, and Power Automate for seamless workflow.\nUtilize advanced sharing and collaboration features for calendars and mailboxes.\nConfigure advanced security settings to protect against phishing and manage data privacy.\n\nOutline\nModule 1: Automating Tasks with Rules and Quick Steps \n\nAdvanced Rule Logic: Creating server-side rules with “AND/OR” conditions and exceptions for precise filtering.\nCustom Quick Steps: Designing multi-action Quick Steps to file\, categorize\, flag\, and forward emails in one click.\nRule Management and Troubleshooting: Organizing rule order for correct execution and debugging rules that fail.\n\nModule 2: Advanced Calendar Management \n\nCalendar Delegation: Granting and managing delegate permissions (Editor\, Author\, Reviewer) to manage another user’s calendar.\nScheduling on Behalf Of: Sending meeting invitations and responses as another person (requires delegate permissions).\nManaging Room & Equipment Resources: Scheduling and managing shared resources like conference rooms and projectors.\n\nModule 3: Mailbox Cleanup and Archiving \n\nManual and Auto-Archive: Configuring Auto-archive settings for folders and manually arching old items to PST files.\nMailbox Cleanup Tools: Using tools like “Empty Deleted Items” on exit and “Cleanup Tools” to manage space.\nOST/ PST Management: Understanding the difference between offline (OST) and archive (PST) data files and managing their size and location.\n\nModule 4: Integration with Other Microsoft Apps \n\nOutlook and Microsoft Teams: Scheduling Teams meetings from Outlook and managing RSVPs. Accessing Outlook contacts in Teams.\nOutlook and OneNote: Linking emails\, meetings\, and contacts to OneNote pages for integrated note-taking and project management.\nIntroduction to Power Automate: Creating simple flows to automate actions between Outlook and other apps (e.g.\, saving email attachments to OneDrive).\n\nModule 5: Collaboration Tools and Sharing Features \n\nAdvanced Calendar Sharing: Publishing calendars online\, sharing via email with detailed permission levels (Free/Busy\, Details\, Editor).\nShared Mailboxes: Using and managing shared mailboxes for team email addresses (e.g.\, info@company.com) without a separate login.\nDelegate Access vs. Sharing: Understanding the difference between granting delegate access and simply sharing a folder.\n\nModule 6: Advanced Security Features and Privacy Settings \n\nPhishing and Junk Mail Protection: Configuring the Junk Email filter\, managing blocked senders\, and identifying sophisticated phishing attempts.\nEncryption and Permissions: Using IRM (Information Rights Management) to send encrypted emails and prevent forwarding\, copying\, or printing.
URL:https://excelbi.co.za/event/microsoft-outlook-advanced/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Outlook-Advanced.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270219T130000
DTSTAMP:20261111T182449
CREATED:20260415T093710Z
LAST-MODIFIED:20260415T093710Z
UID:10000448-1802682000-1803042000@excelbi.co.za
SUMMARY:Agile Project Management with Scrum
DESCRIPTION:Overview\nThis advanced course delves deep into the Scrum framework\, moving beyond the basics to master the practices\, artifacts\, and metrics that drive successful iterative delivery. Learn to manage backlogs\, lead effective ceremonies\, and foster a high-performing\, adaptable team environment. \nTarget Audience:\nProduct Owners\, Scrum Masters\, Development Team members\, project managers\, and Agile coaches with a basic understanding of Scrum who want to deepen their practical expertise. \nUpon completion\, students will be able to: \n\nFacilitate and enhance all Scrum ceremonies for maximum value.\nCreate\, refine\, and manage a dynamic Product Backlog effectively.\nPlan and execute a Sprint with a clear goal and definition of “Done.”\nUtilize key Scrum metrics (velocity\, burn-down charts) to monitor progress and forecast.\nApply strategies to adapt to change and remove impediments.\nFoster a collaborative\, self-organizing\, and high-performing team culture.\n\nOutline\nModule 1: Advanced Scrum Practices and Ceremonies \n\nCeremony Deep Dive: Advanced techniques for facilitating Sprint Planning\, Daily Scrum\, Sprint Review\, and Retrospective.\nDefinition of Ready (DoR) & Definition of Done (DoD): Establishing and applying team agreements to ensure quality and clarity.\nHandling Ceremony Anti-Patterns: Identifying and addressing common dysfunctions (e.g.\, daily scrums becoming status meetings\, ineffective retrospectives).\n\nModule 2: Creating and Managing a Product Backlog \n\nBacklog Refinement (Grooming): Techniques for effective refinement sessions\, splitting large stories\, and estimating.\nPrioritization Techniques: Advanced methods beyond MoSCoW\, such as Weighted Shortest Job First (WSJF) and Kano Model.\nEpics\, Themes\, and User Stories: Structuring the backlog from large initiatives to actionable user stories.\n\nModule 3: Sprint Planning and Execution \n\nEffective Sprint Goal Creation: Crafting a clear\, motivating\, and achievable Sprint Goal.\nCapacity-Based Planning: Planning based on team capacity and historical velocity\, not just wishful thinking.\nSprint Execution & Impediment Removal: The Scrum Master’s role in protecting the team and proactively removing blockers.\n\nModule 4: Monitoring Progress Through Scrum Metrics \n\nVelocity: Tracking and using velocity as a capacity planning tool\, not a performance indicator.\nBurn-down & Burn-up Charts: Interpreting these charts to understand progress and scope change.\nCumulative Flow Diagrams (CFD): Using CFDs to identify bottlenecks in the team’s workflow.\n\nModule 5: Handling Changes and Adaptability in Scrum \n\nManaging Scope Change Mid-Sprint: Protocols for handling new requests during a Sprint without disrupting the goal.\nThe Art of the Pivot: Knowing when to cancel a Sprint versus when to adapt the plan.\nRisk Management in Agile: Identifying and mitigating risks through iterative delivery and transparency.\n\nModule 6: Strategies for Effective Team Collaboration \n\nFostering Psychological Safety: Creating an environment where team members feel safe to experiment\, fail\, and speak up.\nConflict Resolution: Techniques for facilitating healthy conflict and resolving dysfunctions within the team.\n\nCollaboration Techniques: Practices like pair programming\, mob programming\, and swarming to enhance teamwork and knowledge sharing.
URL:https://excelbi.co.za/event/agile-project-management-with-scrum/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Agile-Project-Management-with-Scrum.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270219T130000
DTSTAMP:20261111T182449
CREATED:20260415T094147Z
LAST-MODIFIED:20260415T094147Z
UID:10000470-1802682000-1803042000@excelbi.co.za
SUMMARY:Advanced Risk Management in Projects
DESCRIPTION:Overview\nThis advanced course provides a deep dive into the sophisticated techniques and strategies used to identify\, analyze\, and mitigate risks in complex\, high-stakes projects. Move beyond the basics to master quantitative analysis\, develop robust response strategies\, and create a resilient project environment. \nTarget Audience: \nSenior Project Managers\, Program Managers\, Risk Management Specialists\, PMO leads\, and anyone responsible for managing risk on large\, complex\, or critical projects. \nUpon completion\, students will be able to: \n\nEmploy advanced techniques for comprehensive risk identification.\nConduct both qualitative and quantitative risk analysis to assess impact and probability.\nDevelop and implement sophisticated risk response strategies.\nDesign and execute a continuous risk monitoring and control plan.\nApply lessons learned from real-world case studies to their own projects.\n\nOutline\nModule 1: In-Depth Analysis of Risk Identification \n\nAdvanced Techniques: Delphi technique\, SWOT analysis\, assumption and constraint analysis\, and prompt lists.\nIdentifying Black Swans and Unknown Unknowns: Strategies for anticipating emergent and unpredictable risks.\nDocumenting Risks: Structuring a risk statement (Cause -> Risk -> Effect) and enhancing the risk register.\n\nModule 2: Qualitative and Quantitative Risk Assessment Techniques \n\nAdvanced Qualitative Analysis: Probability and Impact Matrix with weighted criteria\, risk categorization\, and risk urgency assessment.\nIntroduction to Quantitative Analysis: Understanding when and why to use quantitative methods.\nQuantitative Tools & Techniques: Expected Monetary Value (EMV) analysis\, Decision Tree Analysis\, and Monte Carlo simulations (conceptual understanding).\n\nModule 3: Risk Prioritization and Response Planning \n\nRisk Prioritization: Using the results of qualitative/quantitative analysis to create a ranked risk list.\nResponse Strategies for Threats: Deep dive into Avoid\, Transfer\, Mitigate\, and Accept strategies\, including creating contingency plans and fallback plans.\nResponse Strategies for Opportunities: Leveraging Exploit\, Enhance\, Share\, and Accept strategies.\n\nModule 4: Implementation of Risk Mitigation Strategies \n\nIntegrating Responses into the Project Plan: Adding risk responses (mitigation tasks\, contingency reserves) to the schedule\, budget\, and WBS.\nAllocating Resources: Assigning owners and ensuring they have the authority and resources to implement responses.\nContingency and Management Reserves: Establishing and managing reserve funds and buffers for known and unknown risks.\n\nModule 5: Monitoring and Controlling Project Risks \n\nRisk Audits and Reviews: Conducting periodic audits to assess the effectiveness of the risk management process.\nRisk Reassessment: Regularly re-evaluating existing risks and identifying new ones throughout the project lifecycle.\nVariance and Trend Analysis: Using performance data (Earned Value Management – EVM) to spot potential risk triggers.\n\nModule 6: Case Studies on Risk Management in Complex Projects \n\nCase Study 1: Large-Scale Infrastructure Project (e.g.\, cost overruns\, delays).\nCase Study 2: Technology Implementation (e.g.\, scope creep\, integration failure).\nCase Study 3: Pharmaceutical R&D (e.g.\, regulatory risks\, testing failures).
URL:https://excelbi.co.za/event/advanced-risk-management-in-projects/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Advanced-Risk-Management-in-Projects.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270219T130000
DTSTAMP:20261111T182449
CREATED:20260415T125252Z
LAST-MODIFIED:20260415T125252Z
UID:10000629-1802682000-1803042000@excelbi.co.za
SUMMARY:Certificate: Computer Science
DESCRIPTION:Course Overview:\nThis certificate provides a rigorous foundation in the theoretical and practical principles of computer science. It prepares graduates for further study and careers in software engineering\, data analysis\, and technology development by focusing on deep computational thinking and problem-solving. \nTarget Audience:\nStudents pursuing a career as software engineers\, systems architects\, data scientists\, or AI specialists. \nOutline\nModule 1: Core Concepts in Computer Science\n\nIntroduction to Computational Thinking\nDiscrete Mathematics for Computer Science (Logic\, Sets\, Relations)\nNumber Systems (Binary\, Hexadecimal) and Boolean Algebra\nHistory of Computing and Major Paradigms\nIntroduction to Theory of Computation (Automata\, Turing Machines)\nEthics in Computing and Professional Practice\n\n\nModule 2: Programming and Software Development\n\nFundamentals of a High-Level Language (e.g.\, Java\, Python)\nObject-Oriented Programming (OOP) Principles\nSoftware Design Patterns and Architecture\nVersion Control Systems (Git\, GitHub)\nIntegrated Development Environments (IDEs) and Debugging\nBuild Tools and Dependency Management\nIntroduction to Concurrency and Parallelism\n\nModule 3: Data Structures and Algorithms\n\nAlgorithm Analysis and Big-O Notation\nFundamental Data Structures (Arrays\, Linked Lists\, Stacks\, Queues)\nAdvanced Data Structures (Trees\, Graphs\, Hash Tables)\nSorting and Searching Algorithms\nRecursion and Dynamic Programming\nGraph Traversal and Pathfinding Algorithms\nAlgorithmic Problem-Solving Strategies\n\nModule 4: Computer Architecture and Operating Systems\n\nComputer Organization and Architecture (CPU\, Memory\, I/O)\nThe Machine Instruction Cycle\nOperating System Concepts (Process Management\, Scheduling)\nMemory Management and Virtual Memory\nFile Systems and Storage\nConcurrency\, Threading\, and Synchronization\nFundamentals of Computer Networking\n\nModule 5: Artificial Intelligence and Machine Learning\n\nHistory and Philosophy of Artificial Intelligence\nIntroduction to Intelligent Agents\nFundamental Machine Learning Concepts (Supervised vs. Unsupervised)\nBasic Algorithms (Linear Regression\, Decision Trees\, k-NN)\nIntroduction to Neural Networks and Deep Learning\nNatural Language Processing (NLP) Fundamentals\nEthics and Societal Impact of AI
URL:https://excelbi.co.za/event/certificate-computer-science/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Certificate-Computer-Science.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270219T130000
DTSTAMP:20261111T182449
CREATED:20260416T082426Z
LAST-MODIFIED:20260416T082426Z
UID:10000878-1802682000-1803042000@excelbi.co.za
SUMMARY:Workshop: Electronics
DESCRIPTION:Course Objective:\nTo equip learners with the knowledge and practical skills to analyze\, design\, build\, troubleshoot\, and repair electronic circuits and systems\, encompassing both analog and digital technologies. \nTarget Audience: \nElectronics technicians\, repair specialists\, hobbyists\, and individuals pursuing careers in electronics design\, maintenance\, or further engineering study. \nOutline\nModule 1: Circuit Analysis and Design\n\nDC Circuit Analysis: Advanced application of Ohm’s Law\, Kirchhoff’s Laws (KVL & KCL)\, Thevenin’s and Norton’s theorems.\nAC Circuit Analysis: Working with sinusoidal waveforms; understanding reactance and impedance in capacitive and inductive circuits.\nNetwork Theorems: Superposition\, nodal and mesh analysis for complex circuits.\nCircuit Simulation Software: Using tools like LTSpice or Multisim to model\, simulate\, and analyze circuit behavior before construction.\nPCB Design Introduction: Basics of schematic capture and designing a simple printed circuit board (PCB) layout.\n\nModule 2: Analog and Digital Electronics\n\nAnalog Electronics: In-depth study of diodes (rectifiers\, regulators)\, transistors (BJT and MOSFET amplifiers\, switches)\, and operational amplifiers (op-amps) in various configurations (inverting\, non-inverting\, filters).\nDigital Electronics: Boolean algebra\, logic gates\, combinational logic circuits\, flip-flops\, counters\, and sequential logic.\nData Conversion: Fundamentals of Analog-to-Digital (ADC) and Digital-to-Analog (DAC) converters.\nPower Supplies: Designing and troubleshooting linear and switched-mode power supply (SMPS) circuits.\n\nModule 3: Signal Processing\n\nAmplification: Designing single and multi-stage transistor amplifiers for voltage\, current\, and power gain.\nFilter Design: Designing and building passive and active filters (low-pass\, high-pass\, band-pass) to remove unwanted signal frequencies.\nOscillators: Principles of feedback and operation of oscillator circuits (e.g.\, RC\, LC\, crystal) to generate stable frequencies.\nModulation/Demodulation: Introduction to core concepts of AM and FM for communications.\n\nModule 4: Microcontroller Applications\n\nMicrocontroller Architecture: Understanding the core components of a MCU (CPU\, memory\, I/O ports\, timers\, ADC).\nEmbedded C Programming: Writing code to read digital/analog inputs\, control outputs\, and use communication protocols.\nPeripheral Interfacing: Connecting and programming sensors (e.g.\, temperature\, light)\, actuators (e.g.\, motors\, servos)\, and displays (e.g.\, LCD).\nCommunication Protocols: Implementing serial protocols like UART\, I2C\, and SPI for device communication.\nProject Integration: Designing and building a complete embedded system that performs a defined task.\n\nModule 5: Equipment Repair and Maintenance\n\nTroubleshooting Methodology: Advanced fault-finding techniques; using block diagrams and service manuals.\nTest Equipment Proficiency: Advanced use of oscilloscopes\, logic analyzers\, spectrum analyzers\, and LCR meters.\nComponent-Level Repair: Desoldering and replacing surface-mount (SMD) and through-hole components; diagnosing faulty ICs.\nPreventative Maintenance: Performing calibrations\, inspections\, and replacing wear components.\nSafety Standards: Adhering to high-voltage safety procedures and industry-standard repair practices
URL:https://excelbi.co.za/event/workshop-electronics/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/electronics.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270216T090000
DTEND;TZID=UTC:20270217T130000
DTSTAMP:20261111T182449
CREATED:20260415T071247Z
LAST-MODIFIED:20260415T071247Z
UID:10000035-1802768400-1802869200@excelbi.co.za
SUMMARY:Microsoft Office Excel Intermediate
DESCRIPTION:Microsoft Office Excel Intermediate\nCourse Overview\nElevate your Excel skills beyond basics. Master powerful functions\, dynamic analysis with PivotTables\, and advanced data management techniques to transform raw data into actionable insights. \nTarget Audience: \nUsers comfortable with Excel basics (data entry\, simple formulas\, basic formatting) who need to analyze\, manage\, and present complex data sets. \nUpon completion\, students will be able to: \n\nBuild complex formulas using logical (IF\, AND/OR)\, lookup (VLOOKUP/XLOOKUP)\, and text functions.\nApply and manage Conditional Formatting to visually analyze data trends and patterns.\nCreate\, modify\, and filter PivotTables and PivotCharts to summarize large data sets.\nUse advanced filtering\, sorting\, and data tools to manage lists.\nLink data across multiple worksheets and workbooks.\nImplement Data Validation and protect worksheets and workbooks.\n\nOutline\nModule 1: Advanced Formulas and Functions \n\nLogical Functions: Using IF\, nested IFs\, AND\, and OR to make conditional calculations.\nLookup Functions: Using VLOOKUP (or XLOOKUP) to find and retrieve data from a table.\nText & Date Functions: Using functions like LEFT\, RIGHT\, CONCAT\, and DATE to manipulate text and date values.\n\nModule 2: Conditional Formatting Techniques \n\nBeyond Basic Highlighting: Using top/bottom rules\, data bars\, color scales\, and icon sets.\nCustom Rules: Creating new rules with custom formulas (e.g.\, format a cell if it is above the average of a range).\nManaging Rules: Editing\, deleting\, and controlling the order of multiple conditional formatting rules.\n\nModule 3: Introduction to PivotTables \n\nPivotTable Basics: Creating a PivotTable from a data range\, understanding the Field List.\nArranging Data: Adding fields to Rows\, Columns\, Values\, and Filters to shape your report.\nGrouping and Formatting: Grouping dates/numbers\, applying number formatting\, and changing summary calculations (Sum\, Count\, Average).\n\nModule 4: Advanced Data Sorting and Filtering \n\nCustom Sorts: Sorting data by multiple columns (e.g.\, sort by Region\, then by Sales descending).\nAdvanced Filter: Using the Advanced Filter tool to extract data based on complex\, multi-field criteria.\nTable Filters: Leveraging the powerful filtering capabilities of Excel Tables (slicers & timelines).\n\nModule 5: Working with Multiple Sheets and Workbooks \n\n3D Formulas:Referencing the same cell across multiple worksheets for summary calculations (e.g.\, SUM(Sheet1:Sheet3!B5)).\nLinking Workbooks: Creating formulas that reference cells in other open workbooks.\nConsolidating Data: Using the Consolidate tool to combine data from multiple sheets.\n\nModule 6: Data Validation and Protection \n\nData Validation: Setting rules to restrict data entry (e.g.\, whole numbers\, dates\, custom lists for drop-down menus).\nInput Messages and Error Alerts: Creating prompts and custom error messages for users.\nProtection: Locking cells\, protecting a worksheet with a password\, and protecting workbook structure.
URL:https://excelbi.co.za/event/microsoft-office-excel-intermediate/2027-02-16/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/03/Excel-Intermediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270301T090000
DTEND;TZID=UTC:20270305T130000
DTSTAMP:20261111T182449
CREATED:20260416T083848Z
LAST-MODIFIED:20260416T083848Z
UID:10000917-1803891600-1804251600@excelbi.co.za
SUMMARY:Workshop: PC Engineering
DESCRIPTION:Overview\nTo provide learners with the practical skills and theoretical knowledge to assemble\, configure\, upgrade\, maintain\, and troubleshoot personal computer hardware\, software\, and basic network connectivity. \nTarget Audience:\nAspiring PC technicians\, IT support staff\, hobbyists\, and individuals seeking a foundation in computer hardware and repair. \nOutline\nModule 1: Introduction to PC Hardware and Software\n\nComputer Fundamentals: The function of a PC and the computing cycle (Input\, Process\, Output\, Storage).\nHardware Components: Identification and function of core components: case\, PSU\, motherboard\, CPU\, RAM\, storage\, GPU.\nSoftware Overview: Distinction between firmware (BIOS/UEFI)\, operating systems (Windows\, Linux)\, and application software.\nHardware Compatibility: Understanding form factors (e.g.\, ATX\, mATX) and interoperability between components.\nSafety and Tools: Proper use of tools (screwdrivers\, anti-static wrist strap) and electrostatic discharge (ESD) safety procedures.\n\nModule 2: Motherboards and Processors\n\nMotherboard Anatomy: Sockets\, chipsets\, expansion slots (PCIe)\, RAM slots\, headers\, and connectors (SATA\, M.2\, front-panel).\nCPU Technology: Understanding processor specifications (cores\, threads\, clock speed\, cache)\, architectures (Intel vs. AMD)\, and cooling solutions (air vs. liquid).\nBIOS/UEFI Firmware: Navigating the firmware interface\, configuring boot order\, enabling virtualization\, and updating firmware.\nPractical Skills: Hands-on installation of a CPU\, CPU cooler\, and motherboard into a case.\n\nModule 3: Storage Devices and Data Management\n\nStorage Technologies: Characteristics of HDDs\, SSDs (SATA & NVMe)\, and optical drives.\nStorage Configuration: Partitioning\, formatting (NTFS\, exFAT\, APFS)\, and drive initialization.\nRAID Concepts: Understanding RAID levels (0\, 1\, 5\, 10) for performance and redundancy.\nData Management: File systems\, folder structures\, and data migration techniques.\nBackup and Recovery: Implementing backup strategies and using tools for data recovery and system imaging.\n\nModule 4: Network Configuration and Management\n\nNetworking Fundamentals: TCP/IP basics\, IPv4 addressing\, subnet masks\, default gateways\, and DNS.\nNetwork Hardware: Purpose and setup of routers\, switches\, and network interface cards (NIC).\nNetwork Types: Configuring and securing wired (Ethernet) and wireless (Wi-Fi) connections on a client PC.\nNetwork Troubleshooting: Using command-line tools (ipconfig\, ping\, tracert) to diagnose and resolve connectivity issues.\nResource Sharing: Setting up and accessing shared folders and printers on a local network.\n\nModule 5: PC Maintenance and Repair\n\nTroubleshooting Methodology: A structured approach to problem-solving (e.g.\, Identify\, Theory\, Test\, Plan\, Implement\, Verify\, Document).\nHardware Diagnostics: Troubleshooting POST issues\, component failures\, overheating\, and power problems.\nSoftware Diagnostics: Resolving OS boot errors\, driver conflicts\, application crashes\, and malware removal.\nPreventative Maintenance: Physical cleaning\, managing startup programs\, disk cleanup\, defragmentation\, and updating software/drivers.\nProfessional Practice: Customer communication\, documenting repairs\, and ethical considerations.
URL:https://excelbi.co.za/event/workshop-pc-engineering/2027-03-01/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/pc-engineering.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270830T080000
DTEND;TZID=UTC:20270903T170000
DTSTAMP:20261111T182449
CREATED:20260416T102749Z
LAST-MODIFIED:20260416T102749Z
UID:10000994-1819612800-1819990800@excelbi.co.za
SUMMARY:Certificate: Business Analysis Support Practice
DESCRIPTION:Course Overview:\nEquips learners with foundational knowledge and practical skills to support business analysis activities\, including requirements elicitation\, process modeling\, and stakeholder engagement. \nTarget Audience: \nAspiring BAs\, Project Support Staff\, Career Changers. \nOutline\nModule 1: Business Analysis Fundamentals\n\nRole of the Business Analyst vs. BA Support Practitioner.\nThe Business Analysis Lifecycle & Key Stages.\nCore Concepts: Needs\, Requirements\, Stakeholders\, Solutions.\n\nModule 2: Requirements Elicitation and Management\n\nElicitation Techniques: Interviews\, Workshops\, Surveys.\nDocumenting Requirements: User Stories & Acceptance Criteria.\nRequirements Management: Traceability and Change Control.\n\nModule 3: Process Modeling and Improvement\n\nProcess Modeling Fundamentals: BPMN Notation.\nMapping the Current State (As-Is Process).\nIdentifying Inefficiencies & Designing a Future State (To-Be).\n\nModule 4: Solution Assessment and Validation\n\nSolution Validation vs. Verification.\nSupporting User Acceptance Testing (UAT).\nWriting Test Cases from Requirements.\n\nModule 5: Communication and Stakeholder Engagement\n\nStakeholder Identification & Analysis (e.g.\, Power/Interest Grid).\nTailoring Communication for Different Audiences.\nActive Listening\, Questioning\, & Communication Plans.
URL:https://excelbi.co.za/event/certificate-business-analysis-support-practice/2027-08-30/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Business Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/BA-Support-Practice-1.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270830T090000
DTEND;TZID=UTC:20270903T130000
DTSTAMP:20261111T182449
CREATED:20260415T102118Z
LAST-MODIFIED:20260415T102552Z
UID:10000557-1819616400-1819976400@excelbi.co.za
SUMMARY:Certificate: Information and Communication Technology (ICT) Software Testing
DESCRIPTION:Course Overview:\nThis course equips learners with the fundamental principles and practical skills to effectively test software\, manage defects\, and assure quality throughout the development lifecycle. \nTarget Audience:\nAspiring software testers\, QA analysts\, developers\, and IT graduates. \nOutline\nModule 1: Software Testing Principles\n\nCore Objectives: Verification vs. Validation.\nFundamental Test Process: Planning\, Analysis\, Execution.\nKey Terminology: Error\, Defect\, Failure.\nTesting Levels: Unit\, Integration\, System\, Acceptance.\nTesting Types: Functional vs. Non-Functional.\n\nModule 2: Test Planning and Strategy Development\n\nComponents of a Test Plan.\nAnalyzing Requirements to Define Test Scope & Objectives.\nRisk-Based Testing Approach.\nEstimating Effort and Resource Planning.\nDefining Test Strategy for a Project.\n\nModule 3: Manual and Automated Testing Techniques\n\nBlack-Box Test Design Techniques: Equivalence Partitioning\, Boundary Value Analysis.\nCreating and Executing Manual Test Cases.\nIntroduction to Test Automation: Benefits and Limitations.\nOverview of Automation Tools (e.g.\, Selenium\, Cypress).\nThe Role of Manual vs. Automated Testing.\n\nModule 4: Defect Tracking and Reporting\n\nDefect Lifecycle and Statuses.\nLogging Effective Defect Reports: Key Information and Reproducibility.\nUtilizing Defect Tracking Tools (e.g.\, Jira).\nTriage and Priority Management.\nCommunicating Defects to Developers and Stakeholders.\n\nModule 5: Quality Assurance in Software Development\n\nQA’s Role in the Software Development Lifecycle (SDLC).\nIntegrating Testing in Agile & DevOps Methodologies.\nBest Practices for Test Metrics and Reporting.\nIntroduction to Continuous Integration/Continuous Deployment (CI/CD).
URL:https://excelbi.co.za/event/certificate-information-and-communication-technology-ict-software-testing/2027-08-30/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Information-and-Communication-Technology-ICT-Software-Testing.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
END:VCALENDAR