Want inspiration and special offers for your development? Sign up to our email alerts here!
Excel VBA Programming for Financial Professionals: 4-day course
Since the introduction in 1978 of the VisiCalc row-and-columnbased layout of what we know as spreadsheets today, these have evolved to become powerful business tools that are widely used across business functions. Step into any of the various departments in a business and you will find some business processes that are supported by spreadsheets – a budget spreadsheet to assist the Finance department, a customer spreadsheet used in Marketing, employee data maintained on a spreadsheet in Human Resources – the opportunities for using Excel spreadsheets to improve business efficiencies are endless.
Microsoft's Excel application includes a myriad of tools that, with the correct knowledge, can be applied to improve any spreadsheet-appropriate business process. One of the tools that provides for creating structured programmes directly in Excel is the visual basic programming tool, and it provides for an improved user experience whilst reducing the risk of user-input error.
This course will provide you with an understanding of the fundamental concepts appropriate to using Excel's VBA programming platform. The course also provides a basis for understanding how these concepts can be applied in your working environment to improve financial processes using Excel as a business tool.
Suitability - Who should attend?
Training Course Content
Gain An Understanding Of VBA Basics And How VBA Is Implemented In Excel
- Introduction To VBA
- The Visual Basic Editor (VBE)
- The Excel Macro Recorder
- The Excel Object Model
- VBA Procedures
Gain An Understanding Of The Programming Concepts Applicable To VBA
- VBA Language Elements
- Range Objects
- Worksheet Functions
- Controlling Programme Flow
Expanding Your Understanding Of The Programming Concepts Applicable To VBA
- Automatic Procedures And Events
- VBA Errors And Debugging
Creating Custom Dialogue Boxes And Using User Forms That Establish A Basis For Communicating With Your Spreadsheet Users
- Creating Dialogue Boxes
- Creating User Forms
Practically Applying The Basics Of VBA In Excel Covered On The Course
Provider: Informa Middle East
Informa Middle East offers a broad selection of open courses and in house training programmes, covering the key professional areas: Finance and Investment, IT and telecommunications, HR, Business Administration, Health & Safety and Marketing. Informa Middle East is part of...