Introduction To Microsoft Excel Vba

Learn Microsoft Excel VBA Fundamentals (Excel 2010, 2013, 2016)

What you'll learn

Fundamental Building Blocks of Using Excel VBA to Automate Routine Tasks

How to Implement Excel VBA into an Excel Workbook

Become Familiar with Common Excel VBA Programming Syntax

Work with VBA Variables, Conditional Statements, and Loops

Learn the Differences Between Absolute and Relative References to Create Dynamic Code

Debug Code Effectively

Interact with and Receive Input from Users

Learn Microsoft Excels VBA Object Structure

Requirements

Microsoft Excel Installed

No Prior VBA Programming Experience Needed

Knowledge of working with Microsoft Excel Worksheets

Description

Microsoft Excel VBA (Visual Basic for Applications) provides Excel users with the ability to automate any Excel task. Excel Tasks that would normally take an extensive amount of work and time to complete can ultimately be automated and completed in a single click of a button. All that's needed to automate your experience is a little Excel VBA knowledge.
Maybe you've heard of Excel Macros and VBA. Or, maybe you've even attempted to create your own. Jumping into VBA can be a bit daunting and overwhelming. I've been teaching Excel for 15+ years and have had loads of questions from those that have taken the dive into learning Excel VBA. Where should I start? What do I need to know? What's a variable? Enroll in this course and I'll share the knowledge and experience I've gained working with Excel VBA.
WHAT YOU'LL LEARN
Fundamentals of Excel VBAProper Syntax Writing VBA CodeExcel Object Structure to Effectively Communicate with ExcelWorking with the Most Common VBA Objects in ExcelAutomate Routine Microsoft Excel TasksAnd More….
EXERCISE FILES AND QA
As you go through the video lectures you can download the exercise files, found within each section. Use the exercise files to practice the concepts you will be learning.
The course contains a QA section where you can interact with me and ask any questions as you develop your VBA skills.
ENROLL NOW
As you participate in this introductory Excel VBA course you will build the knowledge and confidence to automate your experience in Excel, saving you time and money.

Overview

Section 1: Course Introduction

Lecture 1 Welcome to the Course

Lecture 2 Course Exercise Files

Section 2: Microsoft Excel VBA 101

Lecture 3 What is VBA?

Lecture 4 Microsoft Excel Object Structure

Lecture 5 Activate the Excel Developer Tab

Lecture 6 Intro to the VBA Window

Lecture 7 Using the Excel VBA Immediate Window to Reference Object

Lecture 8 Shorthand Object References

Lecture 9 Introduction to Properties and Methods of Excel Objects

Lecture 10 Excel VBA 101 Reference Sheet

Section 3: Working with Excel's Worksheets Object

Lecture 11 How to Reference an Excel Worksheet

Lecture 12 Working with the Select Method

Lecture 13 Changing the Name of a Worksheet

Lecture 14 Getting the Number of Worksheets Using the Count Property

Lecture 15 Creating New Worksheets Using the Add Method

Lecture 16 Printing Worksheets Using the PrintPreview Method

Lecture 17 Deleting Worksheets in VBA

Lecture 18 Excel's Worksheets Object Reference Sheet

Section 4: Working with Excel's Range Object

Lecture 19 How to Reference a Range

Lecture 20 Selecting a Range with an Absolute Reference

Lecture 21 Changing the Value of a Cell Using the Value Property

Lecture 22 Using the Copy and Paste Methods

Lecture 23 Reference a Cell on Another Worksheet

Lecture 24 Excel's Range Object Reference Sheet

Section 5: Using Relative References in VBA

Lecture 25 Understanding the Difference between Absolute and Relative References

Lecture 26 Using the ActiveSheet Object

Lecture 27 Using the ActiveCell Object

Lecture 28 Selecting an Unknown Range Using the CurrentRegion Property

Lecture 29 Using the Offset() Command to Select a Range

Section 6: Microsoft Excel VBA Modules and Sub Procedures

Lecture 30 What is a Module?

Lecture 31 Creating a Sub Procedure

Lecture 32 Adding Code to the Procedure

Lecture 33 Running a Sub Procedure

Lecture 34 Creating a Button to Run a Sub Procedure

Lecture 35 Calling a Procedure from another Procedure

Lecture 36 Adding Comments to VBA Code

Lecture 37 Saving an Excel File that contains VBA Code

Section 7: The World of VBA Variables

Lecture 38 Understanding the Purpose of a Variable

Lecture 39 Declaring Variables in VBA

Lecture 40 Giving Variables a Value

Lecture 41 Common Variable Types

Lecture 42 Using a String Variable

Lecture 43 Using an Integer Variable

Lecture 44 Using a Boolean Variable

Section 8: Excel VBA Control Structures and Loop

Lecture 45 Introducing Logic into a Procedure Using the IF Statement

Lecture 46 Using the ElseIf and Else Statements

Lecture 47 Understanding the Purpose of a Loop

Lecture 48 VBA Do While Loop

Lecture 49 VBA For Each… Next Loop

Section 9: Interacting with the User

Lecture 50 Displaying a Prompt Using the MsgBox Function

Lecture 51 Adding Buttons to the MsgBox

Lecture 52 How to Handle Button Presses

Lecture 53 Receive User Input Using an InputBox Method

Section 10: Congratulations!

Lecture 54 You've Completed the Course

Students New to Excel VBA,Students Looking to Expand their Microsoft Excel Knowledge