Microsoft Excel VBA Programming
Training
Online
Description
-
Type
Training
-
Level
Beginner
-
Methodology
Online
-
Class hours
12h
-
Duration
2 Weeks
-
Start date
Different dates available
Excel VBA programming can seem baffling, especially when you don't fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.
This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) 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 to enhance your career prospects by adding Excel VBA to your C.V., 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.
Facilities
Location
Start date
Start date
About this course
By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.
You will fully understand the purpose and syntax of each line of code that you write.
You will not simply be entering lines of code because you have been told they will produce a certain result.
You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.
Experienced Excel users who are new to Excel VBA programming.
Microsoft Excel 2016, 2013, 2010 or 2007 running on Windows 7, 8 or 10.
Certificate of completion
A free trail version of this course is available.
Sign up for the free trail version of this course. If it meets with your expectations, then enroll for the full course.
Reviews
Subjects
- Excel
- Visual Basic training
- Microsoft Excel
- Syntax
- Property
- Visual Basic
- Programming
- Programming Application
- Excel Formula
- Microsoft excel training
- MS Excel
- Object-oriented programming
- VBA (Microsoft Access / Office)
Teachers and trainers (1)
Microsoft Specialist
Experienced vba developer and trainer
Course programme
Download course practice files
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 Code1. 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 Statements1. 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 Functions1. 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 Object1. Changing and Restoring User Settings
2. Application.GetOpenFilename
03. Application.GetSaveAsFilename
4. Controlling Screen Updating
5. Suppressing Warning Messages
6. Code Recognition Clinic1. Example 1
2. Example 2
3. Example 3
4. Example 4
5. Example 5
6. Example 6
7. Hyper-disambiguation Practice
7. Files and Workbooks1. 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 Charts1. 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 Object1. 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
Microsoft Excel VBA Programming