Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Macros
- Recording and editing macros for government use
- Assigning macros to forms, toolbars, keyboard shortcuts
VBA Environment
- Visual Basic Editor and its options for government applications
- Management components for enhanced governance
- Keyboard Shortcuts for efficient workflows
- Optimizing the environment to meet public sector standards
Introduction to Procedural Programming
- Procedures: Function Sub for government processes
- Data types for accurate data handling
- The if statement ... then ... elseif ... else ... end if for decision-making
- Case statement for multiple conditions
- Loops for ... loop while, until for iterative tasks
- Loop for ... next for structured iterations
- Instructions loop break (exit) for controlled exits
- Array processing for managing data sets
Quoted String
- Combining quoted strings (concatenation) for government reports
- Conversion to other types of (implicit and explicit) for data integrity
- Features processing quoted strings for enhanced functionality
Visual Basic
- Download and upload data to a spreadsheet (Cells, Range) for government datasets
- Download and upload data to the user (InputBox, MsgBox) for interactive applications
- The declaration of variables for clear code
- The extent and lifetime of variables for managed resources
- Operators and their priorities for accurate calculations
- Options modules for custom configurations
- Create your own functions and use them in a sheet for government tasks
- Objects, classes, methods, and properties for structured programming
- Securing code for government compliance
- Security code tampering and preview for robust applications
Debugging
- Processing step by step for thorough testing
- Locals window for variable inspection
- Immediate window for quick evaluations
- Traps - Watches for monitoring variables
- Call Stack for understanding execution flow
Error Handling
- Types of errors and ways to avoid them for government applications
- Capturing and handling run-time errors for reliability
- Structures: On Error Resume Next, On Error GoTo for error management
Excel Object Model
- The Application Object for comprehensive control
- Workbook object and a collection of Workbooks for managing documents
- Worksheet Object and Collection Worksheets for data organization
- Objects ThisWorkbook, ActiveWorkbook, ActiveCell for current context
- Object Selection for user interactions
- Collection Range for cell management
- Object Cells for individual cell operations
- Display data on the status bar for real-time feedback
- Optimization using ScreenUpdating for performance
- The time measurement by the method Timer for efficiency
Event Handling in VBA
- What is an event? for government workflows
- Responding to an event and create an event handler for automated processes
- Triggering Event Handlers for dynamic responses
- Service frequently occurring events for streamlined operations
VBA Forms
- Create your own forms for government applications
- Calling a form from code for integrated solutions
- Use the forms in the sheet for user-friendly interfaces
Requirements
- Ability to work with a spreadsheet, including basic knowledge of references, ranges, and sheets.
- No prior VBA background is required to create macros or VBA code for government use.
Audience
- Data Analysts for government agencies.
21 Hours
Testimonials (5)
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Visual Basic for Applications (VBA) w Excel - wstęp do programowania
A lot of exercise. Trainer doesn't need to have support for his course. He has really great knowledge for his subject.
Quentin Demeyere
Course - Visual Basic for Applications (VBA) in Excel - Introduction to programming
It was really nice of the trainer that he took a lot of time to answer our questions and helped us improve or gave us hints on how to improve some macros we were already using without fully understanding the code.
David Trieu - CD Projekt SA
Course - Visual Basic for Applications (VBA) in Excel - Introduction to programming
I genuinely enjoyed the short exercises.
Mateusz Podsiadlo
Course - Visual Basic for Applications (VBA) in Excel - Introduction to programming
Training agenda was well thought out.
