Course description
Take “The Excel VBA Programming Course” to learn Excel Visual Basic for Applications (VBA), the Microsoft’s programming language for Excel and all the other Microsoft Office programs:
- Learn Object Orientated Programming
- Record and save Macros
- Work with the VBA Editor
- Learn Variables and Procedures
- Learn Loops and IF Statements
- Learn Error Handling
- Learn User Defined Functions
- Create Forms
- Practice with assignments
Who this course is for:
- Students and Corporate employees wanting to improve their Excel skills
Video Order
- Section 1
- What is VBA (00:58)
- Object Orientated Programming (06:17)
- Section 2
- Macros Initial Setup (04:48)
- Recording a Macro (05:41)
- Saving a Macro (04:16)
- Section 3
- Launching VBA (04:03)
- VB Editor (05:10)
- Custom Menu (02:50)
- Naming Projects (05:18)
- Modules (02:42)
- Code Window (01:43)
- Comments (06:37)
- Section 4
- Introduction (01:30)
- Variables (06:24)
- Variable Exercise (05:54)
- What are Procedures (05:45)
- What are Procedures – Part Two (06:25)
- What are Procedures – Part Three (03:00)
- Message Boxes (04:58)
- Input Box (05:59)
- Input Box – Part Two (03:45)
- Basic Navigation (11:54)
- Sheets (13:06)
- Cell Navigation (08:38)
- Advanced Sheets (08:45)
- Offset (05:25)
- Section 5
- Introduction (00:39)
- Operators (01:56)
- Using Variables (12:09)
- What is Automation (01:12)
- For Loop (06:30)
- Do Loops (06:08)
- IF Statements (14:21)
- IF Statements – Part Two (10:10)
- Select Case (12:21)
- Section 6
- Debugging (02:42)
- Section 7
- UDF’s (12:36)
- (Resource – [Beginner Shortcut Keys.pdf])
- File UDF’s
- Section 8
- Introduction (00:47)
- Exercise 1 – Record a Macro (07:03)
- (Resource – [Beginner Shortcut Keys.pdf])
- File Insert Text
- Exercise 2 – Duplicating Data (07:45)
- (Resource – [Beginner Shortcut Keys.pdf])
- File All Sheets
- Exercise 3 – Generate a Report (12:42)
- (Resource – [Beginner Shortcut Keys.pdf])
- File Generate Report
- Generate a Report – Part Two (07:29)
- Exercise 4 – Inner and Outer Loops (09:27)
- (Resource – [Beginner Shortcut Keys.pdf])
- File Weekly Stock Report
- Inner and Outer Loops – Part Two (11:54)
- Inner and Outer Loops – Part Three (08:18)
- Inner and Outer Loops – Part Four (09:45)
- Inner and Outer Loops – Part Five (12:45)
- Section 9
- Form Controls (04:01)
- Building the Form (15:17)
- Initialize the Form (07:12)
- Command Buttons (18:36)
- Command Buttons – Part Two (07:00)
- UDF’s (12:36)
Course Curriculum
Course Reviews
No Reviews found for this course.
3 STUDENTS ENROLLED