Excel & Office Productivity
excel Essentials
A practical, beginner-friendly introduction to spreadsheet fundamentals, covering data entry, formatting, core formulas,...
4 Weeks Beginner Certificate
Self-paced
Beginner
Excel VBA & Macros
A masterclass in automating repetitive tasks, building custom user forms, and developing robust programmatic solutions using Visual Basic for Applications (VBA) and Macros in Microsoft Excel.
6 Weeks Verified certificate
What you'll learn
- Macro Recording & Code Inspection: Record, inspect, and modify macro code using the Visual Basic Editor (VBE) to automate basic repetitive tasks and understand VBA syntax.
- VBA Programming Fundamentals: Master core programming constructs in VBA, including variables, data types, scope, conditional logic (If...Then, Select Case), and loops (For...Next, For Each, Do...Loop).
- Excel Object Model Manipulation: Programmatically reference, control, and manipulate workbooks, worksheets, cell ranges, and charts dynamically using code.
- Custom Functions & Error Handling: Build custom User-Defined Functions (UDFs) to perform specialized calculations and implement robust error-handling routines (On Error Resume Next, On Error GoTo) to ensure stable execution.
- UserForms & Automation Workflows: Design custom UserForms with interactive controls (buttons, textboxes, listboxes) and write scripts that automate batch data processing across multiple external files.
Course content
The full curriculum is being finalised. Contact us for the syllabus.
About this course
Unlock the true programmatic power of Microsoft Excel by moving beyond standard formulas and mastering VBA (Visual Basic for Applications) and Macros. This course takes you from recording your first simple macro to writing sophisticated, modular VBA code, custom user-defined functions (UDFs), and interactive user forms. You will learn how to navigate the Visual Basic Editor, manipulate the Excel object model (Workbooks, Worksheets, Ranges), handle runtime errors, automate complex multi-file data processing, and build tailored tools to eliminate manual bottlenecks.
Tools you'll use
Microsoft Excel VBAVisual Basic Editor (VBE)Macro RecorderMicrosoft Excel 365Desktop Excel Environment
Learn anywhere
Phone, tablet or laptop. Pick up exactly where you left off.
Hands-on practice
Quizzes, coding exercises and projects marked by instructors.
Verified certificate
Each certificate has a code employers can verify online.
You might also like
Excel & Office Productivity
Excel Intermediate
A practical course designed to elevate spreadsheet skills by mastering advanced lookup functions, conditional logic, Piv...
Beginner Certificate
Excel & Office Productivity
Excel Advanced Formulas & Functions
An advanced, formula-driven course mastering modern dynamic arrays, financial and statistical functions, nested computat...
4 Weeks Beginner Certificate
From
KES 4,500