BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Business Institute - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20261207T090000
DTEND;TZID=UTC:20261211T130000
DTSTAMP:20261108T084709
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:20261108T084709
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:20261108T084709
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:20261108T084709
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:20261108T084709
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:20261108T084709
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:20261108T084709
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:20261108T084709
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:20261108T084709
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:20261108T084709
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:20261108T084709
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
END:VCALENDAR