Project Based Excel VBA Course

Name: Project Based Excel VBA Course
Rating: 4.5 (207 reviews)

Become an Excel Programmer, fueled by plenty of practice

Created byBrandon Brown

Last updated 11/2020

English

What you'll learn

Lectures will quickly cover the important concepts, giving you time to focus on the project and exercises
As you progress through the course you will code an entire game of Battleship
Learn to create elegant forms, read and write text files, and much more to become the star of your office!

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

10 sections • 54 lectures • 10h 46m total length

Introduction1:21

★★★★ Developer Tab3:17
☆☆☆☆☆ VBA Editor6:36
★★★★ Dot Notation5:51
☆☆☆☆☆ Ranges and Cells (Part 1)9:53
☆☆☆☆☆ Ranges and Cells (Part 2) - Other Range Properties16:54
At least watch the Offset property, that one is a must know!
☆☆☆☆☆ Debugging7:51
★★★ Extra Functions9:34
Exercise 1 - Boat Stuff9:10
Exercise 2 - Debugging5:16
Course Project Introduction - Battleship!15:46
Project Step 110:24

☆☆☆☆☆ Loops (Part 1 - FOR and FOR EACH)19:57
★★★★ Loops (Part 2 - DO LOOP)16:52
☆☆☆☆☆ Arrays (Part 1 - Static and Dynamic Arrays)14:41
★★★ Arrays (Part 2 - ARRAY() and Multidimensional Arrays)15:49
Exercise - Adding headers into a list10:45
Project Step 3.1 - NewGame3:24
Project Step 3.2 - StartGame Overview and PopulateLog Solution12:41
Project Step 3.3 - FindBoats Solution28:52
Project Step 3.4 - FormatBoats Solution7:06
RESOURCES - Project Step 3 Solution0:03

☆☆☆☆☆ Subs (Part 1 - Calling Subs)10:57
☆☆☆☆☆ Subs (Part 2 - Passing Parameters)9:47
★★★ Functions8:12
Exercise - Medical form14:52
Project Step 4.1 - StartGame Edits19:09
Project Step 4.2 - FireShot Overview5:38
Project Step 4.3 - FindTarget Solution39:55
Project Step 4.4 - FireShot, HitMessage, DoTurn Solution26:37
Project Step 4.5 - Adding Buttons9:09
RESOURCES - Project Step 4 Solution0:03

Requirements

Microsoft Excel

Description

Learn how to automate tasks in the world's most popular business tool, Microsoft Excel. This course only requires access to Excel, and it will teach you the core concepts to launch your programming career.

Some highlights of this course:

A step-by-step guide in making a comprehensive game of Battleship.
Several hours of high quality video lectures, covering topics such as variables, loops, and text files.
Exercises at the end of every section, and extra projects at the end of the course.

Who this course is for:

Beginner Excel VBA Users
Intermediate Excel VBA Users
Advanced Excel Users

Project Based Excel VBA Course

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction1 lecture • 1min

Ranges and Cells11 lectures • 1hr 41min

Variables and IF THEN4 lectures • 1hr 7min

Text Manipulation3 lectures • 54min

Loops and Arrays10 lectures • 2hr 10min

Subs and Functions10 lectures • 2hr 24min

Files5 lectures • 1hr 18min

Forms4 lectures • 1hr 9min

Outro1 lecture • 1min

Supplemental Projects5 lectures • 1min

Requirements

Description

Who this course is for: