0

Excel VBA The VBA Beginner's Blueprint to Programming Excel

Course Details
Trainer Name

Isabel

Skill Area

Reviews

4 (2 Rating)

Course Requirements

To get the most out of this course, you should have working knowledge of Microsoft Excel.
Excel 2010, 2013, 2016, 2019, 365

Course Description

Even with all of Excel's great features, and built-in tools, you might find yourself doing repetitive tasks, that take longer than they should.
Or the day will come when you say, "Oh, I wish there were a better way to do this!"
The good news is that Excel, and other Microsoft Office applications, comes with Visual Basic for Applications (VBA), a programming language that will extend the functionality of your Office applications.

In This Course You Get:
Free Downloadable Workbooks - makes it easy to follow along & practice after class.
Test Your Skills - exercises to get you engaged & reinforce what you have learned.
Code Snippets - with common code bites.
VBA Glossary - talk the talk

Course Outcomes


1.Enroll in this course to automate, and customize your Excel 2007, 2010, 2013, 2016, 2019, or 365 files with hours of Video Lectures, 40+ Articles, and 90+ Supplemental Resources.
2.UNDERSTAND why you would want to use VBA in Excel
3.KNOW the difference between Macros and VBA
4.CREATE Macros in Excel
5.MODIFY your Macros
6.NAVIGATE comfortably in the Visual Basic Editor
7.LEARN the essentials of writing Excel VBA code
8.MODIFY your Workbooks using VBA
9.CREATE Decision Structures in your VBA code
10.LOOP your VBA code to have it run more than once
11.CREATE user interaction dialog boxes, like Message Boxes, and Input Boxes
12.CREATE User Forms from scratch
13.DEBUG your VBA code
14.LEARN how to handle errors
15.CREATE New Worksheet Functions

Course Curriculum

1 Introduction

1 Writing Code vs Recording Macros

2 Understanding Objects

3 Containers Collections

4 How VBA Refers to Objects

1 Recording Macros

2 Testing the Macro and Looking at the VBA

3 Absolute vs. Relative Mode

4 Recording in Relative Mode

5 Modifying Macros Using VBA

6 Macro Example Creating Buttons to Navigate Between Worksheets

1 The Microsoft Visual Basic Editor

2 The Project Explorer

3 The Properties Window

4 The Code Window

5 Other Windows the Immediate Window, the Locals Window, and the Watch Window

6 Adding and Removing Modules

7 Naming Modules

8 Customizing the Visual Basic Environment

1 Introduction to Writing VBA

2 A Few Time Savers Writing VBA

3 Resetting Your VBA Code Upon Errors

4 Structure of Sub Procedures

5 Calling a Sub Procedure

6 Structure of Functions

7 Calling a Function

8 Comments

9 Using Objects

10 Using Methods

11 Using Event Procedures UPDATED

1 Variables

2 Object Variables

3 Data Types

4 Declaring Constants

5 Carriage Return Line Feed

6 Scope

1 Creating a New Workbook

2 Opening and Closing Workbooks

3 Worksheets vs Sheets

4 Adding Worksheets

5 Copying Worksheets

6 The Cells Object

7 Exercise Using Operators and the Cells Object

8 ActiveCell

9 Rows and Columns

10 The Range Object

11 Referring to Named Ranges

12 The CurrentRegion Property

13 The Range.End Property

14 Copying Data on Your Worksheet

15 The Paste Method

16 Using PasteSpecial

17 Clearing Contents and Formats

18 Exercise Using Name, and Value

19 Sorting Fields

20 Filtering Fields

21 Removing Duplicate Records

1 The Format Function Using Named Format Expressions

2 Using the FormatCurrency Function

1 Introduction to Loops

2 For Next Loop

3 Exercise For Next Loop

4 Stepping

5 For Each

6 Exercise For Each, Example 1

7 Exercise For Each, Example 2

8 Exiting a For Loop

9 Do Until Loop

10 Exercise Do Until Loops

11 Do While Loop

12 Exercise Do While Loop

13 Exiting a Do Loop

1 Introduction to User Forms

2 Creating a Form

3 Showing a Form from the VBE

1 Working with Message Boxes

2 Exercise Message Boxes

3 Working with Input Boxes

4 Exercise Input Boxes

5 Adding Controls to a Form

6 Attaching Events to Form Controls

7 Validating Form Data

8 Exercise Dependent Combo Boxes

9 Test Your Skills

1 Creating Functions for Your Worksheets

2 Creating a Simple Chart with VBA

3 Using WorksheetFunction to Perform Calculations

4 Using Static Arrays

5 The Array Function

6 Using VBA to E-mail Workbooks

7 Deleting Blank Rows and Columns

8 Using GoTo to Create Branching Logic in Your VBA Code

1 Thank You!

1 Introduction to Decision Structures

2 If & Then

3 If, Then & Else

4 Select Case

1 Introduction to Debugging and Error Handling

2 Debugging Setting a Breakpoint

3 Debugging The Watch Window

4 Debugging Stepping Through VBA Code

5 Debugging The Immediate Window

6 Debugging The Locals Window

7 Error Handling The On Error GoTo Statement

8 Error Handling The On Error Resume Next Statement

9 Error Handling The Err Object

Trainer

Trainer Name

Isabel

4 Rating
2 Reviews

More Courses by Author

Learner Feedback

Excel VBA The VBA Beginner's Blueprint to Programming Excel

4

Course Rating
50.00%
0.00%
50.00%
0.00%
0.00%

Log In or Sign Up as learner to post a review

Course you might like

Free

Beginners Excel VBA
0/5
62 Lessons 136 Enrolment
Free

Zero Microsoft Excel Complete 2020
5/5
34 Lessons 2465 Enrolment

Free

Enrol Now

This course includes:

  • Duration: 7 Hours 4 Min

  • Skill Level: Beginner

  • Lectures: 106 lessons

  • Enrolled: 89 learners

  • Certificate of Completion

  • Lifetime access

Shopping Cart

Loading...
View cart Checkout