BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Business Institute - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel Business Institute
X-ORIGINAL-URL:https://excelbi.co.za
X-WR-CALDESC:Events for Excel Business Institute
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260921T090000
DTEND;TZID=UTC:20260923T130000
DTSTAMP:20260921T112302
CREATED:20260415T072606Z
LAST-MODIFIED:20260429T060440Z
UID:10000214-1789981200-1790168400@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/2026-09-21/
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:20260921T090000
DTEND;TZID=UTC:20260925T130000
DTSTAMP:20260921T112302
CREATED:20260415T100357Z
LAST-MODIFIED:20260415T100538Z
UID:10000527-1789981200-1790341200@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/2026-09-21/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/Information-Technology-Database-Administration.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260921T090000
DTEND;TZID=UTC:20260925T130000
DTSTAMP:20260921T112302
CREATED:20260416T071912Z
LAST-MODIFIED:20260416T072056Z
UID:10000789-1789981200-1790341200@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/2026-09-21/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Information Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/end-user-certificate.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
END:VCALENDAR