BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Business Institute - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel Business Institute
X-ORIGINAL-URL:https://excelbi.co.za
X-WR-CALDESC:Events for Excel Business Institute
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20260101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270217T130000
DTSTAMP:20261109T174738
CREATED:20260415T074448Z
LAST-MODIFIED:20260415T074448Z
UID:10000368-1802682000-1802869200@excelbi.co.za
SUMMARY:Microsoft Outlook Advanced
DESCRIPTION:Overview\nBecome an Outlook power user. Leverage advanced automation\, master complex calendar orchestration\, integrate seamlessly with the Microsoft ecosystem\, and implement robust security protocols for ultimate productivity and data protection. \nTarget Audience: \nExecutives\, administrative assistants\, project managers\, IT professionals\, and any power user who manages multiple priorities\, requires deep automation\, and needs to enforce strict security and organization. \nUpon completion\, students will be able to: \n\nDesign and implement sophisticated automation rules and Quick Steps for complex email management.\nDelegate calendar access and manage scheduling for others with detailed permissions.\nImplement a strategic mailbox cleanup and archiving plan to maintain performance and compliance.\nIntegrate Outlook with Teams\, OneNote\, and Power Automate for seamless workflow.\nUtilize advanced sharing and collaboration features for calendars and mailboxes.\nConfigure advanced security settings to protect against phishing and manage data privacy.\n\nOutline\nModule 1: Automating Tasks with Rules and Quick Steps \n\nAdvanced Rule Logic: Creating server-side rules with “AND/OR” conditions and exceptions for precise filtering.\nCustom Quick Steps: Designing multi-action Quick Steps to file\, categorize\, flag\, and forward emails in one click.\nRule Management and Troubleshooting: Organizing rule order for correct execution and debugging rules that fail.\n\nModule 2: Advanced Calendar Management \n\nCalendar Delegation: Granting and managing delegate permissions (Editor\, Author\, Reviewer) to manage another user’s calendar.\nScheduling on Behalf Of: Sending meeting invitations and responses as another person (requires delegate permissions).\nManaging Room & Equipment Resources: Scheduling and managing shared resources like conference rooms and projectors.\n\nModule 3: Mailbox Cleanup and Archiving \n\nManual and Auto-Archive: Configuring Auto-archive settings for folders and manually arching old items to PST files.\nMailbox Cleanup Tools: Using tools like “Empty Deleted Items” on exit and “Cleanup Tools” to manage space.\nOST/ PST Management: Understanding the difference between offline (OST) and archive (PST) data files and managing their size and location.\n\nModule 4: Integration with Other Microsoft Apps \n\nOutlook and Microsoft Teams: Scheduling Teams meetings from Outlook and managing RSVPs. Accessing Outlook contacts in Teams.\nOutlook and OneNote: Linking emails\, meetings\, and contacts to OneNote pages for integrated note-taking and project management.\nIntroduction to Power Automate: Creating simple flows to automate actions between Outlook and other apps (e.g.\, saving email attachments to OneDrive).\n\nModule 5: Collaboration Tools and Sharing Features \n\nAdvanced Calendar Sharing: Publishing calendars online\, sharing via email with detailed permission levels (Free/Busy\, Details\, Editor).\nShared Mailboxes: Using and managing shared mailboxes for team email addresses (e.g.\, info@company.com) without a separate login.\nDelegate Access vs. Sharing: Understanding the difference between granting delegate access and simply sharing a folder.\n\nModule 6: Advanced Security Features and Privacy Settings \n\nPhishing and Junk Mail Protection: Configuring the Junk Email filter\, managing blocked senders\, and identifying sophisticated phishing attempts.\nEncryption and Permissions: Using IRM (Information Rights Management) to send encrypted emails and prevent forwarding\, copying\, or printing.
URL:https://excelbi.co.za/event/microsoft-outlook-advanced/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Outlook-Advanced.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270219T130000
DTSTAMP:20261109T174738
CREATED:20260415T093710Z
LAST-MODIFIED:20260415T093710Z
UID:10000448-1802682000-1803042000@excelbi.co.za
SUMMARY:Agile Project Management with Scrum
DESCRIPTION:Overview\nThis advanced course delves deep into the Scrum framework\, moving beyond the basics to master the practices\, artifacts\, and metrics that drive successful iterative delivery. Learn to manage backlogs\, lead effective ceremonies\, and foster a high-performing\, adaptable team environment. \nTarget Audience:\nProduct Owners\, Scrum Masters\, Development Team members\, project managers\, and Agile coaches with a basic understanding of Scrum who want to deepen their practical expertise. \nUpon completion\, students will be able to: \n\nFacilitate and enhance all Scrum ceremonies for maximum value.\nCreate\, refine\, and manage a dynamic Product Backlog effectively.\nPlan and execute a Sprint with a clear goal and definition of “Done.”\nUtilize key Scrum metrics (velocity\, burn-down charts) to monitor progress and forecast.\nApply strategies to adapt to change and remove impediments.\nFoster a collaborative\, self-organizing\, and high-performing team culture.\n\nOutline\nModule 1: Advanced Scrum Practices and Ceremonies \n\nCeremony Deep Dive: Advanced techniques for facilitating Sprint Planning\, Daily Scrum\, Sprint Review\, and Retrospective.\nDefinition of Ready (DoR) & Definition of Done (DoD): Establishing and applying team agreements to ensure quality and clarity.\nHandling Ceremony Anti-Patterns: Identifying and addressing common dysfunctions (e.g.\, daily scrums becoming status meetings\, ineffective retrospectives).\n\nModule 2: Creating and Managing a Product Backlog \n\nBacklog Refinement (Grooming): Techniques for effective refinement sessions\, splitting large stories\, and estimating.\nPrioritization Techniques: Advanced methods beyond MoSCoW\, such as Weighted Shortest Job First (WSJF) and Kano Model.\nEpics\, Themes\, and User Stories: Structuring the backlog from large initiatives to actionable user stories.\n\nModule 3: Sprint Planning and Execution \n\nEffective Sprint Goal Creation: Crafting a clear\, motivating\, and achievable Sprint Goal.\nCapacity-Based Planning: Planning based on team capacity and historical velocity\, not just wishful thinking.\nSprint Execution & Impediment Removal: The Scrum Master’s role in protecting the team and proactively removing blockers.\n\nModule 4: Monitoring Progress Through Scrum Metrics \n\nVelocity: Tracking and using velocity as a capacity planning tool\, not a performance indicator.\nBurn-down & Burn-up Charts: Interpreting these charts to understand progress and scope change.\nCumulative Flow Diagrams (CFD): Using CFDs to identify bottlenecks in the team’s workflow.\n\nModule 5: Handling Changes and Adaptability in Scrum \n\nManaging Scope Change Mid-Sprint: Protocols for handling new requests during a Sprint without disrupting the goal.\nThe Art of the Pivot: Knowing when to cancel a Sprint versus when to adapt the plan.\nRisk Management in Agile: Identifying and mitigating risks through iterative delivery and transparency.\n\nModule 6: Strategies for Effective Team Collaboration \n\nFostering Psychological Safety: Creating an environment where team members feel safe to experiment\, fail\, and speak up.\nConflict Resolution: Techniques for facilitating healthy conflict and resolving dysfunctions within the team.\n\nCollaboration Techniques: Practices like pair programming\, mob programming\, and swarming to enhance teamwork and knowledge sharing.
URL:https://excelbi.co.za/event/agile-project-management-with-scrum/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Agile-Project-Management-with-Scrum.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270219T130000
DTSTAMP:20261109T174738
CREATED:20260415T094147Z
LAST-MODIFIED:20260415T094147Z
UID:10000470-1802682000-1803042000@excelbi.co.za
SUMMARY:Advanced Risk Management in Projects
DESCRIPTION:Overview\nThis advanced course provides a deep dive into the sophisticated techniques and strategies used to identify\, analyze\, and mitigate risks in complex\, high-stakes projects. Move beyond the basics to master quantitative analysis\, develop robust response strategies\, and create a resilient project environment. \nTarget Audience: \nSenior Project Managers\, Program Managers\, Risk Management Specialists\, PMO leads\, and anyone responsible for managing risk on large\, complex\, or critical projects. \nUpon completion\, students will be able to: \n\nEmploy advanced techniques for comprehensive risk identification.\nConduct both qualitative and quantitative risk analysis to assess impact and probability.\nDevelop and implement sophisticated risk response strategies.\nDesign and execute a continuous risk monitoring and control plan.\nApply lessons learned from real-world case studies to their own projects.\n\nOutline\nModule 1: In-Depth Analysis of Risk Identification \n\nAdvanced Techniques: Delphi technique\, SWOT analysis\, assumption and constraint analysis\, and prompt lists.\nIdentifying Black Swans and Unknown Unknowns: Strategies for anticipating emergent and unpredictable risks.\nDocumenting Risks: Structuring a risk statement (Cause -> Risk -> Effect) and enhancing the risk register.\n\nModule 2: Qualitative and Quantitative Risk Assessment Techniques \n\nAdvanced Qualitative Analysis: Probability and Impact Matrix with weighted criteria\, risk categorization\, and risk urgency assessment.\nIntroduction to Quantitative Analysis: Understanding when and why to use quantitative methods.\nQuantitative Tools & Techniques: Expected Monetary Value (EMV) analysis\, Decision Tree Analysis\, and Monte Carlo simulations (conceptual understanding).\n\nModule 3: Risk Prioritization and Response Planning \n\nRisk Prioritization: Using the results of qualitative/quantitative analysis to create a ranked risk list.\nResponse Strategies for Threats: Deep dive into Avoid\, Transfer\, Mitigate\, and Accept strategies\, including creating contingency plans and fallback plans.\nResponse Strategies for Opportunities: Leveraging Exploit\, Enhance\, Share\, and Accept strategies.\n\nModule 4: Implementation of Risk Mitigation Strategies \n\nIntegrating Responses into the Project Plan: Adding risk responses (mitigation tasks\, contingency reserves) to the schedule\, budget\, and WBS.\nAllocating Resources: Assigning owners and ensuring they have the authority and resources to implement responses.\nContingency and Management Reserves: Establishing and managing reserve funds and buffers for known and unknown risks.\n\nModule 5: Monitoring and Controlling Project Risks \n\nRisk Audits and Reviews: Conducting periodic audits to assess the effectiveness of the risk management process.\nRisk Reassessment: Regularly re-evaluating existing risks and identifying new ones throughout the project lifecycle.\nVariance and Trend Analysis: Using performance data (Earned Value Management – EVM) to spot potential risk triggers.\n\nModule 6: Case Studies on Risk Management in Complex Projects \n\nCase Study 1: Large-Scale Infrastructure Project (e.g.\, cost overruns\, delays).\nCase Study 2: Technology Implementation (e.g.\, scope creep\, integration failure).\nCase Study 3: Pharmaceutical R&D (e.g.\, regulatory risks\, testing failures).
URL:https://excelbi.co.za/event/advanced-risk-management-in-projects/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Advanced-Risk-Management-in-Projects.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270219T130000
DTSTAMP:20261109T174738
CREATED:20260415T125252Z
LAST-MODIFIED:20260415T125252Z
UID:10000629-1802682000-1803042000@excelbi.co.za
SUMMARY:Certificate: Computer Science
DESCRIPTION:Course Overview:\nThis certificate provides a rigorous foundation in the theoretical and practical principles of computer science. It prepares graduates for further study and careers in software engineering\, data analysis\, and technology development by focusing on deep computational thinking and problem-solving. \nTarget Audience:\nStudents pursuing a career as software engineers\, systems architects\, data scientists\, or AI specialists. \nOutline\nModule 1: Core Concepts in Computer Science\n\nIntroduction to Computational Thinking\nDiscrete Mathematics for Computer Science (Logic\, Sets\, Relations)\nNumber Systems (Binary\, Hexadecimal) and Boolean Algebra\nHistory of Computing and Major Paradigms\nIntroduction to Theory of Computation (Automata\, Turing Machines)\nEthics in Computing and Professional Practice\n\n\nModule 2: Programming and Software Development\n\nFundamentals of a High-Level Language (e.g.\, Java\, Python)\nObject-Oriented Programming (OOP) Principles\nSoftware Design Patterns and Architecture\nVersion Control Systems (Git\, GitHub)\nIntegrated Development Environments (IDEs) and Debugging\nBuild Tools and Dependency Management\nIntroduction to Concurrency and Parallelism\n\nModule 3: Data Structures and Algorithms\n\nAlgorithm Analysis and Big-O Notation\nFundamental Data Structures (Arrays\, Linked Lists\, Stacks\, Queues)\nAdvanced Data Structures (Trees\, Graphs\, Hash Tables)\nSorting and Searching Algorithms\nRecursion and Dynamic Programming\nGraph Traversal and Pathfinding Algorithms\nAlgorithmic Problem-Solving Strategies\n\nModule 4: Computer Architecture and Operating Systems\n\nComputer Organization and Architecture (CPU\, Memory\, I/O)\nThe Machine Instruction Cycle\nOperating System Concepts (Process Management\, Scheduling)\nMemory Management and Virtual Memory\nFile Systems and Storage\nConcurrency\, Threading\, and Synchronization\nFundamentals of Computer Networking\n\nModule 5: Artificial Intelligence and Machine Learning\n\nHistory and Philosophy of Artificial Intelligence\nIntroduction to Intelligent Agents\nFundamental Machine Learning Concepts (Supervised vs. Unsupervised)\nBasic Algorithms (Linear Regression\, Decision Trees\, k-NN)\nIntroduction to Neural Networks and Deep Learning\nNatural Language Processing (NLP) Fundamentals\nEthics and Societal Impact of AI
URL:https://excelbi.co.za/event/certificate-computer-science/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Certificate-Computer-Science.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270215T090000
DTEND;TZID=UTC:20270219T130000
DTSTAMP:20261109T174738
CREATED:20260416T082426Z
LAST-MODIFIED:20260416T082426Z
UID:10000878-1802682000-1803042000@excelbi.co.za
SUMMARY:Workshop: Electronics
DESCRIPTION:Course Objective:\nTo equip learners with the knowledge and practical skills to analyze\, design\, build\, troubleshoot\, and repair electronic circuits and systems\, encompassing both analog and digital technologies. \nTarget Audience: \nElectronics technicians\, repair specialists\, hobbyists\, and individuals pursuing careers in electronics design\, maintenance\, or further engineering study. \nOutline\nModule 1: Circuit Analysis and Design\n\nDC Circuit Analysis: Advanced application of Ohm’s Law\, Kirchhoff’s Laws (KVL & KCL)\, Thevenin’s and Norton’s theorems.\nAC Circuit Analysis: Working with sinusoidal waveforms; understanding reactance and impedance in capacitive and inductive circuits.\nNetwork Theorems: Superposition\, nodal and mesh analysis for complex circuits.\nCircuit Simulation Software: Using tools like LTSpice or Multisim to model\, simulate\, and analyze circuit behavior before construction.\nPCB Design Introduction: Basics of schematic capture and designing a simple printed circuit board (PCB) layout.\n\nModule 2: Analog and Digital Electronics\n\nAnalog Electronics: In-depth study of diodes (rectifiers\, regulators)\, transistors (BJT and MOSFET amplifiers\, switches)\, and operational amplifiers (op-amps) in various configurations (inverting\, non-inverting\, filters).\nDigital Electronics: Boolean algebra\, logic gates\, combinational logic circuits\, flip-flops\, counters\, and sequential logic.\nData Conversion: Fundamentals of Analog-to-Digital (ADC) and Digital-to-Analog (DAC) converters.\nPower Supplies: Designing and troubleshooting linear and switched-mode power supply (SMPS) circuits.\n\nModule 3: Signal Processing\n\nAmplification: Designing single and multi-stage transistor amplifiers for voltage\, current\, and power gain.\nFilter Design: Designing and building passive and active filters (low-pass\, high-pass\, band-pass) to remove unwanted signal frequencies.\nOscillators: Principles of feedback and operation of oscillator circuits (e.g.\, RC\, LC\, crystal) to generate stable frequencies.\nModulation/Demodulation: Introduction to core concepts of AM and FM for communications.\n\nModule 4: Microcontroller Applications\n\nMicrocontroller Architecture: Understanding the core components of a MCU (CPU\, memory\, I/O ports\, timers\, ADC).\nEmbedded C Programming: Writing code to read digital/analog inputs\, control outputs\, and use communication protocols.\nPeripheral Interfacing: Connecting and programming sensors (e.g.\, temperature\, light)\, actuators (e.g.\, motors\, servos)\, and displays (e.g.\, LCD).\nCommunication Protocols: Implementing serial protocols like UART\, I2C\, and SPI for device communication.\nProject Integration: Designing and building a complete embedded system that performs a defined task.\n\nModule 5: Equipment Repair and Maintenance\n\nTroubleshooting Methodology: Advanced fault-finding techniques; using block diagrams and service manuals.\nTest Equipment Proficiency: Advanced use of oscilloscopes\, logic analyzers\, spectrum analyzers\, and LCR meters.\nComponent-Level Repair: Desoldering and replacing surface-mount (SMD) and through-hole components; diagnosing faulty ICs.\nPreventative Maintenance: Performing calibrations\, inspections\, and replacing wear components.\nSafety Standards: Adhering to high-voltage safety procedures and industry-standard repair practices
URL:https://excelbi.co.za/event/workshop-electronics/2027-02-15/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/electronics.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270216T090000
DTEND;TZID=UTC:20270217T130000
DTSTAMP:20261109T174738
CREATED:20260415T071247Z
LAST-MODIFIED:20260415T071247Z
UID:10000035-1802768400-1802869200@excelbi.co.za
SUMMARY:Microsoft Office Excel Intermediate
DESCRIPTION:Microsoft Office Excel Intermediate\nCourse Overview\nElevate your Excel skills beyond basics. Master powerful functions\, dynamic analysis with PivotTables\, and advanced data management techniques to transform raw data into actionable insights. \nTarget Audience: \nUsers comfortable with Excel basics (data entry\, simple formulas\, basic formatting) who need to analyze\, manage\, and present complex data sets. \nUpon completion\, students will be able to: \n\nBuild complex formulas using logical (IF\, AND/OR)\, lookup (VLOOKUP/XLOOKUP)\, and text functions.\nApply and manage Conditional Formatting to visually analyze data trends and patterns.\nCreate\, modify\, and filter PivotTables and PivotCharts to summarize large data sets.\nUse advanced filtering\, sorting\, and data tools to manage lists.\nLink data across multiple worksheets and workbooks.\nImplement Data Validation and protect worksheets and workbooks.\n\nOutline\nModule 1: Advanced Formulas and Functions \n\nLogical Functions: Using IF\, nested IFs\, AND\, and OR to make conditional calculations.\nLookup Functions: Using VLOOKUP (or XLOOKUP) to find and retrieve data from a table.\nText & Date Functions: Using functions like LEFT\, RIGHT\, CONCAT\, and DATE to manipulate text and date values.\n\nModule 2: Conditional Formatting Techniques \n\nBeyond Basic Highlighting: Using top/bottom rules\, data bars\, color scales\, and icon sets.\nCustom Rules: Creating new rules with custom formulas (e.g.\, format a cell if it is above the average of a range).\nManaging Rules: Editing\, deleting\, and controlling the order of multiple conditional formatting rules.\n\nModule 3: Introduction to PivotTables \n\nPivotTable Basics: Creating a PivotTable from a data range\, understanding the Field List.\nArranging Data: Adding fields to Rows\, Columns\, Values\, and Filters to shape your report.\nGrouping and Formatting: Grouping dates/numbers\, applying number formatting\, and changing summary calculations (Sum\, Count\, Average).\n\nModule 4: Advanced Data Sorting and Filtering \n\nCustom Sorts: Sorting data by multiple columns (e.g.\, sort by Region\, then by Sales descending).\nAdvanced Filter: Using the Advanced Filter tool to extract data based on complex\, multi-field criteria.\nTable Filters: Leveraging the powerful filtering capabilities of Excel Tables (slicers & timelines).\n\nModule 5: Working with Multiple Sheets and Workbooks \n\n3D Formulas:Referencing the same cell across multiple worksheets for summary calculations (e.g.\, SUM(Sheet1:Sheet3!B5)).\nLinking Workbooks: Creating formulas that reference cells in other open workbooks.\nConsolidating Data: Using the Consolidate tool to combine data from multiple sheets.\n\nModule 6: Data Validation and Protection \n\nData Validation: Setting rules to restrict data entry (e.g.\, whole numbers\, dates\, custom lists for drop-down menus).\nInput Messages and Error Alerts: Creating prompts and custom error messages for users.\nProtection: Locking cells\, protecting a worksheet with a password\, and protecting workbook structure.
URL:https://excelbi.co.za/event/microsoft-office-excel-intermediate/2027-02-16/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/03/Excel-Intermediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270222T090000
DTEND;TZID=UTC:20270224T130000
DTSTAMP:20261109T174738
CREATED:20260415T071621Z
LAST-MODIFIED:20260415T071621Z
UID:10000065-1803286800-1803474000@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/2027-02-22/
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:20270301T090000
DTEND;TZID=UTC:20270305T130000
DTSTAMP:20261109T174738
CREATED:20260416T065613Z
LAST-MODIFIED:20260416T065719Z
UID:10000736-1803891600-1804251600@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-03-01/
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:20270301T090000
DTEND;TZID=UTC:20270305T130000
DTSTAMP:20261109T174738
CREATED:20260416T083848Z
LAST-MODIFIED:20260416T083848Z
UID:10000917-1803891600-1804251600@excelbi.co.za
SUMMARY:Workshop: PC Engineering
DESCRIPTION:Overview\nTo provide learners with the practical skills and theoretical knowledge to assemble\, configure\, upgrade\, maintain\, and troubleshoot personal computer hardware\, software\, and basic network connectivity. \nTarget Audience:\nAspiring PC technicians\, IT support staff\, hobbyists\, and individuals seeking a foundation in computer hardware and repair. \nOutline\nModule 1: Introduction to PC Hardware and Software\n\nComputer Fundamentals: The function of a PC and the computing cycle (Input\, Process\, Output\, Storage).\nHardware Components: Identification and function of core components: case\, PSU\, motherboard\, CPU\, RAM\, storage\, GPU.\nSoftware Overview: Distinction between firmware (BIOS/UEFI)\, operating systems (Windows\, Linux)\, and application software.\nHardware Compatibility: Understanding form factors (e.g.\, ATX\, mATX) and interoperability between components.\nSafety and Tools: Proper use of tools (screwdrivers\, anti-static wrist strap) and electrostatic discharge (ESD) safety procedures.\n\nModule 2: Motherboards and Processors\n\nMotherboard Anatomy: Sockets\, chipsets\, expansion slots (PCIe)\, RAM slots\, headers\, and connectors (SATA\, M.2\, front-panel).\nCPU Technology: Understanding processor specifications (cores\, threads\, clock speed\, cache)\, architectures (Intel vs. AMD)\, and cooling solutions (air vs. liquid).\nBIOS/UEFI Firmware: Navigating the firmware interface\, configuring boot order\, enabling virtualization\, and updating firmware.\nPractical Skills: Hands-on installation of a CPU\, CPU cooler\, and motherboard into a case.\n\nModule 3: Storage Devices and Data Management\n\nStorage Technologies: Characteristics of HDDs\, SSDs (SATA & NVMe)\, and optical drives.\nStorage Configuration: Partitioning\, formatting (NTFS\, exFAT\, APFS)\, and drive initialization.\nRAID Concepts: Understanding RAID levels (0\, 1\, 5\, 10) for performance and redundancy.\nData Management: File systems\, folder structures\, and data migration techniques.\nBackup and Recovery: Implementing backup strategies and using tools for data recovery and system imaging.\n\nModule 4: Network Configuration and Management\n\nNetworking Fundamentals: TCP/IP basics\, IPv4 addressing\, subnet masks\, default gateways\, and DNS.\nNetwork Hardware: Purpose and setup of routers\, switches\, and network interface cards (NIC).\nNetwork Types: Configuring and securing wired (Ethernet) and wireless (Wi-Fi) connections on a client PC.\nNetwork Troubleshooting: Using command-line tools (ipconfig\, ping\, tracert) to diagnose and resolve connectivity issues.\nResource Sharing: Setting up and accessing shared folders and printers on a local network.\n\nModule 5: PC Maintenance and Repair\n\nTroubleshooting Methodology: A structured approach to problem-solving (e.g.\, Identify\, Theory\, Test\, Plan\, Implement\, Verify\, Document).\nHardware Diagnostics: Troubleshooting POST issues\, component failures\, overheating\, and power problems.\nSoftware Diagnostics: Resolving OS boot errors\, driver conflicts\, application crashes\, and malware removal.\nPreventative Maintenance: Physical cleaning\, managing startup programs\, disk cleanup\, defragmentation\, and updating software/drivers.\nProfessional Practice: Customer communication\, documenting repairs\, and ethical considerations.
URL:https://excelbi.co.za/event/workshop-pc-engineering/2027-03-01/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/pc-engineering.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270302T090000
DTEND;TZID=UTC:20270303T130000
DTSTAMP:20261109T174738
CREATED:20260415T071948Z
LAST-MODIFIED:20260429T060336Z
UID:10000100-1803978000-1804078800@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-03-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/Word-Basic-1.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270308T090000
DTEND;TZID=UTC:20270312T130000
DTSTAMP:20261109T174738
CREATED:20260416T070448Z
LAST-MODIFIED:20260416T071000Z
UID:10000764-1804496400-1804856400@excelbi.co.za
SUMMARY:Certificate: Information Technologies Operations
DESCRIPTION:Course Objective:\nTo provide learners with the fundamental theoretical knowledge and practical skills required to understand\, assemble\, test\, troubleshoot\, and design basic electronic circuits and systems. \nTarget Audience: \nSchool leavers\, electronics enthusiasts\, technicians-in-training\, and individuals seeking a foundation for a career in electronics repair\, assembly\, or further engineering study. \nOutline\nModule 1: Basic Electronics and Circuit Theory\n\nFundamental Concepts: Atomic structure\, charge\, current\, voltage\, resistance\, and power.\nOhm’s Law and Power Law: Calculations and applications.\nCircuit Analysis: Series and parallel circuits; calculating total resistance\, current\, and voltage.\nDC Circuit Principles: Kirchhoff’s Current Law (KCL) and Kirchhoff’s Voltage Law (KVL).\nEnergy and Power: Understanding power dissipation and energy consumption in circuits.\nIntroduction to Capacitance and Inductance: How capacitors and inductors work in DC circuits (charging/discharging).\n\nModule 2: Components and Devices\n\nPassive Components: Resistors (types\, color codes\, values)\, Capacitors (types\, values)\, Inductors.\nSemiconductor Fundamentals: Conductors\, insulators\, and semiconductors.\nDiodes: PN junction theory\, rectifier diodes\, LEDs\, Zener diodes.\nTransistors: Bipolar Junction Transistors (BJTs) as switches and amplifiers; introduction to MOSFETs.\nOther Devices: Switches\, relays\, transformers\, fuses\, circuit breakers.\nSensors and Actuators: Introduction to components like LDRs\, thermistors\, buzzers\, and motors.\n\nModule 3: Digital Electronics and Microcontrollers\n\nDigital Fundamentals: Difference between analog and digital signals; binary numbers.\nLogic Gates: AND\, OR\, NOT\, NAND\, NOR\, XOR; truth tables and simple gate ICs.\nIntroduction to Microcontrollers: Overview of a microcontroller unit (MCU) vs. a microprocessor.\nProgramming Fundamentals: Basic coding concepts (variables\, loops\, conditional statements) for a specific platform (e.g.\, Arduino).\nInterfacing: Using a microcontroller to read inputs (e.g.\, from a button or sensor) and control outputs (e.g.\, LEDs\, motors).\n\nModule 4: Testing and Measurement Techniques\n\nMultimeters: Accurate measurement of voltage\, current\, and resistance; continuity testing.\nOscilloscopes: Understanding waveforms\, measuring amplitude\, frequency\, and period; troubleshooting signal issues.\nPower Supplies: Using bench power supplies to provide precise voltage and current to a circuit under test.\nFunction Generators: Generating test signals (sine\, square\, triangle waves).\nReading Schematics: Interpreting circuit diagrams and symbols to guide testing.\nSoldering and Desoldering Techniques: Through-hole and basic surface-mount soldering skills.\n\nModule 5: Electronics System Design and Troubleshooting\n\nDesign Process: Defining requirements\, selecting components\, simulating circuits (basic introduction to software like LTSpice)\, creating schematics.\nPCB Basics: Introduction to Printed Circuit Boards; following a layout to assemble a PCB.\nTroubleshooting Methodology: Developing a logical\, systematic approach to fault-finding (e.g.\, half-split method\, signal tracing).\nIdentifying Faults: Diagnosing common problems like open circuits\, short circuits\, component failures\, and poor solder joints.\nSafety Procedures: Working safely with mains electricity\, high voltages\, and electrostatic discharge (ESD) protection.\nDocumentation: Creating clear documentation for designs and repair procedures.
URL:https://excelbi.co.za/event/certificate-information-technologies-operations/2027-03-08/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/IT-operations-1.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270308T090000
DTEND;TZID=UTC:20270312T130000
DTSTAMP:20261109T174738
CREATED:20260416T084754Z
LAST-MODIFIED:20260416T084754Z
UID:10000939-1804496400-1804856400@excelbi.co.za
SUMMARY:Certificate: Electronics
DESCRIPTION:Overview\nTo provide learners with the fundamental theoretical knowledge and practical skills required to understand\, assemble\, test\, troubleshoot\, and design basic electronic circuits and systems. \nTarget Audience:\nSchool leavers\, electronics enthusiasts\, technicians-in-training\, and individuals seeking a foundation for a career in electronics repair\, assembly\, or further engineering study. \nOutline\nModule 1: Basic Electronics and Circuit Theory\n\nFundamental Concepts: Atomic structure\, charge\, current\, voltage\, resistance\, and power.\nOhm’s Law and Power Law: Calculations and applications.\nCircuit Analysis: Series and parallel circuits; calculating total resistance\, current\, and voltage.\nDC Circuit Principles: Kirchhoff’s Current Law (KCL) and Kirchhoff’s Voltage Law (KVL).\nEnergy and Power: Understanding power dissipation and energy consumption in circuits.\nIntroduction to Capacitance and Inductance: How capacitors and inductors work in DC circuits (charging/discharging).\n\nModule 2: Components and Devices\n\nPassive Components: Resistors (types\, color codes\, values)\, Capacitors (types\, values)\, Inductors.\nSemiconductor Fundamentals: Conductors\, insulators\, and semiconductors.\nDiodes: PN junction theory\, rectifier diodes\, LEDs\, Zener diodes.\nTransistors: Bipolar Junction Transistors (BJTs) as switches and amplifiers; introduction to MOSFETs.\nOther Devices: Switches\, relays\, transformers\, fuses\, circuit breakers.\nSensors and Actuators: Introduction to components like LDRs\, thermistors\, buzzers\, and motors.\n\nModule 3: Digital Electronics and Microcontrollers\n\nDigital Fundamentals: Difference between analog and digital signals; binary numbers.\nLogic Gates: AND\, OR\, NOT\, NAND\, NOR\, XOR; truth tables and simple gate ICs.\nIntroduction to Microcontrollers: Overview of a microcontroller unit (MCU) vs. a microprocessor.\nProgramming Fundamentals: Basic coding concepts (variables\, loops\, conditional statements) for a specific platform (e.g.\, Arduino).\nInterfacing: Using a microcontroller to read inputs (e.g.\, from a button or sensor) and control outputs (e.g.\, LEDs\, motors).\n\nModule 4: Testing and Measurement Techniques\n\nMultimeters: Accurate measurement of voltage\, current\, and resistance; continuity testing.\nOscilloscopes: Understanding waveforms\, measuring amplitude\, frequency\, and period; troubleshooting signal issues.\nPower Supplies: Using bench power supplies to provide precise voltage and current to a circuit under test.\nFunction Generators: Generating test signals (sine\, square\, triangle waves).\nReading Schematics: Interpreting circuit diagrams and symbols to guide testing.\nSoldering and Desoldering Techniques: Through-hole and basic surface-mount soldering skills.\n\nModule 5: Electronics System Design and Troubleshooting\n\nDesign Process: Defining requirements\, selecting components\, simulating circuits (basic introduction to software like LTSpice)\, creating schematics.\nPCB Basics: Introduction to Printed Circuit Boards; following a layout to assemble a PCB.\nTroubleshooting Methodology: Developing a logical\, systematic approach to fault-finding (e.g.\, half-split method\, signal tracing).\nIdentifying Faults: Diagnosing common problems like open circuits\, short circuits\, component failures\, and poor solder joints.\nSafety Procedures: Working safely with mains electricity\, high voltages\, and electrostatic discharge (ESD) protection.\nDocumentation: Creating clear documentation for designs and repair procedures.
URL:https://excelbi.co.za/event/certificate-electronics/2027-03-08/
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/certificate-electronics.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270309T090000
DTEND;TZID=UTC:20270310T130000
DTSTAMP:20261109T174738
CREATED:20260415T072319Z
LAST-MODIFIED:20260429T060410Z
UID:10000160-1804582800-1804683600@excelbi.co.za
SUMMARY:Microsoft Word Intermediate
DESCRIPTION:Microsoft Word Intermediate\nOverview:\nMove beyond the basics and unlock Word’s powerful tools for creating complex\, consistent\, and collaborative documents. Master styles\, advanced formatting\, references\, and review tools to work smarter\, not harder. \nTarget Audience: \nUsers comfortable with Word basics who need to create longer reports\, professional documents\, or collaborate with others. \nUpon completion\, students will be able to: \n\nUse advanced formatting tools like columns\, text boxes\, and SmartArt.\nCreate and apply Styles and Themes for rapid\, consistent formatting.\nDesign and modify complex tables to organize data effectively.\nImplement dynamic headers\, footers\, and page numbers.\nCollaborate using Track Changes and Comments.\nExecute a basic Mail Merge to create personalized documents.\n\nOutline\nModule 1: Advanced Formatting Tools \n\nPage Layout: Setting custom margins\, orientation\, and applying columns.\nObjects & Graphics: Inserting and formatting Text Boxes\, WordArt\, and SmartArt graphics.\nPage Background: Adding watermarks\, page borders\, and page color.\n\nModule 2: Using Styles and Themes \n\nUnderstanding Styles: Applying built-in styles (Title\, Heading 1\, etc.) and modifying them.\nCreating Custom Styles: Building and saving your own styles for text\, lists\, and paragraphs.\nDocument Themes: Applying and customizing Themes to change fonts\, colors\, and effects globally.\n\nModule 3: Creating and Modifying Tables \n\nTable Design: Using the Table Designer tab to apply styles\, shading\, and borders.\nTable Layout: Sorting data\, merging and splitting cells\, and adjusting row/column distribution.\nCalculations & Formulas: Performing basic calculations (e.g.\, Sum\, Average) within a table.\n\nModule 4: Working with Headers and Footers \n\nBasics: Adding and editing text\, dates\, and page numbers in headers/footers.\nAdvanced Options: Creating different first-page headers and different odd/even page headers.\nLinking Sections: Understanding how to unlink headers/footers between document sections.\n\nModule 5: Track Changes and Comments \n\nTracking Changes: Turning on Track Changes\, showing revisions\, and understanding different views (All Markup\, No Markup\, Original).\nReviewing Pane: Using the pane to navigate through changes.\nAccepting/Rejecting & Comments: Resolving edits and using comments for feedback without changing the text.\n\nModule 6: Mail Merge Basics \n\nThe Mail Merge Process: Using the step-by-step wizard.\nSelecting a Data Source: Connecting your document to an Excel list or Outlook Contacts.\nInserting Merge Fields & Completing the Merge: Adding personalized fields and generating the final documents.
URL:https://excelbi.co.za/event/microsoft-word-intermediate/2027-03-09/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Word-Intermediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270406T090000
DTEND;TZID=UTC:20270407T130000
DTSTAMP:20261109T174738
CREATED:20260415T072918Z
LAST-MODIFIED:20260415T073019Z
UID:10000272-1807002000-1807102800@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-04-06/
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:20270413T090000
DTEND;TZID=UTC:20270414T130000
DTSTAMP:20261109T174738
CREATED:20260415T073324Z
LAST-MODIFIED:20260415T075959Z
UID:10000292-1807606800-1807707600@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-04-13/
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:20270830T080000
DTEND;TZID=UTC:20270903T170000
DTSTAMP:20261109T174738
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:20261109T174738
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