Excel VBA Programming Introduction

£75.00£2,250.00

SKU: GCOL-EXL-VB1 Category:

Description

The video tutorials in this self-paced, Excel VBA online training course will show you how to automate Microsoft Excel tasks and operations. It is aimed particularly at Excel users, without much programming experience, who struggle to remember the syntax and structure of the VBA programming language. During the course, we will use a style of programming which emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft’s code completion feature.

Whether you are looking for Excel VBA online training to enhance your career prospects, save your company money or increase your productivity, this course will provide your with all the knowledge you need to get started.

You can download all of the materials used in the lectures, so that you can follow along.

COURSE OUTLINE

1. Getting Started

1. Course introduction
2. Excel VBA overview
3. The Developer Tab
4. Macro security
5. The Visual Basic Editor and Project Explorer
6. Excel objects and event code
7. Writing a macro in the VBE
8. Using the Immediate window
9. Saving a macro-enabled workbook
10. The correct way to use the macro recorder
11. Analysing a recorded macro
12. Improving a recorded macro
13. Assigning a macro to a button
14. Testing a macro on another worksheet

2. Key Components of VBA Code

1. The Excel object model
2. VBA classes and functions
3. Properties and methods
4. Data variables
5. Object variables
6. Option explicit
7. Declaring And Using Constants
8. Using MsgBox for Output
9. Using MsgBox for Input
10. Using VBA InputBox
11. Using Application.InputBox

3. VBA Control Statements

1. If Statements
2. If … ElseIf Statements
3. Select Case
4. For … Next Loops
5. For Each … Next Loops
6. Do … While Loops
7. Do … Until Loops
8. Creating Arrays
9. Dynamic Arrays
10. Utilising Arrays

4. Procedures and Functions

1. Sub Procedures and Module Level Variables
2. Static Variables
3. Passing Parameters
4. Creating and Calling Functions
5. Creating User-defined Functions

5. The Application Object

1. Changing and Restoring User Settings
2. Application.GetOpenFilename
03. Application.GetSaveAsFilename
4. Controlling Screen Updating
5. Suppressing Warning Messages

6. Code Recognition Clinic

1. Example 1
2. Example 2
3. Example 3
4. Example 4
5. Example 5
6. Example 6
7. Hyper-disambiguation Practice

7. Files and Workbooks

1. Targeting Workbooks Efficiently
2. Checking Whether A Workbook Is Open
3. Checking Whether Several Workbooks Are Open
4. Checking Whether A File Exists
5. Checking Whether A Folder Exists
6. Deleting Files And Folders
7. Processing All Files In Folder

8. Worksheets and Charts

1. Targeting Worksheets Efficiently
2. Copying Worksheets
3. Moving Worksheets Between Workbooks
4. Saving Worksheets As Seperate Workbooks
5. Working With The Sheets Collection
6. Creating A Standalone Chart
7. Creating An Embedded Chart

9. The Range Object

1. Copying A Range of Cells
2. Using the Offset Property
3. The End Property
4. The Resize Property
5. Entering Formulas With VBA
6. Deleting Ranges
7. Inserting Ranges
8. Outlining Ranges

Additional information

Users

Single User, 2 Users, 5 Users, 10 Users, 25 Users, 50 Users, 100 Users