Training
Report Automation with Excel VBA/MacrosGet ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility
Duration: 3 days | 18 hours
Available delivery methods:
Classroom
Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility
Course Information
This course is designed for users who have leveraged on the rich set of features in the standard Excel user interface but are looking for an easier and faster way to perform mundane, repetitive data manipulation, analysis and reporting processes.
By using Excel VBA for automation, you can significantly cut down the time and improve your overall productivity. Further you can use VBA to build new capabilities into Excel for enhanced data visualization and building professional dashboards and interfaces. This training course is suitable for all versions of Microsoft Excel.
Key areas covered on the course include:
- Getting started with VBA Programming
- Working with Variables, Constants and Arrays
- The Excel Objects Framework
- Properties and methods
- Object Hierarchy & Collections
- Controlling Program Flow and Decisions
- Applications of Excel VBA Control Statements
- Exiting control structures
- Working with Ranges and/or Cells
- Working with other workbooks and files
- Automation using Events
- Understanding event handlers
- Workbook, worksheet and chart events
- Illustrations of Events
- Forms and Controls
- Error Handling and Macro Debugging
- Error Handling Routine
- Handling Errors
Find out more
Or call us now
+254 20 222 95 66
+254 716 56 88 99
+254 732 56 88 99
Interested in our training courses?
Get 20% off!
...on select training bundles.
Our Best Selling Courses
Microsoft Excel - Essentials
Become more effective in your reporting processes. Gain useful data manipulation skills!
Advanced Analysis & Visualization in Excel
Make the process of “Data to Decisions” efficient and cost effective.
Analytics for Finance Professionals in Excel
Drive productivity, efficiency, transparency and lower risk as a Finance professional.
Advanced PowerPoint
For professional, engaging in presentations that yield results.
Microsoft Excel - Intermediate
Become more effective in your reporting processes. Gain useful data manipulation skills!
Report Automation with Excel VBA/Macros
Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility.
Microsoft Power BI
Connect, Integrate, Model and Visualize Business Data Reliably!
Microsoft Excel - Advanced
Connect, Integrate, Analyze and Visualize data like a pro!
Advanced Excel + Financial Modelling & Forecasting in Excel
Efficiently build an effective and robust financial model based on real-world financial modelling challenges.
Data Analysis & Visualization in Power BI
Connect, Integrate, Model and Visualize Business Data Reliably!
R for Data Science
Python for Data Science
