Training

Report Automation with Excel VBA/Macros

Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility

Report Automation with Excel VBA/Macros

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

Are you ready to transform your business?

Contact Us

0716 56 88 99

Pin It on Pinterest