The Excel VBA Handbook Course

by Paul Kelly | May 31, 2022

Course Content

Expand All

Your VBA Handbook Bonuses

Getting Started 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Welcome to the Excel VBA Handbook Course

3 Useful Tips for Viewing the Course

7 Essential VBA Tips – Video

Application 1 – Reading Data 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Notes on Using OneDrive

01 Application Overview

Application 1 Downloads

02 Create a Simple Framework

03 Opening the workbook to read data

04 Reading the Data from the range

05 Writing the data to the worksheet

Application 1 Video Workshop

Application 2 – Building a Table of World Cup Results 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Application 2 Overview

Application 2 Downloads

01 Setting up and Clearing Data

02 Using the VBA Dictionary

03 Adding the functions and subs

04 Reading the Data

05 Check if the team already exists in the Dictionary

06 Create the Framework for the report

Application 2 Video Workshop

Application 3 – Sending Emails with Attachments 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Application 3 Overview

Application 3 Downloads

01 Break the application into tasks

02 Reading the recipients from the worksheet

03 Creating the Attachment

04 Connecting to Microsoft Outlook

05 Creating and Sending the Email

Application 3 Video Workshop

Application 4 – Creating a Worksheet Table of Countries 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Application 4 Overview

Application 4 Downloads

01 Getting started with Tables

02 Copying the Data

03 Add the Worksheet_Change event

04 Filter the Table Data

05 Inserting the Columns

Application 4 Video Workshop

Application 5 – Building a Historical Currency Chart 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Application 5 Overview

Application 5 Downloads

01 Creating the Main Sub

02 Accepting the User Selections

03 Reading the Data

04 Creating the Chart

Application 5 Video Workshop

Application 6 – Reading and Writing to an Access Database 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Application 6 Overview

Application 6 Downloads

01 Reading from the Database

02 Creating the Query

03 Using a RecordSet

04 Writing to the Database

Application 6 Video Workshop

Application 7 – Creating a Financial Report 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Application 7 Overview

Application 7 Downloads

01 Setting up the main tasks

02 Creating the report Workbook

03 Adding Conditional Formatting

04 Reading and Writing the Data

Application 7 Video Workshop

Application 8 – Creating a Pivot Table of data 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Application 8 Overview

Application 8 Downloads

01 Setting up the main tasks

02 Creating the Pivot Table

03 Swapping Rows and Columns

Application 8 Video Workshop

Application 9 – Reading and Writing to Text Files 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Application 9 Overview

Application 9 Downloads

01 Setting up the Application

02 Resetting the File

03 Reading from text files

04 Storing the customer record

05 Writing to the Worksheet

Application 9 Video Workshop