Excel Visual Basic For Applications

by Ardito Corporate Training Claim Listing

This course aims to cover in detail the Visual Basic for Applications programming language. You will learn how to program in VBA in order to customise your work environment in Excel. You will learn to understand programming terminology such as modules, procedures, variables and constants.

$895

Contact the Institutes

Fill this form

Advertisement

Ardito Corporate Training Logo

img Duration

2 Days

Course Details

This course aims to cover in detail the Visual Basic for Applications programming language. You will learn how to program in VBA in order to customise your work environment in Excel. You will learn to understand programming terminology such as modules, procedures, variables and constants. You will learn form design, control structures and how to debug and test your VBA application before using it in the work environment.

 

Upon completing this course, you will have learned how to:

  • Understanding Templates and Macros
  • Looking at the Visual Basic Editor
  • Recording a macro
  • Designing Forms
  • Learning to write code
  • Understanding Procedures
  • Using Variables and constants
  • Understanding Properties, Methods, Events and Objects
  • Understanding the Range Object (in Excel)
  • Control structures
  • Debugging and Error-trapping
  • Hamilton Branch

    Level 2, London Business Centre, 55 London Street, Hamilton

Check out more MS Excel courses in New Zealand

Sue's Computer Training Co Logo

PowerPoint

An easy-to-use presentation graphics program.  PowerPoint gives you the tools to quickly produce professional looking presentations.

by Sue's Computer Training Co [Claim Listing ]
Auldhouse Logo

Microsoft Excel (Data Analysis and Reporting)

You will automate some common Excel tasks, vLookups, apply pivot analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data.

by Auldhouse [Claim Listing ]
Linkit Group Logo

Microsoft Word

This course is designed for all staff who Create reports on a daily basis,Are involved with the review and publication of reports created by their team members Need to create educational assignments and reports

by Linkit Group [Claim Listing ]
Master IT Logo

Microsoft Excel

Taught yourself Excel? Think there might be an easier way to do things? There certainly is. Let one of our friendly tutors show you how.

by Master IT [Claim Listing ]
ACE Training Ltd Logo

Excel Essential Skills

In this course you’ll learn by doing and get a good overview of what Excel is capable of and how to use it more effectively by creating a simple Excel report that demonstrates how to use Excel without breaking anything.

by ACE Training Ltd [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy