Show findcourses.co.uk as: Mobile

Excel VBA Programming for Financial Professionals

Informa Middle East
Course summary
Length: 4 days
Language: Arabic
Location: Dubai
Next available date: 24/12/2017 - Dubai

Course Description

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?

This course is designed for financial professionals who use Microsoft Excel 2003 and above. The course will benefit intermediate to advanced Excel users who want to improve the efficiency of their spreadsheets through using the VBA platform.

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

Expenses

Contact Informa for more information and pricing details.

Provider: Informa Middle East

Informa Middle East - Professional development courses & conferences across the 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...


Read more and show all courses with Provider: Informa Middle East

Request information - obligation free

Fill out your details to find out more about Excel VBA Programming for Financial Professionals.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for Informa Middle East

Informa Middle East


Level 20 in the World Trade Centre Tower,
PO Box 9428
Dubai

 Show phone number
www.iirme.com