BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Business Institute - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://excelbi.co.za
X-WR-CALDESC:Events for Excel Business Institute
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260824T090000
DTEND;TZID=UTC:20260826T130000
DTSTAMP:20260824T132348
CREATED:20260415T071621Z
LAST-MODIFIED:20260415T071621Z
UID:10000062-1787562000-1787749200@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-08-24/
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
END:VCALENDAR