Our classroom TRAINING PROVIDES YOU THE OPPORTUNITY TO INTERACT WITH
INSTRUCTORS AND BENEFIT FROM FACE-to-face instruction.COURSE OVERVIEW:
This VBA course is an introduction to VBA macro programming for
automating accounting and finance functions.
This VBA course assumes participants have little or no prior
programming experience, although it will be highly beneficial if
participants have at least recorded a macro previously and have
examined the VBA code a little.
TARGET AUDIENCE:
* Management Accountants
* Financial Accountants
* Cost Accountants
* Business Analysts
* Finance and Cost Analysts
* CFO’s
* Finance Managers
* Business Bankers
* Corporate Finance Analysts
LEARNING OBJECTIVES:
* The skills and abilities required to write your own VBA macros.
* The ability to identify opportunities to utilise macros
effectively.
* A sound introduction to VBA best-practice programming concepts.
PREREQUISITES:
None
COURSE MATERIALS:
Students will receive a course manual with presentation slides and
reference materials.
EXAMINATION:
There is no exam for this course.
TECHNICAL REQUIREMENTS:
For eBooks:
Internet for downloading the eBook
Laptop, tablet, Smartphone, eReader (No Kindle)
Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)
eBook download and activation instructions
AGENDA:
Days 1 and 2: Introduction to Excel VBA
INTRODUCTION TO VBA
* An introduction to all the building blocks required to write macros
in Excel’s VBA.
INTRODUCTION TO PROGRAMMING
* An introduction to programming concepts and writing code.
* Best practices to make your VBA easier to read, quicker to run, and
more robust.
CONTROLLING CODE
* How to make code do what you want it to do.
* How to write code that can be easily modified.
* How to make your macros run as fast as possible.
INTERACTING WITH EXCEL
* How to automate common Excel functions such as copy, move, format,
print, delete etc.
* Getting responses from users.
* How to read/write data from/to Excel worksheets.
* How to write your own functions and extend the range of functions
available in Excel.
* How to link your macros to buttons and other controls.
DEBUGGING
* How to use VBA’s tools to quickly find problems and errors then
resolve them.
FILES
* How to create new Excel files within VBA.
* How to open existing Excel files via VBA.
* How to save Excel files using VBA.
* How to work with multiple Excel files and copy or move data between
them.
RELATED COURSES
High-Powered Excel for Finance (1 day)
music
sports
322
Views
10/08/2021 Last update