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 - Intermediate Level

Excel Visual Basic Applications - Intermediate Level

This course is a comprehensive overview of what effective business analysts really do - their strategies, techniques, tools, and methods – all of which apply to any process whether it’s a traditional large project, an Agile or DevOps project.

John Bura
John Bura
Business | core | 4 hours |   Published: Jan 2021
In partnership with:  Coursera

    Discussions

Overview

1.3KSTUDENTS*
92.6%RECOMMEND*

This course includes:

  • 4+ 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
Once you have completed our course on "Excel Visual Basic Applications for Beginners," you are ready for this higher level program which covers many of the intermediate and advanced functions you can write with in Visual Basic within Excel.

Skills You Will Gain

Building arrays
Excel
VBA Loops
VBA Patterns
vba projects
VBA strings
Visual basic

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

Frequently Asked Questions

How much do the courses at Starweaver cost?

We offer flexible payment options to make learning accessible for everyone. With our Pay-As-You-Go plan, you can pay for each course individually. Alternatively, our Subscription-Based plan provides you with unlimited access to all courses for a monthly or yearly fee.

Do you offer any certifications upon completion of a course at Starweaver?

Yes, we do offer a certification upon completion of our course to showcase your newly acquired skills and expertise.

Does Starweaver offer any free courses or trials?

No, we don't offer any free courses, but we do offer 5-day trial only on our subscriptions-based plans.

Are Starweaver's courses designed for beginners or advanced students?

Our course is designed with three levels to cater to your learning needs - Core, Intermediate, and Advanced. You can choose the level that best suits your knowledge and skillset to enhance your learning experience.

What payment options are available for Starweaver courses?

We accept various payment methods such as major credit cards, PayPal, wire transfer, and company purchase orders. For more information related to payments contact customer support.

Do you offer refunds?

Yes, we do offer a 100% refund guarantee for our courses within a specified time frame. If you are not satisfied with the course, contact our customer support team to request a refund with your order details. Some restrictions may apply.

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.
1Welcome to the course!
2Module 01: Introduction to Intermediate Level
3Module 02: Introduction to Loops
4Module 03: Loop Projects
5Module 04: String Manipulation
6Module 05: Build Custom Functions
7Module 06: Build Arrays
8Module 07: Work with Dates
9Module 08: Application Object
10Module 09: VBA Projects
11Module 10: Programming Charts
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

Segment - 01 - Course Overview

Instructor bio - John Bura

Segment - 02 - Topics Overview

Segment - 03 - Single Loop

Segment - 04 - Double Loop

Segment - 05 - Triple Loop

Segment - 06 - Do While Loop

Segment - 07 - Build a Commission Table

Source File

Segment - 31 - Topics Overview

Segment - 32 - One Dimensional Array

Segment - 33 - Two Dimensional Array

Segment - 34 - Change Array Size

Segment - 35 - Build an Array

Segment - 36 - Populate Row with Array

Segment - 37 - Array Length

Segment - 38 - Split String Into an Array

Segment - 39 - Join Array Into a String

Source File

Segment - 08 - Topics Overview

Segment - 09 - Loop Through Defined Range

Segment - 10 - Loop Through Entire Column

Segment - 11 - Do Until Loop

Segment - 12 - Use Step to Increment

Segment - 13 - Build a Pattern Project

Segment - 14 - How to Sort

Segment - 15 - Sort by Related Data

Segment - 16 - Delete Duplicate Values

Source File

Segment - 51 - Topics Overview

Segment - 52 - Build a Table

Segment - 53 - Build a Table of Contents

Segment - 54 - Build a Table of Contents 2

Segment - 55 - Combine Worksheets

Segment - 56 - Combine Worksheets by Column

Source File

Segment - 27 - Topics Overview

Segment - 28 - Make and Use Your Own Function

Segment - 29 - Pass Arguments to a Function

Segment - 30 - Custom Calculator Function

Source File

Segment - 17 - Topics Overview

Segment - 18 - Join Strings

Segment - 19 - Extract Substrings from Left or Right

Segment - 20 - Extract Substring at Middle

Segment - 21 - Get Length of a String

Segment - 22 - Get Substring Position

Segment - 23 - How to Split Strings

Segment - 24 - Reverse Characters

Segment - 25 - Change String Casing

Segment - 26 - Count Words in a Range

Source File

Segment - 40 - Topics Overview

Segment - 41 - Delay a Procedure

Segment - 42 - Schedule a Procedure

Segment - 43 - Count Years

Segment - 44 - Count Days between Dates

Segment - 45 - Count Weekdays between Dates

Segment - 46 - Sort Dates

Source File

Segment - 47 - Topics Overview

Segment - 48 - How to Access Excel Functions

Segment - 49 - Disable Screen Updating

Segment - 50 - Write Data to a File

Source File

Segment - 57 - Topics Overview

Segment - 58 - Program a Chart

Segment - 59 - Program an Embedded Chart

Segment - 60 - Delete Charts Programmatically

Source File