Prerequisites
To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level.
Course Overview
This course will teach you how to automate repetitive tasks in Excel by recording macros. You will learn how to edit and string macros.
You will then learn how to write a code in the Visual Basic Editor. Controls worksheets, workbooks and create message boxes. You will also learn about creating User Forms, custom functions, conditional statements, events and looping over instructions.
VBA Course Topics
1. Record A Simple Macro
2. Record a Macro
3. Run a Macro
4. Understand the VB Editor
5. Use the Menu Bar
6. Use the Standard Toolbar
7. Use the Project Explorer
8. Use the Properties Window
9. Understand the Code Window
10.Understand Code Window Options
11.Edit Code
12.Get Help
13.Close the Visual Basic Editor
14.Work with Objects
15.Understand the Object Browser
16.Understand Objects
17.Understand the Objects Hierarchy
18.Reference Objects
19.Understand Collections
20.Use the Editing Features
21.Use the Immediate Window
22.Use the Auto List
23.Use Auto Quick Info
24.Work with Variables
25.Understand Variables
26.Declare Variables
27.Understand Data Types
28.Store Values in Variables
29.Store Objects in Variables
30.Create Procedures and Functions
31.Understand Procedures
32.Use the Macro Recorder to Create Sub Procedures
33.Call Procedures from Procedures
34.Use Intrinsic Functions
35.Use Message Boxes
36.Use Input Boxes
37.Create Functions
38.Pass Arguments to a Function
39.Work with Conditional Statements
40.Understand Conditional Statements
41.Work with Decision Structures
42.Work with Loop Structures
43.Work with Forms and Controls
44.Understand Userform
45.Use the Toolbox
46.Work with Userform Properties
47.Events and Methods
48.Use the Properties Window
49.Understand Controls
50.Work with the Label Control
51.Work with the Text Box Control
52.Work with the Command Button Control
53.Work with the Combo Box Control
54.Work with the Frame Control
55.Work with the Option Button Controls
56.Add Functionality to Forms
57.Work with Control Appearance
58.Set the Tab Order
59.Populate a Control
60.Add Code to Controls
61.Launch Forms from Procedures
62.Use Pivot Tables
63.Understand PivotTables
64.Create PivotTables
65.PivotTable Arguments
66.Add Fields to PivotTables
67.Control Forms
68.Control PivotTables from a Form
69.Control a Form from a Custom Toolbar
70.Understand Debugging
71.Understand Errors
72.Debug Code
73.Debug Tools
74.Use the Locals Window
75.Use the Watch Window
76.Use Breakpoints
77.Create Add-in
