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:20260921T085040
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:20261006T090000
DTEND;TZID=UTC:20261007T130000
DTSTAMP:20260921T085040
CREATED:20260415T072918Z
LAST-MODIFIED:20260415T073019Z
UID:10000270-1791277200-1791378000@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/2026-10-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:20261013T090000
DTEND;TZID=UTC:20261014T130000
DTSTAMP:20260921T085040
CREATED:20260415T064620Z
LAST-MODIFIED:20260415T064620Z
UID:10000003-1791882000-1791982800@excelbi.co.za
SUMMARY:Microsoft Excel Basics
DESCRIPTION:Microsoft Excel Basics\nCourse Overview\nThis beginner-friendly course introduces learners to the essential features of Microsoft Excel. Participants will learn how to navigate the Excel interface\, enter and edit data\, and use basic formulas and functions to perform calculations. The course also covers creating and formatting tables\, building simple charts to visualize data\, and applying basic sorting and filtering techniques to manage information effectively. \nBy the end of the course\, learners will be able to confidently create and organize spreadsheets\, apply simple calculations\, and present data in a clear\, professional format. \nOutline\nModule 1: Getting Started with Excel \n\nOverview of Microsoft Excel and its uses\nNavigating the Excel interface (Ribbon\, Tabs\, Workbook\, Worksheet)\nUnderstanding cells\, rows\, and columns\nCustomizing the Quick Access Toolbar\n\nModule 2: Entering and Editing Data \n\nInputting text\, numbers\, and dates\nEditing and clearing cell content\nUsing AutoFill and Flash Fill\nUndo\, Redo\, and basic shortcuts\n\nModule 3: Basic Formulas and Functions \n\nIntroduction to formulas (equals sign\, cell references)\nPerforming basic calculations (addition\, subtraction\, multiplication\, division)\nCommon functions: SUM\, AVERAGE\, MIN\, MAX\nUnderstanding relative vs. absolute cell references\n\nModule 4: Creating and Formatting Tables \n\nCreating simple data tables\nApplying table styles and formatting\nAdjusting column width and row height\nMerging cells\, borders\, and shading\nFormatting numbers (currency\, percentages\, decimals)\n\nModule 5: Introduction to Charts \n\nCreating basic charts (column\, line\, pie)\nCustomizing chart elements (titles\, legends\, labels)\nChanging chart styles and layouts\nChoosing the right chart for your data\n\nModule 6: Sorting and Filtering Data \n\nSorting data (ascending\, descending\, custom sort)\nApplying filters to view specific data\nUsing AutoFilter options\nClearing filters and resets\n\nFinal Practice & Wrap-Up \n\nBuilding a simple data sheet with formulas\, table formatting\, and a chart\nReviewing key features covered\n\nQ&A and further learning resources
URL:https://excelbi.co.za/event/microsoft-excel-basics/2026-10-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/03/Excel-Basic.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261013T090000
DTEND;TZID=UTC:20261014T130000
DTSTAMP:20260921T085041
CREATED:20260415T073324Z
LAST-MODIFIED:20260415T075959Z
UID:10000290-1791882000-1791982800@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/2026-10-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:20261019T090000
DTEND;TZID=UTC:20261021T130000
DTSTAMP:20260921T085041
CREATED:20260415T073606Z
LAST-MODIFIED:20260415T075928Z
UID:10000310-1792400400-1792587600@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/2026-10-19/
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:20261020T090000
DTEND;TZID=UTC:20261021T130000
DTSTAMP:20260921T085041
CREATED:20260415T071247Z
LAST-MODIFIED:20260415T071247Z
UID:10000033-1792486800-1792587600@excelbi.co.za
SUMMARY:Microsoft Office Excel Intermediate
DESCRIPTION:Microsoft Office Excel Intermediate\nCourse Overview\nElevate your Excel skills beyond basics. Master powerful functions\, dynamic analysis with PivotTables\, and advanced data management techniques to transform raw data into actionable insights. \nTarget Audience: \nUsers comfortable with Excel basics (data entry\, simple formulas\, basic formatting) who need to analyze\, manage\, and present complex data sets. \nUpon completion\, students will be able to: \n\nBuild complex formulas using logical (IF\, AND/OR)\, lookup (VLOOKUP/XLOOKUP)\, and text functions.\nApply and manage Conditional Formatting to visually analyze data trends and patterns.\nCreate\, modify\, and filter PivotTables and PivotCharts to summarize large data sets.\nUse advanced filtering\, sorting\, and data tools to manage lists.\nLink data across multiple worksheets and workbooks.\nImplement Data Validation and protect worksheets and workbooks.\n\nOutline\nModule 1: Advanced Formulas and Functions \n\nLogical Functions: Using IF\, nested IFs\, AND\, and OR to make conditional calculations.\nLookup Functions: Using VLOOKUP (or XLOOKUP) to find and retrieve data from a table.\nText & Date Functions: Using functions like LEFT\, RIGHT\, CONCAT\, and DATE to manipulate text and date values.\n\nModule 2: Conditional Formatting Techniques \n\nBeyond Basic Highlighting: Using top/bottom rules\, data bars\, color scales\, and icon sets.\nCustom Rules: Creating new rules with custom formulas (e.g.\, format a cell if it is above the average of a range).\nManaging Rules: Editing\, deleting\, and controlling the order of multiple conditional formatting rules.\n\nModule 3: Introduction to PivotTables \n\nPivotTable Basics: Creating a PivotTable from a data range\, understanding the Field List.\nArranging Data: Adding fields to Rows\, Columns\, Values\, and Filters to shape your report.\nGrouping and Formatting: Grouping dates/numbers\, applying number formatting\, and changing summary calculations (Sum\, Count\, Average).\n\nModule 4: Advanced Data Sorting and Filtering \n\nCustom Sorts: Sorting data by multiple columns (e.g.\, sort by Region\, then by Sales descending).\nAdvanced Filter: Using the Advanced Filter tool to extract data based on complex\, multi-field criteria.\nTable Filters: Leveraging the powerful filtering capabilities of Excel Tables (slicers & timelines).\n\nModule 5: Working with Multiple Sheets and Workbooks \n\n3D Formulas:Referencing the same cell across multiple worksheets for summary calculations (e.g.\, SUM(Sheet1:Sheet3!B5)).\nLinking Workbooks: Creating formulas that reference cells in other open workbooks.\nConsolidating Data: Using the Consolidate tool to combine data from multiple sheets.\n\nModule 6: Data Validation and Protection \n\nData Validation: Setting rules to restrict data entry (e.g.\, whole numbers\, dates\, custom lists for drop-down menus).\nInput Messages and Error Alerts: Creating prompts and custom error messages for users.\nProtection: Locking cells\, protecting a worksheet with a password\, and protecting workbook structure.
URL:https://excelbi.co.za/event/microsoft-office-excel-intermediate/2026-10-20/
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:20261026T090000
DTEND;TZID=UTC:20261028T130000
DTSTAMP:20260921T085041
CREATED:20260415T071621Z
LAST-MODIFIED:20260415T071621Z
UID:10000063-1793005200-1793192400@excelbi.co.za
SUMMARY:Microsoft Excel Advanced
DESCRIPTION:Microsoft Excel Advanced\nOverview\nUnlock the full power of Excel. Master advanced analytics\, automate complex tasks with VBA\, build dynamic dashboards\, and transform raw data into predictive insights and interactive reports. \nTarget Audience: \nData analysts\, financial modelers\, business professionals\, and advanced users who need to perform complex data manipulation\, automation\, and forecasting. \nUpon completion\, students will be able to: \n\nPerform sophisticated data analysis and create dynamic dashboards with advanced PivotTable techniques.\nRecord\, write\, and run VBA macros to automate repetitive tasks and build custom functions.\nCreate advanced\, interactive charts and visualizations for dashboards.\nUtilize What-If Analysis tools (Goal Seek\, Data Tables\, Scenario Manager) for forecasting and modeling.\nImport\, transform\, and combine data from multiple sources using Power Query and build a simple Data Model.\nImplement advanced workbook\, worksheet\, and VBA project protection strategies.\n\nOutline\nModule 1: Advanced Data Analysis with PivotTables \n\nCalculated Fields & Items: Creating custom formulas within a PivotTable.\nGrouping Data: Advanced grouping of dates (by weeks\, quarters) and numeric fields into bins.\nSlicers & Timelines: Using slicers and timelines for interactive filtering across multiple PivotTables and PivotCharts.\n\nModule 2: Using Macros and VBA for Automation \n\nMacro Recorder Deep Dive: Recording complex macros and understanding relative references.\nIntroduction to the VBA Editor: Navigating the editor\, writing simple sub procedures\, and using MsgBox and InputBox.\nError Handling & Debugging: Writing robust macros that handle errors and debugging code.\n\nModule 3: Complex Charting Techniques \n\nCombination Charts: Creating charts that combine different chart types (e.g.\, Column and Line).\nDynamic Charting: Using named ranges with the OFFSET and COUNTA functions to make charts that automatically update with new data.\nAdvanced Formatting: Using form controls (like scroll bars and spinners) to create interactive charts.\n\nModule 4: What-If Analysis and Data Forecasting \n\nGoal Seek: Working backwards to find the required input to achieve a desired result.\nData Tables: Building one-way and two-way data tables for sensitivity analysis.\nScenario Manager & Forecast Sheet: Creating and comparing different scenarios and using the automated Forecast Sheet tool for time-based forecasting.\n\nModule 5: Data Model and Power Query Introduction \n\nPower Query (Get & Transform): Importing data from files\, databases\, and the web. Removing errors\, pivoting/unpivoting columns\, and creating custom columns.\nBuilding a Data Model: Creating relationships between multiple tables without using VLOOKUP.\nDAX Introduction: Writing basic DAX formulas (Measures) for calculated fields in PivotTables (e.g.\, SUMX\, CALCULATE).\n\nModule 6: Workbook Security and Protection \n\nWorksheet & Workbook Protection: Applying and cracking passwords to protect structure and windows. Locking and unlocking specific cells.\nFile-Level Security: Encrypting workbooks with passwords and marking as final.\nVBA Project Protection: Locking VBA code from viewing with a password.
URL:https://excelbi.co.za/event/microsoft-excel-advanced/2026-10-26/
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:20261103T090000
DTEND;TZID=UTC:20261104T130000
DTSTAMP:20260921T085041
CREATED:20260415T071948Z
LAST-MODIFIED:20260429T060336Z
UID:10000096-1793696400-1793797200@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/2026-11-03/
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:20261103T090000
DTEND;TZID=UTC:20261104T130000
DTSTAMP:20260921T085041
CREATED:20260415T073906Z
LAST-MODIFIED:20260415T073906Z
UID:10000329-1793696400-1793797200@excelbi.co.za
SUMMARY:Microsoft Outlook Fundamentals
DESCRIPTION:Course Overview:\nThis practical course equips you with the essential skills to use Microsoft Outlook effectively. Learn to navigate the interface\, manage your inbox\, organize contacts\, schedule meetings\, and track tasks to boost your daily productivity. \nTarget Audience:\nOffice workers\, students\, administrative staff\, and anyone new to Outlook or looking to strengthen their foundational skills. \nUpon completion\, students will be able to:\n\nConfidently navigate and customize the Outlook interface.\nCompose\, format\, and send professional emails\, including attachments.\nImplement strategies to organize and find emails efficiently.\nCreate\, manage\, and categorize contacts and contact groups.\nSchedule\, update\, and respond to calendar appointments and meetings.\nCreate and track personal tasks and reminders.\n\nOutline\nModule 1: Navigating the Outlook Interface \n\nThe Outlook Ecosystem: Overview of Mail\, Calendar\, People (Contacts)\, Tasks\, and Notes.\nThe Ribbon and Folders Pane: Understanding context-sensitive tabs and navigating your folder hierarchy.\nCustomizing Your View: Using the Reading Pane\, arranging messages\, and adjusting layout and view settings.\nPractical Activity: Navigate to each main module (Mail\, Calendar\, Contacts) and customize the Reading Pane location.\n\nModule 2: Composing and Sending Emails \n\nCreating a New Message: Using the To;\, Cc;\, and Bcc; fields appropriately. Writing clear subject lines.\nFormatting & Professionalism: Basic text formatting\, adding signatures\, and setting importance levels.\nWorking with Attachments: Attaching files and items from OneDrive. Understanding file size limits.\n\nModule 3: Organizing Emails with Folders \n\nFolder Management: Creating\, renaming\, and moving folders and subfolders for project- or sender-based organization.\nRules: Introduction to creating basic rules to automatically move\, flag\, or delete incoming messages.\nSearch and Filters: Using the instant search box and the Search Tools tab to find old emails quickly.\n\nModule 4: Using Contacts and Address Book \n\nCreating & Editing Contacts: Adding new contacts manually\, filling in key details\, and adding a photo.\nContact Groups (Lists): Creating a distribution list to send emails to a group of people at once.\nFinding and Using Contacts: Using the Address Book while composing an email and categorizing contacts for easy sorting.\n\nModule 5: Calendar Management Basics \n\nDifferent Appointment Types: Creating new appointments (for yourself) and meetings (inviting others).\nScheduling Assistant: Using the Scheduling Assistant to find a time that works for all attendees.\nManaging Invitations: Responding to meeting invites (Accept\, Tentative\, Decline) and adding notes.\n\nModule 6: Setting Tasks and Reminders \n\nThe Tasks Module: Creating a new task\, setting a due date\, priority\, and status.\nFlags and Reminders: Using the Follow Up flag to create quick email-based reminders.\nThe To-Do Bar: Understanding how Tasks\, Flagged Emails\, and your Calendar integrate in the To-Do Bar view.
URL:https://excelbi.co.za/event/microsoft-outlook-fundamentals/2026-11-03/
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-Basic.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261110T090000
DTEND;TZID=UTC:20261111T130000
DTSTAMP:20260921T085041
CREATED:20260415T072319Z
LAST-MODIFIED:20260429T060410Z
UID:10000156-1794301200-1794402000@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/2026-11-10/
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:20261110T090000
DTEND;TZID=UTC:20261111T130000
DTSTAMP:20260921T085041
CREATED:20260415T074155Z
LAST-MODIFIED:20260415T075859Z
UID:10000348-1794301200-1794402000@excelbi.co.za
SUMMARY:Microsoft Outlook Intermediate
DESCRIPTION:Overview\nTransform your inbox from reactive to proactive. Master advanced organization\, automation\, and management tools to streamline your workflow\, manage complex calendars\, and take control of your communication. \nTarget Audience: \nUsers comfortable with Outlook basics who manage high email volume\, complex calendars\, or need to optimize their workflow for efficiency. \nUpon completion\, students will be able to: \n\nImplement advanced email organization and cleanup strategies.\nManage complex meeting requests\, voting buttons\, and delegate access.\nCreate and manage contact groups and electronic business cards.\nUtilize advanced search (Search Folders) and categorization for rapid information retrieval.\nAutomate email management with sophisticated Rules and alerts.\nConfigure AutoArchive and use Outlook effectively offline.\n\nOutline\nModule 1: Advanced Email Features and Organization \n\nCleanup Tools: Using Clean Up Conversation\, Ignore Conversation\, and Sweep to manage email threads.\nAdvanced Message Options: Setting importance\, sensitivity\, delivery receipts\, and voting buttons.\nQuick Steps: Creating and using one-click Quick Steps to perform multi-action tasks (e.g.\, “Move to Project X & Flag”).\n\nModule 2: Managing Meetings and Appointments \n\nMeeting Options: Scheduling online meetings (Teams)\, setting up presenter options\, and using the Scheduling Assistant for large groups.\nManaging Responses: Tracking attendee responses and proposing a new time for a meeting.\nCalendar Delegation: Granting permissions for a delegate to manage your calendar and send meetings on your behalf.\n\nModule 3: Using Advanced Contacts Features \n\nContact Groups (Distribution Lists): Creating\, updating\, and using groups for frequent team communication.\nElectronic Business Cards: Customizing and sharing your digital business card via email.\nLinking Contacts: Linking multiple entries for the same contact (e.g.\, from an email and a meeting) to create a unified view.\n\nModule 4: Categorizing and Searching Emails \n\nColor Categories: Creating and applying custom color categories to emails\, calendar items\, and tasks for visual organization.\nAdvanced Find & Search Folders: Using the Search Tools ribbon to build complex search queries.\nCreating Search Folders: Setting up dynamic\, virtual folders that automatically gather emails based on specific criteria.\n\nModule 5: Setting Up Rules and Alerts \n\nAdvanced Rules: Creating server-side rules that run even when Outlook is closed\, using “AND/OR” logic for complex conditions.\nDesktop Alerts: Customizing desktop notification settings for new messages.\nManaging Rules: Editing\, re-ordering\, and troubleshooting existing rules for optimal performance.\n\nModule 6: Email Archiving and Offline Management \n\nAutoArchive: Understanding and configuring AutoArchive settings to automatically move old items to an archive (.pst) file.\nManual Archiving: Manually moving or exporting items to an archive file for backup or storage.\nOffline Use: Using Cached Exchange Mode\, working offline\, and managing OST files.
URL:https://excelbi.co.za/event/microsoft-outlook-intermediate/2026-11-10/
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-Intermediate.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20261116T090000
DTEND;TZID=UTC:20261118T130000
DTSTAMP:20260921T085041
CREATED:20260415T074448Z
LAST-MODIFIED:20260415T074448Z
UID:10000367-1794819600-1795006800@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/2026-11-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/04/Outlook-Advanced.png
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
END:VCALENDAR