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:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20261116T090000
DTEND;TZID=UTC:20261120T130000
DTSTAMP:20261108T121036
CREATED:20260416T082426Z
LAST-MODIFIED:20260416T082426Z
UID:10000877-1794819600-1795179600@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/2026-11-16/
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:20261123T090000
DTEND;TZID=UTC:20261127T130000
DTSTAMP:20261108T121036
CREATED:20260415T123041Z
LAST-MODIFIED:20260415T123041Z
UID:10000567-1795424400-1795784400@excelbi.co.za
SUMMARY:Certificate: Information Technology (Systems Development)
DESCRIPTION:Course Overview:\nThis certificate provides a thorough grounding in the principles and practices of modern software engineering. Students will learn to design\, code\, test\, and manage the development of robust applications and systems\, preparing them for roles as junior developers\, software testers\, and IT project support staff. \nTarget Audience:\nAspiring software developers\, programmers\, and IT professionals seeking to specialize in building software solutions. \nOutline\nModule 1: Software Design and Implementation\n\nSoftware Development Lifecycle (SDLC) Models\nObject-Oriented Analysis and Design (OOAD) Principles\nUML and Modeling Techniques (Use Cases\, Class Diagrams\, Sequence Diagrams)\nSoftware Architecture Patterns (e.g.\, MVC\, Client-Server)\nAPI Design and Integration Principles\nWriting Clean\, Maintainable\, and Documented Code\n\nModule 2: Programming Languages (Java\, Python\, etc.)\n\nCore Programming Concepts (Syntax\, Data Types\, Control Flow)\nObject-Oriented Programming (Classes\, Objects\, Inheritance\, Polymorphism)\nData Structures (Lists\, Stacks\, Queues\, Dictionaries)\nLanguage-Specific Frameworks and Libraries (e.g.\, Spring for Java\, Django for Python)\nIntroduction to Web Development (HTML\, CSS\, JavaScript)\nComparative Language Analysis\n\nModule 3: Database Management and Development\n\nRelational Database Concepts and Normalization\nSQL for Data Definition and Manipulation (DDL & DML)\nAdvanced Querying (Joins\, Subqueries\, Transactions)\nDatabase Programming (Stored Procedures\, Triggers)\nIntroduction to NoSQL Databases (e.g.\, MongoDB)\nIntegrating Databases with Applications\n\nModule 4: Project Management in IT\n\nTraditional vs. Agile Project Management (Waterfall\, Scrum\, Kanban)\nProject Planning\, Scheduling\, and Estimation\nRisk Management and Mitigation\nVersion Control with Git and Collaboration (GitHub\, GitLab)\nTools for Project Tracking (e.g.\, Jira\, Trello)\nTeam Dynamics and Communication\n\nModule 5: Testing and Quality Assurance\n\nFundamentals of Software Testing\nWriting and Executing Test Cases\nLevels of Testing (Unit\, Integration\, System\, UAT)\nTest-Driven Development (TDD) Introduction\nAutomated Testing Tools and Scripts (e.g.\, Selenium\, JUnit)\nDebugging Techniques and Defect Lifecycle Management
URL:https://excelbi.co.za/event/certificate-information-technology-systems-development/2026-11-23/
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-Information-Technology-Systems-Development.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261123T090000
DTEND;TZID=UTC:20261127T130000
DTSTAMP:20261108T121036
CREATED:20260415T140931Z
LAST-MODIFIED:20260415T140931Z
UID:10000657-1795424400-1795784400@excelbi.co.za
SUMMARY:Workshop: Information Technology: Systems Development
DESCRIPTION:Course Overview:\nThis certificate provides learners with the foundational knowledge and practical skills required to begin a career in software development. Students will learn to analyze requirements\, design systems\, write code\, manage databases\, and rigorously test applications using modern methodologies. \nTarget Audience:\nAspiring software developers\, career changers\, and IT professionals seeking to move into a development role. \nOutline\nModule 1: Software Development Principles\n\nIntroduction to Programming Logic and Algorithms\nVariables\, Data Types\, and Operators\nControl Structures (Conditionals and Loops)\nFunctions\, Methods\, and Modular Programming\nBasic Data Structures (Arrays\, Lists\, Dictionaries)\nIntroduction to Object-Oriented Programming (OOP) Concepts\nPrinciples of Clean Code and Readability\nIntroduction to a Programming Language (e.g.\, Python\, C#\, Java)\n\nModule 2: System Analysis and Design\n\nThe Role of a Systems Analyst\nGathering and Documenting User Requirements\nCreating Use Cases and User Stories\nModeling System Processes (Data Flow Diagrams)\nDesigning User Interfaces (UI) and User Experiences (UX)\nIntroduction to UML Diagrams (Class\, Sequence Diagrams)\nCreating Technical Specification Documents\n\nModule 3: Databases and SQL\n\nIntroduction to Relational Database Concepts\nDatabase Normalization Principles\nEntity-Relationship (ER) Diagramming\nSQL Fundamentals: Data Definition Language (DDL)\nSQL Fundamentals: Data Manipulation Language (DML)\nWriting Advanced Queries (Joins\, Unions\, Aggregations)\nIntegrating Applications with Databases\n\nModule 4: Development Methodologies (Agile\, Waterfall)\n\nIntroduction to the Software Development Lifecycle (SDLC)\nThe Traditional Waterfall Methodology\nThe Agile Manifesto and Principles\nThe Scrum Framework (Roles\, Artifacts\, Ceremonies)\nKanban and Lean Development Principles\nProject Management Tools (e.g.\, Jira\, Trello)\nVersion Control with Git (Basics)\n\nModule 5: Application Testing and Debugging\n 
URL:https://excelbi.co.za/event/workshop-information-technology-systems-development/2026-11-23/
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/systems-development-1.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261123T090000
DTEND;TZID=UTC:20261127T130000
DTSTAMP:20261108T121036
CREATED:20260416T075243Z
LAST-MODIFIED:20260416T075243Z
UID:10000820-1795424400-1795784400@excelbi.co.za
SUMMARY:Certificate: Technology: Database Development
DESCRIPTION:Course Overview:\nThis course provides the foundational knowledge and practical skills to design\, build\, query\, and manage modern\, secure\, and efficient databases. \nTarget Audience: Aspiring Database Developers\, Data Analysts\, IT professionals\, and software developers. \nOutline\nModule 1: Database Design and Modeling\n\nRelational Database Concepts and Principles.\nEntity-Relationship (ER) Diagramming.\nNormalization (1NF\, 2NF\, 3NF).\nTranslating Business Requirements into a Data Model.\n\nModule 2: SQL and Query Optimization\n\nCore SQL: DDL\, DML\, DQL (SELECT\, JOINs\, WHERE\, GROUP BY).\nWriting Advanced Queries: Subqueries\, Functions.\nIndexing and Query Performance Tuning.\nUnderstanding Execution Plans.\n\nModule 3: Data Warehousing Concepts\n\nData Warehouse Architecture (OLAP vs. OLTP).\nDimensional Modeling: Stars and Snowflakes Schemas.\nETL (Extract\, Transform\, Load) Processes.\nIntroduction to BI and Reporting.\n\nModule 4: Database Security and Management\n\nUser Authentication and Authorization.\nImplementing Data Encryption.\nBackup\, Recovery\, and Disaster Planning.\nRoutine Maintenance and Monitoring.\n\nModule 5: Emerging Trends in Database Technology\n\nIntroduction to NoSQL Databases (Document\, Key-Value).\nCloud Database Services (e.g.\, AWS RDS\, Azure SQL).\nBig Data Fundamentals.\nOverview of Data Lakes.
URL:https://excelbi.co.za/event/certificate-technology-database-development/2026-11-23/
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/3darts-renders-k9o7KiAzcis-unsplash.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261207T090000
DTEND;TZID=UTC:20261211T130000
DTSTAMP:20261108T121036
CREATED:20260416T063925Z
LAST-MODIFIED:20260416T063925Z
UID:10000687-1796634000-1796994000@excelbi.co.za
SUMMARY:Workshop: Information Technology: Technical Support
DESCRIPTION:Course Overview:\nThis certificate equips learners with the fundamental knowledge and practical skills required for a career in technical support. Students will learn to install\, configure\, troubleshoot\, and maintain IT systems\, support basic network connectivity\, apply essential security practices\, and deliver excellent customer service. Graduates will be prepared for entry-level roles such as Help Desk Technician\, Desktop Support Specialist\, and IT Support Analyst. \nTarget Audience:\nIndividuals seeking to start a career in IT support\, career changers\, and current IT users looking to formalize their skills. \nOutline\nModule 1: IT Systems and Hardware\n\nIntroduction to Computer Systems and Components\nInternal Hardware: Motherboards\, CPUs\, RAM\, and Storage\nPower Supplies\, Cooling\, and Cases\nPeripheral Devices and I/O Ports (USB\, HDMI\, DisplayPort)\nPrinters and Multi-Function Devices\nDevice Drivers and Configuration\nPC Assembly\, Disassembly\, and Upgrading\nBIOS/UEFI Firmware Configuration\n\nModule 2: Troubleshooting and Problem Solving\n\nSystematic Troubleshooting Methodologies\nTroubleshooting Core Hardware Components\nTroubleshooting Storage and Memory Issues\nTroubleshooting Printer and Peripheral Problems\nOperating System Boot Process and Recovery\nTroubleshooting Common OS and Application Issues\nUsing Built-in Diagnostic and Repair Tools\nDocumentation\, Ticketing Systems\, and Change Management\nIntroduction to Scripting for Automation (PowerShell/Bash)\n\nModule 3: Network and Communication Essentials\n\nFundamental Networking Concepts (TCP/IP\, DNS\, DHCP)\nIPv4 Addressing and Subnet Masks\nNetwork Infrastructure Devices (Routers\, Switches\, APs)\nNetwork Media and Cabling (UTP\, Fibre)\nWireless Networking Standards and Security (Wi-Fi\, WPA2/WPA3)\nConfiguring a SOHO (Small Office/Home Office) Network\nNetwork Connectivity and Command-Line Tools (ipconfig\, ping\, nslookup)\nTroubleshooting Network Connectivity Issues\n\nModule 4: Customer Service and Support\n\nThe Role and Mindset of an IT Support Professional\nPrinciples of Excellent Customer Service\nEffective Communication: Active Listening and Questioning\nProfessional Verbal and Written Communication\nManaging Difficult Conversations and Frustrated Users\nRemote Support Tools and Techniques\nHelp Desk Software and Ticketing System Management\nTime Management and Prioritization of Tasks\n\nModule 5: IT Security Practices\n\nCore Security Concepts (CIA Triad: Confidentiality\, Integrity\, Availability)\nPhysical Security and Access Control\nCybersecurity Threats: Malware\, Social Engineering\, Phishing\nSecuring Workstations and Mobile Devices\nPassword Policies and Multi-Factor Authentication (MFA)\nPrinciples of Secure Networking\nData Encryption and Secure Disposal\nSecurity Best Practices for End Users\nIncident Response and Reporting Procedures
URL:https://excelbi.co.za/event/workshop-information-technology-technical-support/2026-12-07/
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/technical-support.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261207T090000
DTEND;TZID=UTC:20261211T130000
DTSTAMP:20261108T121036
CREATED:20260416T080252Z
LAST-MODIFIED:20260416T080252Z
UID:10000848-1796634000-1796994000@excelbi.co.za
SUMMARY:Workshop: End User Computing
DESCRIPTION:Course Objective:\nTo empower learners with the practical skills and knowledge to confidently use computer hardware\, application software\, and online collaboration tools to solve problems\, communicate effectively\, and perform basic IT troubleshooting. \nTarget Audience:\nIndividuals with little to no formal IT training\, career changers\, administrative staff\, and anyone seeking to improve their digital literacy for personal or professional development. \nOutline\nModule 1: Introduction to Computing and IT Skills\n\nComputer Hardware & Software: Identifying core components (CPU\, RAM\, storage); understanding the difference between system and application software.\nOperating System Navigation: Proficiency in using Windows or macOS (file management\, system settings\, user accounts).\nFile Management: Creating a logical folder structure; naming\, moving\, copying\, and organizing files and folders.\nSystem Setup & Maintenance: Connecting peripherals (printers\, drives); basic software installation and updates.\nIT Security Fundamentals: Creating strong passwords\, recognizing phishing attempts\, and understanding malware.\n\nModule 2: Application Software Proficiency\n\nWord Processing (e.g.\, Microsoft Word/Google Docs): Creating\, formatting\, and reviewing documents; using templates; mail merge.\nSpreadsheets (e.g.\, Microsoft Excel/Google Sheets): Data entry\, formatting\, basic formulas and functions (SUM\, AVERAGE\, IF)\, creating charts and graphs.\nPresentation Software (e.g.\, PowerPoint/Google Slides): Designing effective slideshows; using themes\, animations\, and transitions; presenting skills.\nDatabase Fundamentals (e.g.\, Microsoft Access): Basic concepts of tables\, forms\, queries\, and reports.\n\nModule 3: Online Collaboration Tools\n\nEffective Web Use: Advanced search techniques; critically evaluating online information.\nEmail Management: Professional email etiquette; managing calendars\, contacts\, and tasks within an email client.\nCloud Storage & Collaboration: Using OneDrive\, Google Drive\, or Dropbox for file storage and sharing; real-time co-authoring on documents.\nDigital Communication Platforms: Effective use of instant messaging and video conferencing tools (e.g.\, Teams\, Zoom) for meetings and teamwork.\n\nModule 4: Problem Solving Using Technology\n\nInformation Literacy: Using online resources to research and gather information for decision-making.\nData-Driven Decisions: Using spreadsheet functions to organize and analyze data to identify trends and support conclusions.\nAutomation Basics: Introduction to macros and simple automation tools to streamline repetitive tasks.\nProject Management Tools: Using basic features of applications like Trello or Planner to organize tasks and manage small projects.\n\nModule 5: IT Support and Troubleshooting\n\nTroubleshooting Methodology: Applying a structured approach to identify and solve hardware and software problems.\nCommon Issue Resolution: Solving problems with printers\, network connectivity\, frozen applications\, and peripheral devices.\nUsing Help Resources: Effectively using built-in OS help\, online knowledge bases\, and forums to find solutions.\nProfessional Support Practices: How to accurately describe a problem to an IT support specialist and document the solution.
URL:https://excelbi.co.za/event/workshop-end-user-computing/2026-12-07/
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/end-user-computing.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261207T090000
DTEND;TZID=UTC:20261211T130000
DTSTAMP:20261108T121036
CREATED:20260416T083848Z
LAST-MODIFIED:20260416T083848Z
UID:10000916-1796634000-1796994000@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/2026-12-07/
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:20261207T090000
DTEND;TZID=UTC:20261211T130000
DTSTAMP:20261108T121036
CREATED:20260416T093128Z
LAST-MODIFIED:20260416T093128Z
UID:10000965-1796634000-1796994000@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/2026-12-07/
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:20261207T090000
DTEND;TZID=UTC:20261218T130000
DTSTAMP:20261108T121036
CREATED:20260415T094811Z
LAST-MODIFIED:20260415T094811Z
UID:10000498-1796634000-1797598800@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/2026-12-07/
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:20261208T090000
DTEND;TZID=UTC:20261209T130000
DTSTAMP:20261108T121036
CREATED:20260415T064620Z
LAST-MODIFIED:20260415T064620Z
UID:10000004-1796720400-1796821200@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/2026-12-08/
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:20261214T090000
DTEND;TZID=UTC:20261218T130000
DTSTAMP:20261108T121036
CREATED:20260415T123727Z
LAST-MODIFIED:20260415T123727Z
UID:10000597-1797238800-1797598800@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/2026-12-14/
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:20261215T090000
DTEND;TZID=UTC:20261216T130000
DTSTAMP:20261108T121036
CREATED:20260415T071247Z
LAST-MODIFIED:20260415T071247Z
UID:10000034-1797325200-1797426000@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/2026-12-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/03/Excel-Intermediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261221T090000
DTEND;TZID=UTC:20261225T130000
DTSTAMP:20261108T121036
CREATED:20260415T094147Z
LAST-MODIFIED:20260415T094147Z
UID:10000469-1797843600-1798203600@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/2026-12-21/
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:20261221T090000
DTEND;TZID=UTC:20261225T130000
DTSTAMP:20261108T121036
CREATED:20260415T125252Z
LAST-MODIFIED:20260415T125252Z
UID:10000628-1797843600-1798203600@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/2026-12-21/
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:20261228T090000
DTEND;TZID=UTC:20261230T130000
DTSTAMP:20261108T121036
CREATED:20260415T071621Z
LAST-MODIFIED:20260415T071621Z
UID:10000064-1798448400-1798635600@excelbi.co.za
SUMMARY:Microsoft Excel Advanced
DESCRIPTION:Microsoft Excel Advanced\nOverview\nUnlock the full power of Excel. Master advanced analytics\, automate complex tasks with VBA\, build dynamic dashboards\, and transform raw data into predictive insights and interactive reports. \nTarget Audience: \nData analysts\, financial modelers\, business professionals\, and advanced users who need to perform complex data manipulation\, automation\, and forecasting. \nUpon completion\, students will be able to: \n\nPerform sophisticated data analysis and create dynamic dashboards with advanced PivotTable techniques.\nRecord\, write\, and run VBA macros to automate repetitive tasks and build custom functions.\nCreate advanced\, interactive charts and visualizations for dashboards.\nUtilize What-If Analysis tools (Goal Seek\, Data Tables\, Scenario Manager) for forecasting and modeling.\nImport\, transform\, and combine data from multiple sources using Power Query and build a simple Data Model.\nImplement advanced workbook\, worksheet\, and VBA project protection strategies.\n\nOutline\nModule 1: Advanced Data Analysis with PivotTables \n\nCalculated Fields & Items: Creating custom formulas within a PivotTable.\nGrouping Data: Advanced grouping of dates (by weeks\, quarters) and numeric fields into bins.\nSlicers & Timelines: Using slicers and timelines for interactive filtering across multiple PivotTables and PivotCharts.\n\nModule 2: Using Macros and VBA for Automation \n\nMacro Recorder Deep Dive: Recording complex macros and understanding relative references.\nIntroduction to the VBA Editor: Navigating the editor\, writing simple sub procedures\, and using MsgBox and InputBox.\nError Handling & Debugging: Writing robust macros that handle errors and debugging code.\n\nModule 3: Complex Charting Techniques \n\nCombination Charts: Creating charts that combine different chart types (e.g.\, Column and Line).\nDynamic Charting: Using named ranges with the OFFSET and COUNTA functions to make charts that automatically update with new data.\nAdvanced Formatting: Using form controls (like scroll bars and spinners) to create interactive charts.\n\nModule 4: What-If Analysis and Data Forecasting \n\nGoal Seek: Working backwards to find the required input to achieve a desired result.\nData Tables: Building one-way and two-way data tables for sensitivity analysis.\nScenario Manager & Forecast Sheet: Creating and comparing different scenarios and using the automated Forecast Sheet tool for time-based forecasting.\n\nModule 5: Data Model and Power Query Introduction \n\nPower Query (Get & Transform): Importing data from files\, databases\, and the web. Removing errors\, pivoting/unpivoting columns\, and creating custom columns.\nBuilding a Data Model: Creating relationships between multiple tables without using VLOOKUP.\nDAX Introduction: Writing basic DAX formulas (Measures) for calculated fields in PivotTables (e.g.\, SUMX\, CALCULATE).\n\nModule 6: Workbook Security and Protection \n\nWorksheet & Workbook Protection: Applying and cracking passwords to protect structure and windows. Locking and unlocking specific cells.\nFile-Level Security: Encrypting workbooks with passwords and marking as final.\nVBA Project Protection: Locking VBA code from viewing with a password.
URL:https://excelbi.co.za/event/microsoft-excel-advanced/2026-12-28/
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/Excel-Advanced.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270104T090000
DTEND;TZID=UTC:20270108T130000
DTSTAMP:20261108T121036
CREATED:20260416T065613Z
LAST-MODIFIED:20260416T065719Z
UID:10000735-1799053200-1799413200@excelbi.co.za
SUMMARY:Workshop: Website Development
DESCRIPTION:Course Objective:\nTo equip learners with the practical skills and theoretical knowledge to design\, build\, deploy\, and maintain modern\, responsive\, secure\, and accessible websites using standard web technologies and content management systems. \nTarget Audience:\nAspiring web developers\, career changers\, designers looking to add development skills\, entrepreneurs\, and marketing professionals. \nOutline\nModule 1: Web Technologies and Tools\n\nHow the Web Works: Clients\, servers\, HTTP/HTTPS protocols\, and DNS.\nDevelopment Environments: Setting up a local development server (e.g.\, XAMPP\, WAMP) and using code editors (e.g.\, VS Code).\nVersion Control with Git: Repository basics\, committing changes\, and branching for project management.\nBrowser Developer Tools: Using inspector tools for debugging HTML\, CSS\, and JavaScript.\nWeb Standards and Accessibility: Introduction to W3C standards and Web Content Accessibility Guidelines (WCAG).\n\nModule 2: HTML\, CSS\, and JavaScript Programming\n\nHTML5: Semantic HTML\, forms\, multimedia elements (audio\, video)\, and embedding content.\nCSS3: Styling\, the box model\, advanced selectors\, and modern layout techniques including Flexbox and CSS Grid.\nJavaScript Fundamentals: Variables\, data types\, functions\, control flow\, and DOM manipulation.\nInteractive Web Pages: Handling events\, validating forms\, and dynamically updating content without page reloads.\nIntroduction to APIs: Fetching and displaying data from third-party RESTful APIs.\n\nModule 3: Responsive Design and Mobile-first Approaches\n\nMobile-First Philosophy: Strategy and benefits of designing for mobile devices first.\nMedia Queries: Using breakpoints to adapt layouts for different screen sizes.\nResponsive Images: Using modern HTML tags (srcset\, sizes) and CSS techniques to serve optimized images.\nFluid Layouts: Using relative units (%\, em\, rem\, vw\, vh) for flexible component sizing.\nCross-Browser Compatibility: Ensuring websites function correctly on different browsers and devices.\n\nModule 4: Content Management Systems (CMS)\n\nIntroduction to CMS: Understanding the benefits of using a CMS like WordPress.\nWordPress Installation & Configuration: Manual installation and using hosting control panels.\nTheme Development: Converting HTML/CSS templates into custom WordPress themes; understanding the template hierarchy.\nPlugin Integration: Sourcing\, evaluating\, and customizing plugins to extend functionality.\nContent Management: Creating and managing posts\, pages\, and custom post types for clients.\n\nModule 5: Website Optimization and Security\n\nPerformance Optimization: Techniques for minification\, lazy loading\, and reducing HTTP requests to improve page load times.\nSearch Engine Optimization (SEO): On-page SEO techniques\, including meta tags\, semantic structure\, and sitemaps.\nWebsite Security: Common vulnerabilities (e.g.\, SQL injection\, XSS)\, implementing HTTPS\, and best practices for securing a WordPress site.\nWeb Hosting & Deployment: transferring files via FTP/SFTP\, managing databases\, and deploying a site from a local environment to a live server.\nAnalytics: Integrating tools like Google Analytics to track website traffic and user behavior.
URL:https://excelbi.co.za/event/workshop-website-development/2027-01-04/
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/web-development.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270105T090000
DTEND;TZID=UTC:20270106T130000
DTSTAMP:20261108T121036
CREATED:20260415T071948Z
LAST-MODIFIED:20260429T060336Z
UID:10000098-1799139600-1799240400@excelbi.co.za
SUMMARY:Microsoft Word Essentials
DESCRIPTION:Microsoft Word Essentials\nCourse Overview:\nThis course introduces learners to the fundamental tools and features of Microsoft Word. Participants will gain confidence in creating\, formatting\, and managing documents for personal\, academic\, or professional use. The training covers the Word interface\, text and paragraph formatting\, working with lists\, inserting images and shapes\, and setting up basic page layouts for printing. \nBy the end of the course\, learners will be able to: \n\nNavigate the Word interface and use the Ribbon effectively.\nCreate\, save\, and manage documents.\nApply essential text and paragraph formatting for readability.\nOrganize information using lists and bullets.\nEnhance documents with images\, shapes\, and text boxes.\nAdjust page settings and prepare documents for printing.\n\nThis essentials course is ideal for beginners or those looking to refresh their Word skills. \nOutline\nModule 1: Introduction to Microsoft Word \n\nOverview of Microsoft Word and its uses\nNavigating the Word interface\nUnderstanding the Ribbon\, Tabs\, and Groups\nCustomizing the Quick Access Toolbar\n\nModule 2: Creating and Managing Documents \n\nStarting a new document\nOpening existing documents\nSaving documents (Save vs. Save As\, file formats)\nClosing and exiting Word\n\nModule 3: Basic Text Formatting \n\nEntering and editing text\nUsing font styles (bold\, italic\, underline)\nChanging font type\, size\, and color\nCopying and pasting text efficiently\nUsing the Format Painter\n\nModule 4: Paragraph Formatting \n\nAligning text (left\, right\, center\, justify)\nAdjusting line and paragraph spacing\nIndentation and tabs\nApplying borders and shading\n\nModule 5: Lists and Bullets \n\nCreating bulleted lists\nCreating numbered lists\nCustomizing bullets and numbering\nMultilevel lists\n\nModule 6: Working with Visual Elements \n\nInserting images from file and online sources\nResizing\, moving\, and cropping images\nApplying picture styles and effects\nInserting and formatting shapes\nUsing text boxes\n\nModule 7: Page Layout and Printing \n\nSetting page margins\, orientation\, and paper size\nAdding headers and footers\nPage numbering\nUsing Page Breaks and Section Breaks\nPrint Preview and printing options
URL:https://excelbi.co.za/event/microsoft-word-essentials/2027-01-05/
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/Word-Basic-1.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270105T090000
DTEND;TZID=UTC:20270106T130000
DTSTAMP:20261108T121036
CREATED:20260415T072918Z
LAST-MODIFIED:20260415T073019Z
UID:10000271-1799139600-1799240400@excelbi.co.za
SUMMARY:Microsoft PowerPoint Introduction
DESCRIPTION:Overview\nThis beginner-friendly course is designed to take you from knowing nothing about PowerPoint to being able to create\, design\, and deliver professional-looking presentations. You will learn the core functionalities of the software\, from adding text and images to applying simple animations and delivering your presentation with confidence. No prior experience is necessary. \nTarget Audience \nStudents\, office workers\, entrepreneurs\, teachers\, and anyone who needs to create effective visual presentations. \nUpon completion\, students will be able to: \n\nConfidently navigate the PowerPoint interface and use key tabs.\nCreate a new presentation\, add various slide types\, and manage slide order.\nFormat text\, shapes\, and images for visual impact and consistency.\nInsert and manipulate pictures\, icons\, videos\, and other media.\nApply and customize slide transitions and object animations.\nUtilize speaker tools and practice techniques to deliver a polished presentation.\n\nOutline\nModule 1: Navigating the PowerPoint Environment \n\nGet comfortable with the PowerPoint workspace and understand its main components.\n\nWelcome & Overview: What is PowerPoint? Understanding the Ribbon\, Quick Access Toolbar\, and Status Bar.\nViews and Zoom: Using Normal\, Slide Sorter\, Reading\, and Slide Show views effectively.\nWorking with Files: Creating a new blank presentation\, using templates\, opening\, saving (“Save” vs. “Save As”)\, and exporting to PDF.\n\n\n\nModule 2: Creating and Managing Slides \n\nBuild the structural foundation of your presentation.\n\nAdding Slides: Inserting new slides and choosing the right slide layout (Title\, Title and Content\, Section Header\, etc.).\nManaging Content Placeholders: Adding text and content into predefined boxes.\nSlide Management: Organizing slides using Slide Sorter view\, duplicating\, moving\, and deleting slides.\n\n\n\nModule 3: Basic Text and Shape Formatting \n\nMake your content visually clear and engaging.\n\nWorking with Text: Adding & formatting text (Font\, Size\, Color)\, using bullet points and numbered lists\, and working with text boxes (vs. placeholders).\nIntroduction to Shapes: Inserting shapes\, applying styles and fills\, adding text to shapes\, and adjusting size and rotation.\nAlignment and Ordering: Using alignment guides\, distributing objects evenly\, and managing object layers (Bring Forward/Send Backward).\n\n\n\nModule 4: Inserting Images and Multimedia \n\nEnhance your presentation with visual and audio elements.\n\nWorking with Images: Inserting pictures from your device and online sources\, using the Picture Format tab to crop\, apply corrections\, artistic effects\, and remove backgrounds.\nIcons & Illustrations: Using PowerPoint’s built-in library of icons\, 3D models\, and scalable vector graphics.\nAdding Video & Audio: Inserting video and audio files\, formatting video playback\, and adjusting audio settings.\n\n\n\nModule 5: Applying Basic Transitions and Animations \n\nAdd subtle movement to guide your audience’s attention.\n\nSlide Transitions: Applying transitions between slides\, effect options\, and timing (duration\, advance on click vs. after time).\nObject Animations: Applying Entrance\, Emphasis\, and Exit animations to text and objects.\nAnimation Pane: Using the Animation Pane to modify effect options\, change the order of animations\, and set timing (start: on click\, with previous\, after previous).\n\n\n\nModule 6: Presentation Tips and Techniques (The Final Rehearsal) \n\nPrepare to deliver your presentation confidently and professionally.\n\nReview and Proofing: Using the Spelling & Thesaurus tool\, adding and reviewing speaker notes.\nPresenter View: Configuring and using Presenter View to see notes\, jump to slides\, and use the pen/highlighter tool during a presentation.\nRehearsal & Delivery: Setting up slide show options (monitor settings)\, rehearsing timings\, and practicing key presentation skills (pace\, tone\, body language).\nSharing Your Work: Tips for presenting online (via Teams/Zoom) and packaging your presentation for email.
URL:https://excelbi.co.za/event/microsoft-powerpoint-introduction/2027-01-05/
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/Powerpoint-Basics.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270112T090000
DTEND;TZID=UTC:20270113T130000
DTSTAMP:20261108T121036
CREATED:20260415T073324Z
LAST-MODIFIED:20260415T075959Z
UID:10000291-1799744400-1799845200@excelbi.co.za
SUMMARY:Microsoft PowerPoint Intermediate
DESCRIPTION:Overview\nElevate your presentations from simple slides to powerful\, professional storytelling tools. Master advanced design\, animation\, collaboration\, and delivery techniques to engage any audience. \nTarget Audience: \nUsers comfortable with PowerPoint basics who create frequent presentations and want to improve their design efficiency\, visual impact\, and delivery skills. \nUpon completion\, students will be able to: \n\nUse the Slide Master to create consistent\, branded presentations.\nApply and sequence advanced animations and transitions for narrative effect.\nCreate and save custom templates for repeated use.\nImport and customize charts and graphs from Excel.\nCollaborate on presentations using comments and co-authoring features.\nDeliver polished presentations using advanced presenter tools and techniques.\n\nOutline\nModule 1: Customizing Slide Masters \n\nSlide Master View: Understanding the hierarchy between the Master and individual layouts.\nGlobal Formatting: Setting default fonts\, colors\, placeholder positions\, and background graphics on the Master.\nCustom Layouts: Creating new slide layouts with specific placeholders for different content types.\n\nModule 2: Using Advanced Animation and Transition Effects \n\nAnimation Pane Mastery: Using the Animation Pane to manage complex sequences\, change timing\, and set triggers.\nMorph Transition: Creating seamless\, cinematic animations between slides with the Morph transition.\nEffect Options: Using motion paths\, animating charts\, and adjusting timing for professional pacing.\n\nModule 3: Creating Custom Templates \n\nTemplate Fundamentals: Defining a template (.potx file) vs. a presentation (.pptx file).\nBuilding from the Master: Designing a template using the customized Slide Master from Module 1.\nSaving and Using: Saving a file as a custom template and creating a new presentation from it.\n\nModule 4: Incorporating Charts and Graphs \n\nLinking vs. Embedding: Inserting charts from Excel and understanding the benefits of linking data.\nFormatting Charts: Using Chart Tools (Design and Format tabs) to customize style\, colors\, and elements.\nAnimating Charts: Applying animations to chart elements to introduce data point-by-point.\n\nModule 5: Collaborating with Others \n\nComments: Using the Comments pane to add\, review\, and resolve feedback on specific slides.\nCo-Authoring: Real-time collaboration: simultaneously editing a presentation stored on OneDrive or SharePoint.\nComparison and Merging: Comparing and merging two versions of a presentation to incorporate changes.\n\nModule 6: Delivering Presentations Effectively \n\nPresenter View Deep Dive: Using tools like speaker notes\, slide preview\, pen\, and laser pointer.\nRehearsal Techniques: Using the Rehearse Timings feature to practice pacing and delivery.\nPresentation Tips: Managing audience questions\, handling technical setup\, and presenting online.
URL:https://excelbi.co.za/event/microsoft-powerpoint-intermediate/2027-01-12/
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/Powerpoint-Intemediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270118T090000
DTEND;TZID=UTC:20270120T130000
DTSTAMP:20261108T121036
CREATED:20260415T073606Z
LAST-MODIFIED:20260415T075928Z
UID:10000311-1800262800-1800450000@excelbi.co.za
SUMMARY:Microsoft PowerPoint Advanced
DESCRIPTION:Course Overview:\nPush the boundaries of PowerPoint. Master advanced design\, seamless multimedia integration\, interactive navigation\, and powerful collaboration tools to create captivating\, professional-grade presentations that stand out. Target Audience: Marketing professionals\, trainers\, educators\, designers\, and anyone who creates high-stakes presentations and needs to leverage PowerPoint’s most powerful features. Upon completion\, students will be able to: \n\nDesign visually sophisticated and dynamic presentations using advanced graphic techniques.\nSeamlessly integrate and control video\, audio\, and 3D models.\nConnect PowerPoint with Word and Excel for live data updates.\nBuild non-linear\, interactive presentations with custom navigation.\nManage complex review processes with advanced collaboration and comparison tools.\nShare and present professionally using advanced broadcasting and export options.\n\nOutline\nModule 1: Designing Dynamic Presentations \n\nAdvanced Graphic Techniques: Using Merge Shapes (Combine\, Fragment\, Subtract) to create custom graphics. Working with gradients and transparency.\nLayering and Depth: Mastering the Selection Pane to manage complex object layers and create parallax scrolling effects.\nDesign Consistency: Using the Slide Master to create custom layouts for different types of content (e.g.\, quote slides\, section dividers).\n\nModule 2: Advanced Multimedia Features \n\nVideo and Audio Control: Trimming video\, creating poster frames\, formatting playback options (fade\, loop\, play across slides)\, and embedding online video.\n3D Models: Inserting and animating 3D models from the online library or from files.\nScreen Recording: Recording and embedding actions from your desktop directly into a slide.\n\nModule 3: Integrating PowerPoint with Other Office Apps \n\nLinking Excel Data: Embedding and linking Excel charts and ranges that update automatically when the source data changes.\nWord Integration: Converting a Word outline into a PowerPoint presentation and vice-versa.\nObject Linking and Embedding (OLE): Understanding the difference between embedded and linked objects.\n\nModule 4: Custom Slide Shows and Interactive Features \n\nCustom Slide Shows: Creating and managing multiple custom show paths within a single file.\nHyperlinks and Action Buttons: Using hyperlinks to navigate to other slides\, custom shows\, documents\, or websites. Creating a navigation menu.\nTriggers: Using animation triggers to start effects by clicking on specific objects\, creating interactive quizzes or diagrams.\n\nModule 5: Comprehensive Review Tools for Team Collaboration \n\nAdvanced Comments: Using the Comments pane for threaded conversations and @mentions to tag collaborators.\nCompare and Combine: Merging changes from multiple reviewed versions of a presentation into a single final file.\nCo-Authoring Best Practices: Real-time collaboration on SharePoint/OneDrive\, managing conflicts\, and version history.\n\nModule 6: Advanced Presentation Sharing Options \n\nExport Options: Creating a video presentation\, packaging for CD/USB (Package Presentation for CD)\, and exporting as a PDF with options.\nPresenting Online: Using Office Presentation Service or Microsoft Teams to broadcast a slide show online.\nSecuring and Protecting: Using the Document Inspector to remove metadata and encrypting the presentation with a password.
URL:https://excelbi.co.za/event/microsoft-powerpoint-advanced/2027-01-18/
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/Powerpoint-Advanced.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270118T090000
DTEND;TZID=UTC:20270122T170000
DTSTAMP:20261108T121036
CREATED:20260415T075350Z
LAST-MODIFIED:20260415T075350Z
UID:10000388-1800262800-1800637200@excelbi.co.za
SUMMARY:Project Management Professional (PMP) Prep Course
DESCRIPTION:Overview\nThis intensive course provides a complete deep dive into the PMBOK® Guide and the three exam domains (People\, Process\, and Business Environment) as outlined by PMI. It is designed to equip experienced project managers with the knowledge\, strategies\, and practical application skills needed to pass the PMP® exam on the first attempt. \nTarget Audience: \nExperienced project managers who meet PMI’s prerequisites and are preparing to take the PMP® certification exam. \nUpon completion\, students will be able to: \n\nMaster the concepts\, processes\, and knowledge areas from the PMBOK® Guide – Seventh Edition and The Standard for Project Management.\nUnderstand the exam’s emphasis on the three domains: People (42%)\, Process (50%)\, and Business Environment (8%).\nApply predictive\, agile\, and hybrid approaches to project management scenarios.\nConfidently answer situational and complex multiple-choice questions.\nDevelop a personalized study plan and test-taking strategy for the PMP® exam.\n\nOutline\nModule 1: In-depth Study of the PMBOK® Guide and Foundational Concepts \n\nThe PMBOK® Guide – 7th Ed: Key concepts: value delivery\, models\, methods\, and artifacts.\nThe Standard for Project Management: The 12 principles and 8 performance domains.\nProject Management Models & Methods: Tailoring models (e.g.\, Tuckman’s ladder) and methods (e.g.\, estimating\, meeting management) to scenarios.\n\nModule 2: Detailed project integration management \n\nProject Integration Management: Developing project charter\, project plan\, directing work\, managing knowledge\, and closing.\nProject Scope Management: Gathering requirements\, defining scope\, creating WBS\, and validating/controlling scope.\nProject Schedule Management: Sequencing activities\, estimating durations\, developing and controlling the schedule (CPM\, PERT).\n\nModule 3: Advanced project scope and time management \n\nProject Cost Management: Estimating costs\, determining budget\, and controlling costs (Earned Value Management – EVM).\nProject Quality Management: Planning quality\, managing quality\, and controlling quality.\nProject Resource Management: Planning\, acquiring\, developing\, and managing the team.\n\nModule 4: Strategies for cost management and budgeting \n\nEssentials of Stakeholder Management: Identifying stakeholders\, planning engagement\, and managing engagement.\nTeam Leadership & Dynamics: Empowering teams\, training\, conflict management\, and motivating team members.\nCommunication Management: Planning\, managing\, and monitoring project communications.\n\nModule 5: Comprehensive risk management approaches \n\nComprehensive Risk Management: Planning\, identifying\, analyzing (qualitative/quantitative)\, planning responses\, and implementing responses.\nProject Procurement Management: Planning\, conducting\, and controlling procurements.\nThe Business Environment Domain (8%): How projects align with organizational strategy\, compliance\, and delivering value.\n\nModule 6: Techniques for quality management and assurance \n\nAgile Principles & Mindset: Key agile concepts\, roles (SM\, PO)\, and artifacts (backlog\, increments).\nHybrid Life Cycles: Combining predictive and adaptive approaches.\nTailoring Techniques: Modifying processes to fit unique project contexts.\n\nModule 7: Essentials of stakeholder management and communication \n\nStakeholder Identification:\n\nTechniques: Brainstorming\, org charts\, reviewing documents.\nOutput: Stakeholder Register.\n\n\nStakeholder Analysis:\n\nPower/Interest Grid: Categorize stakeholders (e.g.\, Manage Closely\, Keep Satisfied).\nAssess influence\, expectations\, and potential impact.\n\n\nCommunication Planning:\n\nDevelop a Stakeholder Engagement Plan.\nTailor messages based on stakeholder needs (frequency\, format\, channel).\n\n\nEngagement & Monitoring (20 mins):\n\nStrategies: Collaboration\, consultation\, reporting.\nAdjust plans based on feedback and changing dynamics.
URL:https://excelbi.co.za/event/project-management-professional-pmp-prep-course/2027-01-18/
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/Project-Management-Professional-PMP-Prep-Course.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270125T090000
DTEND;TZID=UTC:20270129T130000
DTSTAMP:20261108T121036
CREATED:20260416T064741Z
LAST-MODIFIED:20260416T064741Z
UID:10000716-1800867600-1801227600@excelbi.co.za
SUMMARY:Workshop: Computer Programming
DESCRIPTION:Course Objective:\nThis certificate is designed to equip students with a strong foundation in modern programming principles and practices\, preparing them for a career in software development. \nOutline\nModule 1: Programming Fundamentals\n\nIntroduction to Programming Paradigms: High-level overview of different programming styles.\nVariables and Data Types: Understanding how to store and manipulate different kinds of data.\nOperators and Expressions: Learning to perform calculations and logical operations.\nControl Flow: Using conditional statements (if/else) and loops (for\, while) to control program execution.\nFunctions and Modular Programming: Breaking down complex problems into smaller\, reusable blocks of code.\nBasic Input/Output: Interacting with the user and external files.\nDebugging and Error Handling: Identifying and resolving common programming errors.\n\nModule 2: Object-Oriented Programming (OOP)\n\nIntroduction to OOP: Core concepts of classes and objects.\nThe Four Pillars of OOP: Detailed exploration of Encapsulation\, Inheritance\, Polymorphism\, and Abstraction.\nClass Design and Relationships: Creating and using classes\, including constructors and access modifiers.\nInterfaces and Abstract Classes: Designing contracts and blueprints for objects.\nUML Diagrams: Using Unified Modeling Language to visualize class structures.\n\nModule 3: Data Structures and Algorithms\n\nFundamental Data Structures: In-depth study of arrays\, linked lists\, stacks\, and queues.\nAdvanced Data Structures: Introduction to trees\, graphs\, and hash tables.\nAlgorithmic Complexity: Analyzing the efficiency of algorithms using Big O notation.\nSearching and Sorting Algorithms: Implementing and comparing classic algorithms like binary search\, bubble sort\, and quicksort.\nRecursion: Understanding recursive solutions to problems and when to use them.\n\nModule 4: Software Development Lifecycle (SDLC)\n\nSDLC Models: Exploring methodologies like Waterfall\, Agile\, and Scrum.\nRequirements Gathering: Defining the goals and scope of a software project.\nSystem Design: Creating a blueprint for the application’s architecture.\nCoding and Implementation: Following coding standards and best practices.\nTesting and Quality Assurance: Ensuring the software is functional and bug-free.\nDocumentation: Creating clear and comprehensive documentation for code and users.\n\nModule 5: Application Deployment and Maintenance\n\nVersion Control: Using Git to track and manage code changes.\nContinuous Integration/Continuous Delivery (CI/CD): Automating the build and deployment process.\nDeployment Strategies: Releasing applications to different environments (e.g.\, staging\, production).\nCloud Services and Containerization: Introduction to platforms like AWS\, Google Cloud\, and technologies like Docker.\nPost-Deployment Activities: Monitoring\, maintenance\, updates\, and bug fixes.
URL:https://excelbi.co.za/event/workshop-computer-programming/2027-01-25/
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/computer-programming.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270201T090000
DTEND;TZID=UTC:20270205T130000
DTSTAMP:20261108T121036
CREATED:20260415T075640Z
LAST-MODIFIED:20260415T075640Z
UID:10000408-1801472400-1801832400@excelbi.co.za
SUMMARY:Fundamentals of Agile Project Management
DESCRIPTION:Overview\nThis course provides a solid foundation in the Agile mindset and practices. Learn the core values\, principles\, and popular frameworks like Scrum to deliver value to customers faster\, adapt to change\, and foster collaborative\, high-performing teams. \nTarget Audience: \nProject managers\, product managers\, software developers\, team leads\, and anyone involved in product development or project delivery who wants to understand and apply Agile methodologies. \nUpon completion\, students will be able to: \n\nExplain the Agile mindset\, values\, and principles and contrast them with traditional project management.\nDescribe the Scrum framework\, its roles\, events\, and artifacts.\nUnderstand the responsibilities of the Scrum Master\, Product Owner\, and Development Team.\nParticipate in basic Agile planning\, estimation\, and iterative development cycles.\nDefine key concepts like Sprints\, User Stories\, and the Product Backlog.\n\nOutline\nModule 1: Introduction to Agile Methodologies \n\nThe Origins of Agile: The Agile Manifesto and the need for a more adaptive approach.\nAgile vs. Waterfall: Comparing and contrasting predictive (Waterfall) and adaptive (Agile) life cycles.\nBeyond Software: How Agile is used in various industries beyond IT.\n\nModule 2: Key Principles and Values of Agile \n\nThe Four Values of the Agile Manifesto: Individuals and interactions\, Working software\, Customer collaboration\, Responding to change.\nThe Twelve Principles: Understanding the guiding principles behind the Agile manifesto (e.g.\, satisfying the customer\, welcoming change\, delivering frequently).\nThe Agile Mindset: Shifting from a fixed to a growth mindset\, emphasizing collaboration and learning.\n\nModule 3: Overview of Scrum Framework \n\nWhat is Scrum?: Defining the framework: empirical process control\, transparency\, inspection\, and adaptation.\nThe Three Pillars of Scrum: Transparency\, Inspection\, and Adaptation.\nScrum Artifacts: Introduction to the Product Backlog\, Sprint Backlog\, and Increment.\n\nModule 4: Roles in an Agile team: Scrum Master\, Product Owner\, and Team Members \n\nThe Product Owner (PO): Maximizing product value\, managing the Product Backlog\, and stakeholder management.\nThe Scrum Master (SM): Serving the PO\, the Team\, and the organization; removing impediments; and ensuring Scrum is understood.\nThe Development Team: Self-organizing\, cross-functional teams responsible for delivering a “Done” increment each Sprint.\n\nModule 5: Basics of Agile Planning and Estimation \n\nThe Product Backlog: The living\, ordered list of everything that is needed in the product.\nUser Stories: Writing requirements from the user’s perspective (As a… I want… So that…).\nAgile Estimation: Techniques like Story Points and Planning Poker for relative sizing\, not time-based estimates.\n\nModule 6: Introduction to Sprints and Iterations \n\nThe Sprint Cycle: The container for all other Scrum events\, typically 1-4 weeks long.\nSprint Events: Overview of Sprint Planning\, Daily Scrum\, Sprint Review\, and Sprint Retrospective.
URL:https://excelbi.co.za/event/fundamentals-of-agile-project-management/2027-02-01/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Fundamentals-of-Agile-Project-Management.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270201T090000
DTEND;TZID=UTC:20270205T130000
DTSTAMP:20261108T121036
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:20270202T090000
DTEND;TZID=UTC:20270203T130000
DTSTAMP:20261108T121036
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:20270830T080000
DTEND;TZID=UTC:20270903T170000
DTSTAMP:20261108T121036
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:20261108T121036
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