/
/
/
/
Add to shortlistShortlisted by 11 people

https://www.hotcourses.com/courses-by-subject/Microsoft-Excel-VBA-Introduction-courses/57159744/

Course description

Microsoft Excel VBA Introduction:


COURSE OUTLINE

Full details of modules and topics covered in this one-day course

VERSIONS COVERED

This course covers 2007, 2010, 2013 and 2016 versions

DURATION

This is a one-day training course structured into 5 modules

COURSE AIMS

This intensive, hands-on one-day course has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming, and understand (and use) the relevant techniques.

TARGET AUDIENCE

The course is designed for existing, experienced users of Excel 2007, 2010, 2013 or 2016 who need to use VBA to automate their spreadsheets.
Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level. Familiarity with the content of the Advanced course would be a minimum requirement although the Professional level is ideal.

ABOUT MICROSOFT VBA

VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language.


MODULE 1: Recording and Running Macros in Excel
Setting Excel Macro Options

Record and Run Simple Macros
Assign Macros to the Quick Access Toolbar

MODULE 2: Introduction to the Excel VBA Editor
Starting the Visual Basic Editor

Using the Project Explorer
Using the Properties Window
Creating, Importing and Exporting Modules
Explore Recorded Macros

MODULE 3: Creating Procedures and Functions
Creating Sub and Function Procedures

Declare and Use Variables
Displaying Message to the User
Getting Input from the User

MODULE 4: Working with the Excel Object Model
Understanding Objects, Properties and Methods

Referencing Cells and Ranges
Gathering Cell and Range Information
Using the Offset Method
Using the Resize Method
Using With Blocks
Referencing Workbooks and Worksheets

MODULE 5: Controlling Program Flow
Using the IF Statement

Using the Select Case Statement
Using For Next Loops
Using Do Loops
Using For Next Loops

Additional entry requirements

The course is designed for existing, experienced users of Excel 2007, 2010, 2013 or 2016 who need to use VBA to automate their spreadsheets.
Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level.   Familiarity with the content of the Advanced course would be a minimum requirement although the Professional level is ideal.

Training for employers

This course has been specifically designed for companies training their employees.

Course reference: ATMSXL616 (use this when contacting provider)

Course info
START DATES
SEPTEMBER 2018
Sun Mon Tue Wed Thu Fri Sat
OCTOBER 2018
Sun Mon Tue Wed Thu Fri Sat

Location:

Birmingham, B4 7LR, Bristol, BS1 6EA, Leeds, LS1 3BE, London, E1W 1AW, London, SW1H 0HW + 4 more

Time:

9:30am - 4:30pm

Duration:

7 hours

Attendance:

Full time

Qualification:

Certificate of Attendance

Level:

BeginnerIntermediateAdvanced

From: £298.80

Other Visual Basic courses

Microsoft Excel VBA Advanced

Activia Training

Duration: Variable

Advanced

Certificate of Attendance

View 1 courses

Course reviews

This course currently has no reviews.

Write a review

Course photos

  • Microsoft Excel VBA Introduction by Activia Training on Hotcourses

Ask a question

Get course info