Description

Learning Objectives

Introduction , Getting Started with VBA , Working with Variables , Working with Conditional Logic , Working with Strings and String Functions , Working with Loops , Working with Sub Procedures Options and Functions , Working with User Forms , Debugging your Code , Conclusion

Pre-Requisites

Intermediate Microsoft Excel training or equivalent experience is recommended.

Description

This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.

Course Introduction
	Introduction	00:03:00
Section 01
	Lesson 1-Adding the Developer Toolbar	00:05:00
	Lesson 2-Understanding the VBA Editor	00:11:00
	Lesson 3-Recording a Macro in Personal	00:10:00
	Lesson 4-Understanding the Elements of the VBA Language	00:07:00
	Lesson 5-Understanding Methods	00:05:00
	Lesson 6-Understanding Comments	00:06:00
	Lesson 7-Working with the Range Property and Worksheet Object	00:07:00
	Lesson 8-Adding a Macro Button to a Spreadsheet	00:03:00
	Lesson 9-Working with the ActiveCell Object	00:02:00
	Lesson 10-Working with the Offset Property	00:08:00
Section 02
	Lesson 1-Understanding Variables	00:07:00
	Lesson 2-Working with Integer Variables	00:03:00
	Lesson 3-Understanding Option Explicit	00:05:00
	Lesson 4-Working with Other Variable Types	00:07:00
Section 03
	Lesson 1-Working with IF Statements	00:04:00
	Lesson 2-Working with ELSE	00:03:00
	Lesson 3-Working with ELSEIF	00:03:00
	Lesson 4-Understanding Conditional Operators	00:06:00
	Lesson 5-Working with NOT, AND, and OR	00:07:00
	Lesson 6-Working with Nested IF	00:04:00
	Lesson 7-Working with Select Case	00:06:00
	Lesson 8-Working with WITH and END WITH	00:05:00
Section 04
	Lesson 1-Working with Text Strings	00:05:00
	Lesson 2-Working with LCASE and UCASE Functions	00:05:00
	Lesson 3-Working with LEN and TRIM Functions	00:07:00
	Lesson 4-Working with LEFT, RIGHT, and MID Functions	00:07:00
Section 05
	Lesson 1-Understanding Loops	00:02:00
	Lesson 2-Working with For Next Loops	00:07:00
	Lesson 3-Working with For Each Loops	00:06:00
	Lesson 4-Working with Cells Property	00:08:00
	Lesson 5-Working with Do Until Loops	00:09:00
	Lesson 6-Working with Do While Loops	00:05:00
Section 06
	Lesson 1-Calling Sub Procedures	00:05:00
	Lesson 2-Working with Exit Sub	00:04:00
	Lesson 3-Working with Message Boxes	00:08:00
	Lesson 4-Working with Input Boxes	00:08:00
	Lesson 5-Working with VBA Functions	00:12:00
	Lesson 6-Working with Object Variable and Set	00:06:00
Section 07
	Lesson 1-Understanding and Creating a User Form	00:08:00
	Lesson 2-Adding Controls to a User Form	00:16:00
	Lesson 3-Adding Code for a User Form	00:10:00
	Lesson 4-Launching a User Form from Excel	00:05:00
Section 08
	Lesson 1-Getting Started with Debugging	00:10:00
	Lesson 2-Stepping Through Your Code	00:06:00
	Lesson 3-Working with Breakpoints	00:03:00
	Lesson 4-Working with the Immediate Window	00:05:00
	Lesson 5-Working with the Locals Window	00:05:00
	Lesson 6-Working with the Err Object	00:06:00
	Lesson 7-Getting Help-v2	00:07:00
Course Recap
	Recap	00:02:00
Additional Materials
	Resource - Excel 365 VBA Expert	00:00:00
Final Exam
	Final Exam - Excel 365 VBA Expert	00:20:00

Course Images

Excel 365 VBA Expert

By iStudy UK

Booking options

Highlights

Description

About The Provider

Tags

Reviews