Excel Intermediate: Organising Workbooks and Worksheets

Explore advanced workbook management techniques including linking worksheets and workbooks, data consolidation, conditional formatting, data validation, worksheet protection, change tracking, comments, grouping, outlining, and What-If Analysis tools such as Goal Seek and Scenarios. 

Excel Intermediate: Databases and Pivot Tables

Learn how to manage and analyse large datasets using sorting, filtering, subtotals, database functions, and PivotTables. Create PivotCharts, group data, build running totals, import external data, and generate insightful management reports. 

Excel Advanced: Introduction to Macros

Discover how macros can automate repetitive tasks in Excel. Learn about the Developer tab, recording macros, assigning macros to buttons and shortcuts, saving macros, understanding VBA code, and creating simple custom VBA functions. 

Excel VBA: Recording and Basic Editing of Macros

Gain practical experience recording, running and modifying macros. Topics include macro principles, procedures, modules, editing recorded code, and creating custom buttons to automate routine tasks. 

Excel VBA: Introduction to Writing Macros

Move beyond recorded macros and learn VBA programming fundamentals. Explore objects, properties, methods, variables, loops, IF statements, Select Case structures, message boxes, input boxes, debugging techniques, and procedure management. 

Excel VBA: Using Form Controls and Events

Advance your VBA skills by creating user forms, controls and event-driven applications. Learn to build interactive solutions using combo boxes, check boxes, option buttons, event procedures, VBA charts, and techniques to protect and secure VBA code.