starweaver-logo
LOG INGET STARTED
LOG INGET STARTED
  • Browse
  • Doing

  • On Air
  • Channels
  • Career Paths
  • LEARNING

  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • CONNECTING

  • How It Works
  • Community
  • Techbytes
  • Podcasts
  • Leaderboards
  • SUPPORT

  • Support & FAQs
  • Starweaver for Business
  • Starweaver for Campus
  • Teach with Starweaver
footer-brand-logo
  • COMPANY
  • About Us
  • Support and Knowledge Base
  • Policies & Terms
  • Contact
  • CONTENT
  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • Meet the Gurus
  • Techbytes
  • FOR ORGANIZATIONS
  • Starweaver for Business
  • Starweaver for Campus
  • Catalogue
  • Pricing
  • Private Classes
  • PARTNER WITH US
  • Instructors & Teachers
  • Books, Writing & Publishing
  • FOLLOW US
    • facebook
    • twitter
    • linkedin
    • pinterest
    • instagram
    • youtube
Our trademarks include Starweaver®, Make genius happen™, Education you can bank on®, People are your most important assets!®, Body of Knowledge™, StarLabs™, LiveLabs™, Journeys™
© Starweaver Group, Inc. All Rights Reserved.
  1. Courses
  2. >
  3. Excel Visual Basic Applications for Beginners

Excel Visual Basic Applications for Beginners

This course is an introduction to Excel Visual Basic Applications or VBA. It introduces you to how VBA and you can use the Visual Basic Editor to create procedures (referred to as a macro) with VBA code that accomplishes a task. The macros you will

John Bura
John Bura
Business | core | 5 hours |   Published: Jan 2021

    Discussions

Overview

1.5KSTUDENTS*
92.4%RECOMMEND*

This course includes:

  • 5+ hours of on-demand video
  • 10 modules
  • Core level
  • Direct access/chat with the instructor
  • 100% self-paced online
  • Many downloadable resources
  • Shareable certificate of completion
This course is a introduction to Excel Visual Basic Applications, or VBA. It introduces you how VBA and you can use the Visual Basic Editor to create procedures (referred to as a macros) with VBA code that accomplishes a task. The macros you will learn to write include "Functions" and "Subroutines."

Skills You Will Gain

Introduction to vba
Range properties
VBA for beginners
Worksheet objects

Learning Outcomes (At The End Of This Program, You Will Be Able To...)

Prerequisites

None other than a basic understanding of computers

Who Should Attend

Anyone interested in learning the core features and functions of Excel, and applying these skills in practical settings.

Curriculum

Instructors

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.
John Bura

John Bura

John Bura is a seasoned game developer, eLearning innovator, and AI coach with over 15 years of experience in the tech industry. Based in Vancouver, Canada, he serves as the CEO of Mammoth Interactive, where he leads the development of top-ranking games and applications across multiple platforms. His leadership also extends to Devonian Apps, a SaaS company known for delivering high-quality, fast-to-market digital products.

John is deeply passionate about education through technology. As a celebrated Udemy instructor, he has empowered over 300,000 students worldwide through practical courses on HTML5, Xcode, and game design, with his teaching style widely recognized for its clarity and real-world applicability. His dedication to curriculum excellence was further reflected in his role as a Program Advisor at Centennial College, where he shaped game design education to match industry demands.

With a rich background in both creative and technical disciplines, John has had his work featured by major industry players like Nickelodeon. As a forward-thinking AI expert, he now coaches businesses on building intelligent, automated infrastructures to increase efficiency and scalability. He's currently developing a cutting-edge tool that automates podcast and video production for content creators, furthering his mission to make innovation accessible.

Whether building games, coaching teams, or designing AI-powered tools, John blends creativity with technical mastery to drive productivity, foster innovation, and inspire learners around the world.

VIEW MY CHANNEL
1Welcome to the course!
2Module 01: Course Introduction
3Module 02: Send Messages with MsgBox
4Module 03: Workbook and Worksheet Objects
5Module 04: Work with the Range Object
6Module 05: Work with Range Properties
7Module 06: More Range Projects
8Module 07: Variables
9Module 08: Work with Conditionals
10Module 09
11Module 10

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 01 - Course Overview

Segment - 02 - How to Save Macros

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Instructor bio - John Bura

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 03 - Topics Overview

Segment - 04 - Build a Simple Message

Segment - 05 - Build an Advanced Message

Segment - 06 - Empty a Sheet with the MsgBox Function

Segment - 07 - Prompt User for Input

123

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 08 - Topics Overview

Segment - 09 - Object Hierarchy

Segment - 10 - Change Multiple Worksheets

Segment - 11 - Add and Count Worksheets

Segment - 12 - Get Path of a Workbook

Segment - 13 - Open and Close Workbooks

Segment - 14 - Loop Through Worksheets and Workbooks

Segment - 15 - Build a Sales Calculator

Segment - 16 - Change Charts

Resources

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 17 - Topics Overview

Segment - 18 - Program a Range of a Spreadsheet

Segment - 19 - Use Cells instead of a Range

Segment - 20 - Use a Range Variable

Segment - 21 - Select a Range

Segment - 22 - Access a Row

Segment - 23 - Copy and Paste a Range

Segment - 24 - Clear a Range

Segment - 25 - Count a Range

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 26 - Topics Overview

Segment - 27 - Find the current region of a cell

Segment - 28 - Dynamic Range Program

Segment - 29 - Resize a Range

Segment - 30 - Select Entire Rows and Columns

Segment - 31 - Offset Property

Segment - 32 - End Property

123

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 33 - Topics Overview

Segment - 34 - Union and Intersect of Ranges

Segment - 35 - Detect Content

Segment - 36 - Build a Range Program

Segment - 37 - Change Text Color

Segment - 38 - Bold a Range

Segment - 39 - Change Cell Color

Segment - 40 - Work with Areas

Segment - 41 - Find Differences in Ranges

123

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 48 - Conditionals

Segment - 49 - If then Statement

Segment - 50 - Else Statement

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment -42 - Topics Overview

Segment - 43 - Integer Data Type

Segment - 44 - String Data Type

Segment - 45 - Double Data Type

Segment - 46 - Boolean Data Type

Segment - 47 - Retain Variable Value

Source File

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 51 - Topics Overview

Segment - 52 - Greeting Program Logical Operator and

Segment - 53 - Logical Operator or

Segment - 54 - Logical Operator not

123

You need to enroll in this course to access the curriculum. Click 'Enroll' to get started!

Segment - 55 - Topics Overview

Segment - 56 - Select Case

Segment - 57 - Build a Commission Calculator Project

Segment - 58 - Find Remainder with Mod

Segment - 59 - Check Number Program

123