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:20260101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20270104T090000
DTEND;TZID=UTC:20270108T130000
DTSTAMP:20261109T104457
CREATED:20260416T065613Z
LAST-MODIFIED:20260416T065719Z
UID:10000735-1799053200-1799413200@excelbi.co.za
SUMMARY:Workshop: Website Development
DESCRIPTION:Course Objective:\nTo equip learners with the practical skills and theoretical knowledge to design\, build\, deploy\, and maintain modern\, responsive\, secure\, and accessible websites using standard web technologies and content management systems. \nTarget Audience:\nAspiring web developers\, career changers\, designers looking to add development skills\, entrepreneurs\, and marketing professionals. \nOutline\nModule 1: Web Technologies and Tools\n\nHow the Web Works: Clients\, servers\, HTTP/HTTPS protocols\, and DNS.\nDevelopment Environments: Setting up a local development server (e.g.\, XAMPP\, WAMP) and using code editors (e.g.\, VS Code).\nVersion Control with Git: Repository basics\, committing changes\, and branching for project management.\nBrowser Developer Tools: Using inspector tools for debugging HTML\, CSS\, and JavaScript.\nWeb Standards and Accessibility: Introduction to W3C standards and Web Content Accessibility Guidelines (WCAG).\n\nModule 2: HTML\, CSS\, and JavaScript Programming\n\nHTML5: Semantic HTML\, forms\, multimedia elements (audio\, video)\, and embedding content.\nCSS3: Styling\, the box model\, advanced selectors\, and modern layout techniques including Flexbox and CSS Grid.\nJavaScript Fundamentals: Variables\, data types\, functions\, control flow\, and DOM manipulation.\nInteractive Web Pages: Handling events\, validating forms\, and dynamically updating content without page reloads.\nIntroduction to APIs: Fetching and displaying data from third-party RESTful APIs.\n\nModule 3: Responsive Design and Mobile-first Approaches\n\nMobile-First Philosophy: Strategy and benefits of designing for mobile devices first.\nMedia Queries: Using breakpoints to adapt layouts for different screen sizes.\nResponsive Images: Using modern HTML tags (srcset\, sizes) and CSS techniques to serve optimized images.\nFluid Layouts: Using relative units (%\, em\, rem\, vw\, vh) for flexible component sizing.\nCross-Browser Compatibility: Ensuring websites function correctly on different browsers and devices.\n\nModule 4: Content Management Systems (CMS)\n\nIntroduction to CMS: Understanding the benefits of using a CMS like WordPress.\nWordPress Installation & Configuration: Manual installation and using hosting control panels.\nTheme Development: Converting HTML/CSS templates into custom WordPress themes; understanding the template hierarchy.\nPlugin Integration: Sourcing\, evaluating\, and customizing plugins to extend functionality.\nContent Management: Creating and managing posts\, pages\, and custom post types for clients.\n\nModule 5: Website Optimization and Security\n\nPerformance Optimization: Techniques for minification\, lazy loading\, and reducing HTTP requests to improve page load times.\nSearch Engine Optimization (SEO): On-page SEO techniques\, including meta tags\, semantic structure\, and sitemaps.\nWebsite Security: Common vulnerabilities (e.g.\, SQL injection\, XSS)\, implementing HTTPS\, and best practices for securing a WordPress site.\nWeb Hosting & Deployment: transferring files via FTP/SFTP\, managing databases\, and deploying a site from a local environment to a live server.\nAnalytics: Integrating tools like Google Analytics to track website traffic and user behavior.
URL:https://excelbi.co.za/event/workshop-website-development/2027-01-04/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/web-development.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270105T090000
DTEND;TZID=UTC:20270106T130000
DTSTAMP:20261109T104457
CREATED:20260415T071948Z
LAST-MODIFIED:20260429T060336Z
UID:10000098-1799139600-1799240400@excelbi.co.za
SUMMARY:Microsoft Word Essentials
DESCRIPTION:Microsoft Word Essentials\nCourse Overview:\nThis course introduces learners to the fundamental tools and features of Microsoft Word. Participants will gain confidence in creating\, formatting\, and managing documents for personal\, academic\, or professional use. The training covers the Word interface\, text and paragraph formatting\, working with lists\, inserting images and shapes\, and setting up basic page layouts for printing. \nBy the end of the course\, learners will be able to: \n\nNavigate the Word interface and use the Ribbon effectively.\nCreate\, save\, and manage documents.\nApply essential text and paragraph formatting for readability.\nOrganize information using lists and bullets.\nEnhance documents with images\, shapes\, and text boxes.\nAdjust page settings and prepare documents for printing.\n\nThis essentials course is ideal for beginners or those looking to refresh their Word skills. \nOutline\nModule 1: Introduction to Microsoft Word \n\nOverview of Microsoft Word and its uses\nNavigating the Word interface\nUnderstanding the Ribbon\, Tabs\, and Groups\nCustomizing the Quick Access Toolbar\n\nModule 2: Creating and Managing Documents \n\nStarting a new document\nOpening existing documents\nSaving documents (Save vs. Save As\, file formats)\nClosing and exiting Word\n\nModule 3: Basic Text Formatting \n\nEntering and editing text\nUsing font styles (bold\, italic\, underline)\nChanging font type\, size\, and color\nCopying and pasting text efficiently\nUsing the Format Painter\n\nModule 4: Paragraph Formatting \n\nAligning text (left\, right\, center\, justify)\nAdjusting line and paragraph spacing\nIndentation and tabs\nApplying borders and shading\n\nModule 5: Lists and Bullets \n\nCreating bulleted lists\nCreating numbered lists\nCustomizing bullets and numbering\nMultilevel lists\n\nModule 6: Working with Visual Elements \n\nInserting images from file and online sources\nResizing\, moving\, and cropping images\nApplying picture styles and effects\nInserting and formatting shapes\nUsing text boxes\n\nModule 7: Page Layout and Printing \n\nSetting page margins\, orientation\, and paper size\nAdding headers and footers\nPage numbering\nUsing Page Breaks and Section Breaks\nPrint Preview and printing options
URL:https://excelbi.co.za/event/microsoft-word-essentials/2027-01-05/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Word-Basic-1.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270105T090000
DTEND;TZID=UTC:20270106T130000
DTSTAMP:20261109T104457
CREATED:20260415T072918Z
LAST-MODIFIED:20260415T073019Z
UID:10000271-1799139600-1799240400@excelbi.co.za
SUMMARY:Microsoft PowerPoint Introduction
DESCRIPTION:Overview\nThis beginner-friendly course is designed to take you from knowing nothing about PowerPoint to being able to create\, design\, and deliver professional-looking presentations. You will learn the core functionalities of the software\, from adding text and images to applying simple animations and delivering your presentation with confidence. No prior experience is necessary. \nTarget Audience \nStudents\, office workers\, entrepreneurs\, teachers\, and anyone who needs to create effective visual presentations. \nUpon completion\, students will be able to: \n\nConfidently navigate the PowerPoint interface and use key tabs.\nCreate a new presentation\, add various slide types\, and manage slide order.\nFormat text\, shapes\, and images for visual impact and consistency.\nInsert and manipulate pictures\, icons\, videos\, and other media.\nApply and customize slide transitions and object animations.\nUtilize speaker tools and practice techniques to deliver a polished presentation.\n\nOutline\nModule 1: Navigating the PowerPoint Environment \n\nGet comfortable with the PowerPoint workspace and understand its main components.\n\nWelcome & Overview: What is PowerPoint? Understanding the Ribbon\, Quick Access Toolbar\, and Status Bar.\nViews and Zoom: Using Normal\, Slide Sorter\, Reading\, and Slide Show views effectively.\nWorking with Files: Creating a new blank presentation\, using templates\, opening\, saving (“Save” vs. “Save As”)\, and exporting to PDF.\n\n\n\nModule 2: Creating and Managing Slides \n\nBuild the structural foundation of your presentation.\n\nAdding Slides: Inserting new slides and choosing the right slide layout (Title\, Title and Content\, Section Header\, etc.).\nManaging Content Placeholders: Adding text and content into predefined boxes.\nSlide Management: Organizing slides using Slide Sorter view\, duplicating\, moving\, and deleting slides.\n\n\n\nModule 3: Basic Text and Shape Formatting \n\nMake your content visually clear and engaging.\n\nWorking with Text: Adding & formatting text (Font\, Size\, Color)\, using bullet points and numbered lists\, and working with text boxes (vs. placeholders).\nIntroduction to Shapes: Inserting shapes\, applying styles and fills\, adding text to shapes\, and adjusting size and rotation.\nAlignment and Ordering: Using alignment guides\, distributing objects evenly\, and managing object layers (Bring Forward/Send Backward).\n\n\n\nModule 4: Inserting Images and Multimedia \n\nEnhance your presentation with visual and audio elements.\n\nWorking with Images: Inserting pictures from your device and online sources\, using the Picture Format tab to crop\, apply corrections\, artistic effects\, and remove backgrounds.\nIcons & Illustrations: Using PowerPoint’s built-in library of icons\, 3D models\, and scalable vector graphics.\nAdding Video & Audio: Inserting video and audio files\, formatting video playback\, and adjusting audio settings.\n\n\n\nModule 5: Applying Basic Transitions and Animations \n\nAdd subtle movement to guide your audience’s attention.\n\nSlide Transitions: Applying transitions between slides\, effect options\, and timing (duration\, advance on click vs. after time).\nObject Animations: Applying Entrance\, Emphasis\, and Exit animations to text and objects.\nAnimation Pane: Using the Animation Pane to modify effect options\, change the order of animations\, and set timing (start: on click\, with previous\, after previous).\n\n\n\nModule 6: Presentation Tips and Techniques (The Final Rehearsal) \n\nPrepare to deliver your presentation confidently and professionally.\n\nReview and Proofing: Using the Spelling & Thesaurus tool\, adding and reviewing speaker notes.\nPresenter View: Configuring and using Presenter View to see notes\, jump to slides\, and use the pen/highlighter tool during a presentation.\nRehearsal & Delivery: Setting up slide show options (monitor settings)\, rehearsing timings\, and practicing key presentation skills (pace\, tone\, body language).\nSharing Your Work: Tips for presenting online (via Teams/Zoom) and packaging your presentation for email.
URL:https://excelbi.co.za/event/microsoft-powerpoint-introduction/2027-01-05/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Powerpoint-Basics.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270111T090000
DTEND;TZID=UTC:20270115T130000
DTSTAMP:20261109T104457
CREATED:20260416T070448Z
LAST-MODIFIED:20260416T071000Z
UID:10000763-1799658000-1800018000@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-01-11/
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:20270111T090000
DTEND;TZID=UTC:20270115T130000
DTSTAMP:20261109T104457
CREATED:20260416T084754Z
LAST-MODIFIED:20260416T084754Z
UID:10000938-1799658000-1800018000@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-01-11/
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:20270112T090000
DTEND;TZID=UTC:20270113T130000
DTSTAMP:20261109T104457
CREATED:20260415T072319Z
LAST-MODIFIED:20260429T060410Z
UID:10000158-1799744400-1799845200@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-01-12/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Word-Intermediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270112T090000
DTEND;TZID=UTC:20270113T130000
DTSTAMP:20261109T104457
CREATED:20260415T073324Z
LAST-MODIFIED:20260415T075959Z
UID:10000291-1799744400-1799845200@excelbi.co.za
SUMMARY:Microsoft PowerPoint Intermediate
DESCRIPTION:Overview\nElevate your presentations from simple slides to powerful\, professional storytelling tools. Master advanced design\, animation\, collaboration\, and delivery techniques to engage any audience. \nTarget Audience: \nUsers comfortable with PowerPoint basics who create frequent presentations and want to improve their design efficiency\, visual impact\, and delivery skills. \nUpon completion\, students will be able to: \n\nUse the Slide Master to create consistent\, branded presentations.\nApply and sequence advanced animations and transitions for narrative effect.\nCreate and save custom templates for repeated use.\nImport and customize charts and graphs from Excel.\nCollaborate on presentations using comments and co-authoring features.\nDeliver polished presentations using advanced presenter tools and techniques.\n\nOutline\nModule 1: Customizing Slide Masters \n\nSlide Master View: Understanding the hierarchy between the Master and individual layouts.\nGlobal Formatting: Setting default fonts\, colors\, placeholder positions\, and background graphics on the Master.\nCustom Layouts: Creating new slide layouts with specific placeholders for different content types.\n\nModule 2: Using Advanced Animation and Transition Effects \n\nAnimation Pane Mastery: Using the Animation Pane to manage complex sequences\, change timing\, and set triggers.\nMorph Transition: Creating seamless\, cinematic animations between slides with the Morph transition.\nEffect Options: Using motion paths\, animating charts\, and adjusting timing for professional pacing.\n\nModule 3: Creating Custom Templates \n\nTemplate Fundamentals: Defining a template (.potx file) vs. a presentation (.pptx file).\nBuilding from the Master: Designing a template using the customized Slide Master from Module 1.\nSaving and Using: Saving a file as a custom template and creating a new presentation from it.\n\nModule 4: Incorporating Charts and Graphs \n\nLinking vs. Embedding: Inserting charts from Excel and understanding the benefits of linking data.\nFormatting Charts: Using Chart Tools (Design and Format tabs) to customize style\, colors\, and elements.\nAnimating Charts: Applying animations to chart elements to introduce data point-by-point.\n\nModule 5: Collaborating with Others \n\nComments: Using the Comments pane to add\, review\, and resolve feedback on specific slides.\nCo-Authoring: Real-time collaboration: simultaneously editing a presentation stored on OneDrive or SharePoint.\nComparison and Merging: Comparing and merging two versions of a presentation to incorporate changes.\n\nModule 6: Delivering Presentations Effectively \n\nPresenter View Deep Dive: Using tools like speaker notes\, slide preview\, pen\, and laser pointer.\nRehearsal Techniques: Using the Rehearse Timings feature to practice pacing and delivery.\nPresentation Tips: Managing audience questions\, handling technical setup\, and presenting online.
URL:https://excelbi.co.za/event/microsoft-powerpoint-intermediate/2027-01-12/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Powerpoint-Intemediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270118T090000
DTEND;TZID=UTC:20270120T130000
DTSTAMP:20261109T104457
CREATED:20260415T072606Z
LAST-MODIFIED:20260429T060440Z
UID:10000218-1800262800-1800450000@excelbi.co.za
SUMMARY:Microsoft Word Advanced
DESCRIPTION:Microsoft Word Advanced\nOverview\nMaster Word’s most powerful features for long-form documents\, automation\, and secure collaboration. Learn to manage citations\, indexes\, macros\, and complex reviews to produce high-quality professional reports\, manuscripts\, and legal documents. \nTarget Audience: \nResearchers\, technical writers\, administrative professionals\, and anyone who regularly creates long\, complex\, or collaboratively edited documents. \nUpon completion\, students will be able to: \n\nCreate complex documents with automatic tables of contents\, figures\, and cross-references.\nBuild and update bibliographies\, citations\, and indexes.\nExecute advanced Mail Merges using conditional rules and external data sources.\nRecord\, edit\, and run simple VBA macros to automate repetitive tasks.\nApply advanced security features\, including digital signatures and restricted editing.\nManage and compare multiple versions of shared documents effectively.\n\nOutline\nModule 1: Creating Complex Documents with References \n\nMastering Styles: Using Outline View and modifying Styles to create a hierarchical document structure.\nAutomatic Tables: Generating a Table of Contents (TOC) and a Table of Figures (TOF) from Styles.\nCross-Referencing: Inserting dynamic cross-references to headings\, figures\, tables\, and numbered items.\n\nModule 2: Building Indexes and Citations \n\nCitations & Bibliography: Using the Citations & Bibliography tools (APA\, MLA\, Chicago styles) to manage sources.\nMarking Index Entries: Manually marking words and phrases for inclusion in an index.\nGenerating the Index: Creating\, updating\, and formatting a multi-level index at the end of the document.\n\nModule 3: Advanced Mail Merge Techniques \n\nConditional Content: Using IF\, FILLIN\, and NEXT fields within a merge to create dynamic content.\nMerging with Outlook: Using your Outlook Contacts as a data source directly.\nTroubleshooting: Debugging common data source and field errors in complex merges.\n\nModule 4: Using Macros for Automation \n\nMacro Concepts: Understanding what macros are and how they record actions.\nThe Developer Tab: Recording\, running\, and assigning a simple macro to a button.\nBasic VBA Editing: An introduction to the Visual Basic for Applications (VBA) editor to make simple changes to a recorded macro.\n\nModule 5: Document Security and Protection \n\nRestrict Editing: Limiting formatting and editing to specific sections or users (e.g.\, only allowing comments).\nDigital Signatures: Adding a visible signature line or invisible digital signature to certify a document.\nFinalizing Documents: Using the Document Inspector to remove hidden metadata and Mark as Final.\n\nModule 6: Collaborating with Shared Documents \n\nAdvanced Track Changes: Managing extensive changes\, filtering by reviewer\, and changing display options.\nComparing and Combining: Merging two different versions of a document into one final file.
URL:https://excelbi.co.za/event/microsoft-word-advanced/2027-01-18/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Word-Advanced.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270118T090000
DTEND;TZID=UTC:20270120T130000
DTSTAMP:20261109T104457
CREATED:20260415T073606Z
LAST-MODIFIED:20260415T075928Z
UID:10000311-1800262800-1800450000@excelbi.co.za
SUMMARY:Microsoft PowerPoint Advanced
DESCRIPTION:Course Overview:\nPush the boundaries of PowerPoint. Master advanced design\, seamless multimedia integration\, interactive navigation\, and powerful collaboration tools to create captivating\, professional-grade presentations that stand out. Target Audience: Marketing professionals\, trainers\, educators\, designers\, and anyone who creates high-stakes presentations and needs to leverage PowerPoint’s most powerful features. Upon completion\, students will be able to: \n\nDesign visually sophisticated and dynamic presentations using advanced graphic techniques.\nSeamlessly integrate and control video\, audio\, and 3D models.\nConnect PowerPoint with Word and Excel for live data updates.\nBuild non-linear\, interactive presentations with custom navigation.\nManage complex review processes with advanced collaboration and comparison tools.\nShare and present professionally using advanced broadcasting and export options.\n\nOutline\nModule 1: Designing Dynamic Presentations \n\nAdvanced Graphic Techniques: Using Merge Shapes (Combine\, Fragment\, Subtract) to create custom graphics. Working with gradients and transparency.\nLayering and Depth: Mastering the Selection Pane to manage complex object layers and create parallax scrolling effects.\nDesign Consistency: Using the Slide Master to create custom layouts for different types of content (e.g.\, quote slides\, section dividers).\n\nModule 2: Advanced Multimedia Features \n\nVideo and Audio Control: Trimming video\, creating poster frames\, formatting playback options (fade\, loop\, play across slides)\, and embedding online video.\n3D Models: Inserting and animating 3D models from the online library or from files.\nScreen Recording: Recording and embedding actions from your desktop directly into a slide.\n\nModule 3: Integrating PowerPoint with Other Office Apps \n\nLinking Excel Data: Embedding and linking Excel charts and ranges that update automatically when the source data changes.\nWord Integration: Converting a Word outline into a PowerPoint presentation and vice-versa.\nObject Linking and Embedding (OLE): Understanding the difference between embedded and linked objects.\n\nModule 4: Custom Slide Shows and Interactive Features \n\nCustom Slide Shows: Creating and managing multiple custom show paths within a single file.\nHyperlinks and Action Buttons: Using hyperlinks to navigate to other slides\, custom shows\, documents\, or websites. Creating a navigation menu.\nTriggers: Using animation triggers to start effects by clicking on specific objects\, creating interactive quizzes or diagrams.\n\nModule 5: Comprehensive Review Tools for Team Collaboration \n\nAdvanced Comments: Using the Comments pane for threaded conversations and @mentions to tag collaborators.\nCompare and Combine: Merging changes from multiple reviewed versions of a presentation into a single final file.\nCo-Authoring Best Practices: Real-time collaboration on SharePoint/OneDrive\, managing conflicts\, and version history.\n\nModule 6: Advanced Presentation Sharing Options \n\nExport Options: Creating a video presentation\, packaging for CD/USB (Package Presentation for CD)\, and exporting as a PDF with options.\nPresenting Online: Using Office Presentation Service or Microsoft Teams to broadcast a slide show online.\nSecuring and Protecting: Using the Document Inspector to remove metadata and encrypting the presentation with a password.
URL:https://excelbi.co.za/event/microsoft-powerpoint-advanced/2027-01-18/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:MS Office
ATTACH;FMTTYPE=image/png:https://excelbi.co.za/wp-content/uploads/2026/04/Powerpoint-Advanced.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270118T090000
DTEND;TZID=UTC:20270122T130000
DTSTAMP:20261109T104457
CREATED:20260415T100357Z
LAST-MODIFIED:20260415T100538Z
UID:10000529-1800262800-1800622800@excelbi.co.za
SUMMARY:Certificate: Information Technology: Database Administration
DESCRIPTION:Course Overview:\nThis course equips learners with the essential skills to install\, configure\, maintain\, secure\, and optimize enterprise database management systems. \nTarget Audience:\nAspiring Database Administrators (DBAs)\, IT support staff\, and systems administrators. \nOutline\nModule 1: Database Systems and Architectures\n\nOverview of RDBMS vs. NoSQL Systems.\nKey DBMS Components: Storage\, Process\, Memory Structures.\nOn-Premise\, Cloud\, and Hybrid Architectures.\nHigh Availability and Replication Concepts.\n\nModule 2: Installation and Configuration of Database Software\n\nPlanning and Pre-Installation Requirements.\nStep-by-Step Installation of a Major DBMS (e.g.\, MySQL\, PostgreSQL).\nPost-Installation Configuration and Setup.\nCreating and Managing Database Instances.\n\nModule 3: Performance Tuning and Optimization\n\nMonitoring Database Performance and Health.\nIdentifying and Resolving Bottlenecks.\nOptimizing Queries and Index Management.\nConfiguring Memory and Storage for Performance.\n\nModule 4: Backup and Recovery Solutions\n\nDeveloping a Backup Strategy.\nPerforming Full\, Incremental\, and Transaction Log Backups.\nDisaster Recovery Planning.\nRestoring Databases from Backups.\n\nModule 5: Security and Access Control\n\nImplementing Authentication Methods.\nUser Management and Role-Based Access Control (RBAC).\nData Encryption at Rest and in Transit.\nAuditing and Compliance.
URL:https://excelbi.co.za/event/certificate-information-technology-database-administration/2027-01-18/
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/Information-Technology-Database-Administration.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270118T090000
DTEND;TZID=UTC:20270122T130000
DTSTAMP:20261109T104457
CREATED:20260416T071912Z
LAST-MODIFIED:20260416T072056Z
UID:10000791-1800262800-1800622800@excelbi.co.za
SUMMARY:Certificate: Information Technology: End User Computing
DESCRIPTION:Overview\nTo equip learners with the fundamental skills and knowledge required to operate effectively in a modern digital workplace. Graduates will be proficient in using office software\, managing data\, communicating online\, and providing basic IT support. \nTarget Audience:\nSchool leavers\, career changers\, administrative staff\, and any individual seeking to improve their digital literacy for professional purposes. \nOutline\nModule 1: Basics of IT and Computer Systems\n\nIntroduction to Computing:\n\nThe role of IT in the modern workplace.\nDifferent types of computers (desktops\, laptops\, tablets\, smartphones).\n\n\nComputer Hardware:\n\nCore components: CPU\, RAM\, Hard Drive (HDD/SSD)\, Motherboard.\nInput devices: Keyboard\, Mouse\, Scanner\, Microphone.\nOutput devices: Monitor\, Printer\, Speakers.\nPeripheral devices: External drives\, Webcams.\n\n\nComputer Software:\n\nDifference between System Software (Operating Systems) and Application Software.\nIntroduction to common operating systems (e.g.\, Windows\, macOS).\n\n\nUsing an Operating System (e.g.\, Windows):\n\n\nNavigating the desktop\, start menu\, and file system.\nSystem settings and configuration (display\, sound\, user accounts).\nInstalling\, updating\, and uninstalling software applications.\nBasic system maintenance (disk cleanup\, defragmentation).\n\n\n\nModule 2: Office Software Suites\n\n Word Processing (e.g.\, Microsoft Word / Google Docs)\n\nCreating\, saving\, and managing documents.\nText formatting (fonts\, styles\, alignment\, lists).\nDocument structure (headers\, footers\, page numbers).\nInserting and formatting images\, shapes\, and tables.\nUsing tools like Spell Check\, Thesaurus\, and Find & Replace.\nMastering page layout (margins\, orientation\, columns).\nMail Merge for bulk letters and labels.\n\n\nSpreadsheets (e.g.\, Microsoft Excel / Google Sheets)\n\nWorkbook and worksheet fundamentals.\nEntering and formatting data.\nEssential formulas and functions (SUM\, AVERAGE\, MIN\, MAX\, IF).\nCell referencing (relative vs. absolute).\nCreating and formatting charts and graphs.\nSorting and filtering data.\nIntroduction to data analysis with PivotTables.\n\n\nPresentations (e.g.\, Microsoft PowerPoint / Google Slides)\n\n\nCreating a presentation from a template and from scratch.\nAdding\, duplicating\, and arranging slides.\nWorking with text\, images\, video\, and SmartArt.\nApplying slide transitions and object animations.\nDesign principles for effective presentations.\nRehearsing and delivering presentations (Presenter View).\n\n\n\nModule 3: Internet and Email Communication\n\nThe Internet and World Wide Web:\n\nHow the internet works (basic concepts).\nUsing web browsers (Chrome\, Edge\, Firefox).\nEffective searching techniques and evaluating online information for credibility.\n\n\nProfessional Email Communication:\n\nEmail etiquette (subject lines\, salutations\, clear messaging\, signatures).\nManaging an inbox: creating\, replying\, forwarding\, organizing with folders/labels.\nAttaching files and managing attachments.\n\n\nOnline Collaboration & Cloud Tools:\n\nIntroduction to cloud storage (OneDrive\, Google Drive).\nReal-time co-authoring on documents.\nUsing calendar tools for scheduling meetings and appointments.\n\n\nDigital Citizenship and Security:\n\n\nUnderstanding digital footprints.\nRecognizing phishing scams\, spam\, and malware threats.\nThe importance of strong\, unique passwords.\n\n\n\nModule 4: Data Management and File Security\n\nFile Management:\n\nUnderstanding file structures\, paths\, and extensions.\nCreating a logical folder hierarchy for work and personal data.\nNaming files and folders consistently.\nCopying\, moving\, renaming\, and deleting files.\n\n\nData Storage:\n\nDifferent storage media (local hard drive\, network drives\, USB drives\, cloud storage).\nUnderstanding cloud sync vs. cloud backup.\n\n\nData Security Principles:\n\n\nWhy data security is important for individuals and organizations.\nCreating and managing strong passwords and using password managers.\nIntroduction to encryption and two-factor authentication (2FA).\nData backup strategies and performing regular backups.\nSafe disposal of data and hardware.\n\n\n\nModule 5: Problem Solving and IT Support\n\nThe Problem-Solving Mindset:\n\nDeveloping logical and structured thinking.\n\n\nCommon End-User Issues:\n\nIdentifying typical problems (e.g.\, printer not working\, no internet connection\, application crashing\, forgotten passwords).\n\n\nBasic Troubleshooting Methodology:\n\nStep-by-step approach: Identify the problem -> Establish a theory -> Test the theory -> Implement a solution -> Verify functionality -> Document the outcome.\n\n\nUsing Help Resources:\n\nEffectively using built-in Help menus\, online knowledge bases\, forums\, and support sites.\nLearning how to phrase search queries to find solutions online.\n\n\nProviding User Support:\n\nHow to communicate technical issues clearly to a support technician.\nDocumenting problems and solutions for future reference (log a ticket).\n\n\nIntroduction to IT Ethics and Policies:\n\n\nUnderstanding Acceptable Use Policies (AUP).\nPrinciples of data privacy and confidentiality.
URL:https://excelbi.co.za/event/certificate-information-technology-end-user-computing/2027-01-18/
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/end-user-certificate.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270118T090000
DTEND;TZID=UTC:20270122T170000
DTSTAMP:20261109T104457
CREATED:20260415T075350Z
LAST-MODIFIED:20260415T075350Z
UID:10000388-1800262800-1800637200@excelbi.co.za
SUMMARY:Project Management Professional (PMP) Prep Course
DESCRIPTION:Overview\nThis intensive course provides a complete deep dive into the PMBOK® Guide and the three exam domains (People\, Process\, and Business Environment) as outlined by PMI. It is designed to equip experienced project managers with the knowledge\, strategies\, and practical application skills needed to pass the PMP® exam on the first attempt. \nTarget Audience: \nExperienced project managers who meet PMI’s prerequisites and are preparing to take the PMP® certification exam. \nUpon completion\, students will be able to: \n\nMaster the concepts\, processes\, and knowledge areas from the PMBOK® Guide – Seventh Edition and The Standard for Project Management.\nUnderstand the exam’s emphasis on the three domains: People (42%)\, Process (50%)\, and Business Environment (8%).\nApply predictive\, agile\, and hybrid approaches to project management scenarios.\nConfidently answer situational and complex multiple-choice questions.\nDevelop a personalized study plan and test-taking strategy for the PMP® exam.\n\nOutline\nModule 1: In-depth Study of the PMBOK® Guide and Foundational Concepts \n\nThe PMBOK® Guide – 7th Ed: Key concepts: value delivery\, models\, methods\, and artifacts.\nThe Standard for Project Management: The 12 principles and 8 performance domains.\nProject Management Models & Methods: Tailoring models (e.g.\, Tuckman’s ladder) and methods (e.g.\, estimating\, meeting management) to scenarios.\n\nModule 2: Detailed project integration management \n\nProject Integration Management: Developing project charter\, project plan\, directing work\, managing knowledge\, and closing.\nProject Scope Management: Gathering requirements\, defining scope\, creating WBS\, and validating/controlling scope.\nProject Schedule Management: Sequencing activities\, estimating durations\, developing and controlling the schedule (CPM\, PERT).\n\nModule 3: Advanced project scope and time management \n\nProject Cost Management: Estimating costs\, determining budget\, and controlling costs (Earned Value Management – EVM).\nProject Quality Management: Planning quality\, managing quality\, and controlling quality.\nProject Resource Management: Planning\, acquiring\, developing\, and managing the team.\n\nModule 4: Strategies for cost management and budgeting \n\nEssentials of Stakeholder Management: Identifying stakeholders\, planning engagement\, and managing engagement.\nTeam Leadership & Dynamics: Empowering teams\, training\, conflict management\, and motivating team members.\nCommunication Management: Planning\, managing\, and monitoring project communications.\n\nModule 5: Comprehensive risk management approaches \n\nComprehensive Risk Management: Planning\, identifying\, analyzing (qualitative/quantitative)\, planning responses\, and implementing responses.\nProject Procurement Management: Planning\, conducting\, and controlling procurements.\nThe Business Environment Domain (8%): How projects align with organizational strategy\, compliance\, and delivering value.\n\nModule 6: Techniques for quality management and assurance \n\nAgile Principles & Mindset: Key agile concepts\, roles (SM\, PO)\, and artifacts (backlog\, increments).\nHybrid Life Cycles: Combining predictive and adaptive approaches.\nTailoring Techniques: Modifying processes to fit unique project contexts.\n\nModule 7: Essentials of stakeholder management and communication \n\nStakeholder Identification:\n\nTechniques: Brainstorming\, org charts\, reviewing documents.\nOutput: Stakeholder Register.\n\n\nStakeholder Analysis:\n\nPower/Interest Grid: Categorize stakeholders (e.g.\, Manage Closely\, Keep Satisfied).\nAssess influence\, expectations\, and potential impact.\n\n\nCommunication Planning:\n\nDevelop a Stakeholder Engagement Plan.\nTailor messages based on stakeholder needs (frequency\, format\, channel).\n\n\nEngagement & Monitoring (20 mins):\n\nStrategies: Collaboration\, consultation\, reporting.\nAdjust plans based on feedback and changing dynamics.
URL:https://excelbi.co.za/event/project-management-professional-pmp-prep-course/2027-01-18/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Project Management
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Project-Management-Professional-PMP-Prep-Course.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270125T090000
DTEND;TZID=UTC:20270129T130000
DTSTAMP:20261109T104457
CREATED:20260415T123041Z
LAST-MODIFIED:20260415T123041Z
UID:10000568-1800867600-1801227600@excelbi.co.za
SUMMARY:Certificate: Information Technology (Systems Development)
DESCRIPTION:Course Overview:\nThis certificate provides a thorough grounding in the principles and practices of modern software engineering. Students will learn to design\, code\, test\, and manage the development of robust applications and systems\, preparing them for roles as junior developers\, software testers\, and IT project support staff. \nTarget Audience:\nAspiring software developers\, programmers\, and IT professionals seeking to specialize in building software solutions. \nOutline\nModule 1: Software Design and Implementation\n\nSoftware Development Lifecycle (SDLC) Models\nObject-Oriented Analysis and Design (OOAD) Principles\nUML and Modeling Techniques (Use Cases\, Class Diagrams\, Sequence Diagrams)\nSoftware Architecture Patterns (e.g.\, MVC\, Client-Server)\nAPI Design and Integration Principles\nWriting Clean\, Maintainable\, and Documented Code\n\nModule 2: Programming Languages (Java\, Python\, etc.)\n\nCore Programming Concepts (Syntax\, Data Types\, Control Flow)\nObject-Oriented Programming (Classes\, Objects\, Inheritance\, Polymorphism)\nData Structures (Lists\, Stacks\, Queues\, Dictionaries)\nLanguage-Specific Frameworks and Libraries (e.g.\, Spring for Java\, Django for Python)\nIntroduction to Web Development (HTML\, CSS\, JavaScript)\nComparative Language Analysis\n\nModule 3: Database Management and Development\n\nRelational Database Concepts and Normalization\nSQL for Data Definition and Manipulation (DDL & DML)\nAdvanced Querying (Joins\, Subqueries\, Transactions)\nDatabase Programming (Stored Procedures\, Triggers)\nIntroduction to NoSQL Databases (e.g.\, MongoDB)\nIntegrating Databases with Applications\n\nModule 4: Project Management in IT\n\nTraditional vs. Agile Project Management (Waterfall\, Scrum\, Kanban)\nProject Planning\, Scheduling\, and Estimation\nRisk Management and Mitigation\nVersion Control with Git and Collaboration (GitHub\, GitLab)\nTools for Project Tracking (e.g.\, Jira\, Trello)\nTeam Dynamics and Communication\n\nModule 5: Testing and Quality Assurance\n\nFundamentals of Software Testing\nWriting and Executing Test Cases\nLevels of Testing (Unit\, Integration\, System\, UAT)\nTest-Driven Development (TDD) Introduction\nAutomated Testing Tools and Scripts (e.g.\, Selenium\, JUnit)\nDebugging Techniques and Defect Lifecycle Management
URL:https://excelbi.co.za/event/certificate-information-technology-systems-development/2027-01-25/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Certificate-Information-Technology-Systems-Development.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270125T090000
DTEND;TZID=UTC:20270129T130000
DTSTAMP:20261109T104457
CREATED:20260415T140931Z
LAST-MODIFIED:20260415T140931Z
UID:10000658-1800867600-1801227600@excelbi.co.za
SUMMARY:Workshop: Information Technology: Systems Development
DESCRIPTION:Course Overview:\nThis certificate provides learners with the foundational knowledge and practical skills required to begin a career in software development. Students will learn to analyze requirements\, design systems\, write code\, manage databases\, and rigorously test applications using modern methodologies. \nTarget Audience:\nAspiring software developers\, career changers\, and IT professionals seeking to move into a development role. \nOutline\nModule 1: Software Development Principles\n\nIntroduction to Programming Logic and Algorithms\nVariables\, Data Types\, and Operators\nControl Structures (Conditionals and Loops)\nFunctions\, Methods\, and Modular Programming\nBasic Data Structures (Arrays\, Lists\, Dictionaries)\nIntroduction to Object-Oriented Programming (OOP) Concepts\nPrinciples of Clean Code and Readability\nIntroduction to a Programming Language (e.g.\, Python\, C#\, Java)\n\nModule 2: System Analysis and Design\n\nThe Role of a Systems Analyst\nGathering and Documenting User Requirements\nCreating Use Cases and User Stories\nModeling System Processes (Data Flow Diagrams)\nDesigning User Interfaces (UI) and User Experiences (UX)\nIntroduction to UML Diagrams (Class\, Sequence Diagrams)\nCreating Technical Specification Documents\n\nModule 3: Databases and SQL\n\nIntroduction to Relational Database Concepts\nDatabase Normalization Principles\nEntity-Relationship (ER) Diagramming\nSQL Fundamentals: Data Definition Language (DDL)\nSQL Fundamentals: Data Manipulation Language (DML)\nWriting Advanced Queries (Joins\, Unions\, Aggregations)\nIntegrating Applications with Databases\n\nModule 4: Development Methodologies (Agile\, Waterfall)\n\nIntroduction to the Software Development Lifecycle (SDLC)\nThe Traditional Waterfall Methodology\nThe Agile Manifesto and Principles\nThe Scrum Framework (Roles\, Artifacts\, Ceremonies)\nKanban and Lean Development Principles\nProject Management Tools (e.g.\, Jira\, Trello)\nVersion Control with Git (Basics)\n\nModule 5: Application Testing and Debugging\n 
URL:https://excelbi.co.za/event/workshop-information-technology-systems-development/2027-01-25/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/systems-development-1.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270125T090000
DTEND;TZID=UTC:20270129T130000
DTSTAMP:20261109T104457
CREATED:20260416T064741Z
LAST-MODIFIED:20260416T064741Z
UID:10000716-1800867600-1801227600@excelbi.co.za
SUMMARY:Workshop: Computer Programming
DESCRIPTION:Course Objective:\nThis certificate is designed to equip students with a strong foundation in modern programming principles and practices\, preparing them for a career in software development. \nOutline\nModule 1: Programming Fundamentals\n\nIntroduction to Programming Paradigms: High-level overview of different programming styles.\nVariables and Data Types: Understanding how to store and manipulate different kinds of data.\nOperators and Expressions: Learning to perform calculations and logical operations.\nControl Flow: Using conditional statements (if/else) and loops (for\, while) to control program execution.\nFunctions and Modular Programming: Breaking down complex problems into smaller\, reusable blocks of code.\nBasic Input/Output: Interacting with the user and external files.\nDebugging and Error Handling: Identifying and resolving common programming errors.\n\nModule 2: Object-Oriented Programming (OOP)\n\nIntroduction to OOP: Core concepts of classes and objects.\nThe Four Pillars of OOP: Detailed exploration of Encapsulation\, Inheritance\, Polymorphism\, and Abstraction.\nClass Design and Relationships: Creating and using classes\, including constructors and access modifiers.\nInterfaces and Abstract Classes: Designing contracts and blueprints for objects.\nUML Diagrams: Using Unified Modeling Language to visualize class structures.\n\nModule 3: Data Structures and Algorithms\n\nFundamental Data Structures: In-depth study of arrays\, linked lists\, stacks\, and queues.\nAdvanced Data Structures: Introduction to trees\, graphs\, and hash tables.\nAlgorithmic Complexity: Analyzing the efficiency of algorithms using Big O notation.\nSearching and Sorting Algorithms: Implementing and comparing classic algorithms like binary search\, bubble sort\, and quicksort.\nRecursion: Understanding recursive solutions to problems and when to use them.\n\nModule 4: Software Development Lifecycle (SDLC)\n\nSDLC Models: Exploring methodologies like Waterfall\, Agile\, and Scrum.\nRequirements Gathering: Defining the goals and scope of a software project.\nSystem Design: Creating a blueprint for the application’s architecture.\nCoding and Implementation: Following coding standards and best practices.\nTesting and Quality Assurance: Ensuring the software is functional and bug-free.\nDocumentation: Creating clear and comprehensive documentation for code and users.\n\nModule 5: Application Deployment and Maintenance\n\nVersion Control: Using Git to track and manage code changes.\nContinuous Integration/Continuous Delivery (CI/CD): Automating the build and deployment process.\nDeployment Strategies: Releasing applications to different environments (e.g.\, staging\, production).\nCloud Services and Containerization: Introduction to platforms like AWS\, Google Cloud\, and technologies like Docker.\nPost-Deployment Activities: Monitoring\, maintenance\, updates\, and bug fixes.
URL:https://excelbi.co.za/event/workshop-computer-programming/2027-01-25/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/computer-programming.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20270125T090000
DTEND;TZID=UTC:20270129T130000
DTSTAMP:20261109T104457
CREATED:20260416T075243Z
LAST-MODIFIED:20260416T075243Z
UID:10000821-1800867600-1801227600@excelbi.co.za
SUMMARY:Certificate: Technology: Database Development
DESCRIPTION:Course Overview:\nThis course provides the foundational knowledge and practical skills to design\, build\, query\, and manage modern\, secure\, and efficient databases. \nTarget Audience: Aspiring Database Developers\, Data Analysts\, IT professionals\, and software developers. \nOutline\nModule 1: Database Design and Modeling\n\nRelational Database Concepts and Principles.\nEntity-Relationship (ER) Diagramming.\nNormalization (1NF\, 2NF\, 3NF).\nTranslating Business Requirements into a Data Model.\n\nModule 2: SQL and Query Optimization\n\nCore SQL: DDL\, DML\, DQL (SELECT\, JOINs\, WHERE\, GROUP BY).\nWriting Advanced Queries: Subqueries\, Functions.\nIndexing and Query Performance Tuning.\nUnderstanding Execution Plans.\n\nModule 3: Data Warehousing Concepts\n\nData Warehouse Architecture (OLAP vs. OLTP).\nDimensional Modeling: Stars and Snowflakes Schemas.\nETL (Extract\, Transform\, Load) Processes.\nIntroduction to BI and Reporting.\n\nModule 4: Database Security and Management\n\nUser Authentication and Authorization.\nImplementing Data Encryption.\nBackup\, Recovery\, and Disaster Planning.\nRoutine Maintenance and Monitoring.\n\nModule 5: Emerging Trends in Database Technology\n\nIntroduction to NoSQL Databases (Document\, Key-Value).\nCloud Database Services (e.g.\, AWS RDS\, Azure SQL).\nBig Data Fundamentals.\nOverview of Data Lakes.
URL:https://excelbi.co.za/event/certificate-technology-database-development/2027-01-25/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/3darts-renders-k9o7KiAzcis-unsplash.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
END:VCALENDAR