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

Master IT Logo

Microsoft PowerPoint

All those tricky extras – not so tricky when someone shows you how. Our tutors can provide step-by-step Training in Microsoft PowerPoint.

by Master IT [Claim Listing ]
knowitinc Logo

Microsoft Excel Training

This session will provide you with the essential skills to get started with Excel.You will learn to handle text and data entry, format, print and use entry level or basic formulas to perform calculations.

by knowitinc [Claim Listing ]
Skills Campus Logo

Analysing and Visualizing Data with Excel

This course will teach you how to use Excel to perform data analysis and visualisations. As a beginner-level course, it is ideal for individuals interested in how to use Excel to explore, analyse, and present data with interactive visualisations.

by Skills Campus [Claim Listing ]
Ripped Orange Logo

MS Word (Working With Large Documents)

Are you working with large documents in Microsoft Word and finding it challenging? Then this virtual course is for you! Learn how to work with large documents effectively, and get tips and tricks from our experts. This course will help you save time and be more productive. 

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

Access Level 1

Covers the concepts and basics of creating a relational database. How to create the various parts of the database and how to work with existing database files.

by Sue's Computer Training Co [Claim Listing ]

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