Start Of Header
 
Basket
You have 0 items in your Shopping Basket
End Of Header
 Event Details
Product
Title:Automating Forecasting and Reporting with Excel VBA Macros (introduction)
Ref:PC12IDTDAFRE
Supplier:CAET
Category:Course
Product Type:Professional Courses
Product Group:Corporate Sector

 Available Dates
Courses Available
Available Events


 Event Outline
Course Outline
AUTOMATING FORECASTING AND REPORTING WITH EXCEL VBA MACROS (INTRODUCTION)

You could make Excel work harder, particularly repetitive reporting tasks. This course introduces Visual Basic for Applications (VBA) – the language used to write macros. Through the use of hands-on examples the course will illustrate the process of creating bespoke reports from large quantities of data (no previous programming experience required).

KEY FEATURES
• review and understanding of the VBA development environment
• understanding objects, methods and properties
• writing procedures and functions to control Excel
• designing and using user forms and working with message and input boxes
• how to avoid bugs, debugging and error handling.

Document

Document

Registration name - CERTIFIED ACCOUNTANTS EDUCATIONAL TRUST - Registered office - 29 LINCOLN'S INN FIELDS, LONDON, WC2A 3EE - Registered Charity Number.313219 - © 2010 ACCA