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:20261218T130000
DTSTAMP:20261108T111913
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:20261214T090000
DTEND;TZID=UTC:20261218T130000
DTSTAMP:20261108T111913
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:20261108T111913
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
END:VCALENDAR