Project Based Excel VBA Course

Project Based Excel VBA Course, available at $69.99, has an average rating of 4.2, with 54 lectures, 1 quizzes, based on 199 reviews, and has 11734 subscribers.

You will learn about 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! This course is ideal for individuals who are Beginner Excel VBA Users or Intermediate Excel VBA Users or Advanced Excel Users It is particularly useful for Beginner Excel VBA Users or Intermediate Excel VBA Users or Advanced Excel Users.

Enroll now: Project Based Excel VBA Course

Summary

Title: Project Based Excel VBA Course

Price: $69.99

Average Rating: 4.2

Number of Lectures: 54

Number of Quizzes: 1

Number of Published Lectures: 54

Number of Published Quizzes: 1

Number of Curriculum Items: 55

Number of Published Curriculum Objects: 55

Original Price: $119.99

Quality Status: approved

Status: Live

What You Will 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!

Who Should Attend

Beginner Excel VBA Users

Intermediate Excel VBA Users

Advanced Excel Users

Target Audiences

Beginner Excel VBA Users

Intermediate Excel VBA Users

Advanced Excel Users

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Ranges and Cells

Lecture 1: ★★★★ Developer Tab

Lecture 2: ☆☆☆☆☆ VBA Editor

Lecture 3: ★★★★ Dot Notation

Lecture 4: ☆☆☆☆☆ Ranges and Cells (Part 1)

Lecture 5: ☆☆☆☆☆ Ranges and Cells (Part 2) – Other Range Properties

Lecture 6: ☆☆☆☆☆ Debugging

Lecture 7: ★★★ Extra Functions

Lecture 8: Exercise 1 – Boat Stuff

Lecture 9: Exercise 2 – Debugging

Lecture 10: Course Project Introduction – Battleship!

Lecture 11: Project Step 1

Chapter 3: Variables and IF THEN

Lecture 1: ☆☆☆☆☆ Variables

Lecture 2: ☆☆☆☆☆ IF THEN

Lecture 3: Exercise – More Boat Stuff

Lecture 4: Project Step 2

Chapter 4: Text Manipulation

Lecture 1: ★★★★ Strings (Part 1)

Lecture 2: ★★★★ Strings (Part 2)

Lecture 3: Exercise – Job Application

Chapter 5: Loops and Arrays

Lecture 1: ☆☆☆☆☆ Loops (Part 1 – FOR and FOR EACH)

Lecture 2: ★★★★ Loops (Part 2 – DO LOOP)

Lecture 3: ☆☆☆☆☆ Arrays (Part 1 – Static and Dynamic Arrays)

Lecture 4: ★★★ Arrays (Part 2 – ARRAY() and Multidimensional Arrays)

Lecture 5: Exercise – Adding headers into a list

Lecture 6: Project Step 3.1 – NewGame

Lecture 7: Project Step 3.2 – StartGame Overview and PopulateLog Solution

Lecture 8: Project Step 3.3 – FindBoats Solution

Lecture 9: Project Step 3.4 – FormatBoats Solution

Lecture 10: RESOURCES – Project Step 3 Solution

Chapter 6: Subs and Functions

Lecture 1: ☆☆☆☆☆ Subs (Part 1 – Calling Subs)

Lecture 2: ☆☆☆☆☆ Subs (Part 2 – Passing Parameters)

Lecture 3: ★★★ Functions

Lecture 4: Exercise – Medical form

Lecture 5: Project Step 4.1 – StartGame Edits

Lecture 6: Project Step 4.2 – FireShot Overview

Lecture 7: Project Step 4.3 – FindTarget Solution

Lecture 8: Project Step 4.4 – FireShot, HitMessage, DoTurn Solution

Lecture 9: Project Step 4.5 – Adding Buttons

Lecture 10: RESOURCES – Project Step 4 Solution

Chapter 7: Files

Lecture 1: ★★★ Excel Files

Lecture 2: ★★★ Text/CSV Files (Part 1 – Reading)

Lecture 3: ★★★ Text/CSV Files (Part 2 – Writing)

Lecture 4: Exercise – Listing Files

Lecture 5: Project Step 5

Chapter 8: Forms

Lecture 1: ★★★ User Interface Forms

Lecture 2: ★★★ Progress Bars

Lecture 3: Exercise – Password

Lecture 4: Project Step 6 (Finale)

Chapter 9: Outro

Lecture 1: Final Thoughts

Chapter 10: Supplemental Projects

Lecture 1: Battleship! (Unstructured version of Course Project)

Lecture 2: NCAA March Madness Bracket

Lecture 3: Task List Companies

Lecture 4: Companies in a Cell

Lecture 5: PDF Renamer

Instructors

Brandon Brown
Programmer

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 13 votes

4 stars: 75 votes

5 stars: 109 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!