Courses

Excel Objects

= Scheduled class    = Guaranteed to run    = Fully booked

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.

About this Course

This course is designed for users with knowledge of Visual Basic for Applications and who wish to create procedures for Microsoft Excel.

Our aim is to provide you with the necessary understanding of Excel Objects to use them effectively.

It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.

Prerequisites

We recommend that students have:

• Completed our VBA Essential Skills course or have an equivalent knowledge of VBA
• A moderately high level of ability with Excel. You don’t have to be a guru but you do need to know what’s going on.

At Course Completion

Using VBA in Excel can cover anything from getting the machine to perform repetitive tasks through to creating your own worksheet functions. This course assumes you are comfortable with the topics covered in the VBA Essential Skills course and are ready to learn how to interact with Excel.

Course Outline

• What is an Object?
• Using Objects in Code
• Using Range Objects
• Collections
• Using the Object Browser
• Working with Values in a Range
• Copying and Moving Data
• Working with Chart Object
• Working with Events
• Using Command Bars

 Print this page