VBA Excel - Start Basic Finish Advanced!
4.0 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,917 students enrolled

VBA Excel - Start Basic Finish Advanced!

A practical guide to using VBA with Excel. With a professional practical example for you to learn from
4.0 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,917 students enrolled
Created by Craig Barry
Last updated 10/2019
English
English [Auto-generated]
Current price: $64.99 Original price: $99.99 Discount: 35% off
8 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to write VBA code
  • Build an automated charting tool using VBA forms
  • Practical real world application of VBA macro writing
  • Macro writing
  • Programming fundamentals
Requirements
  • Microsoft Excel - All versions covered
  • Willing to learn
  • Must have a working knowledge of MS Excel
Description

An introduction from the ground up of how to use VBA Excel to accelerate your workflow.  We cover the basics right through to the more advanced concepts and this is all delivered through the implementation of a real world example. 

If you want to further your career, reduce errors or simply learn a new skill this course is for you.

You don't need to worry about the version of Excel you are using, the skills taught in this course are universal.  You will need to be willing to put the effort in to learn for best results and we ask that you follow along, actually typing out the code you see in the course.

Who this course is for:
  • Students who know nothing about programming
  • Intermediate Excel users looking to expand into VBA
  • Excel users who want to speed up their workflow
  • Students with some knowledge of VBA who want to start writing more professional code
  • Students looking to add to their resume / CV
Course content
Expand all 39 lectures 03:11:23
+ Introduction
2 lectures 03:38

Get up and running quickly, before starting, follow this quick lesson on how to enable the developer tab, you will need this to continue following my other course material.

Preview 00:49

This brief lesson, talks through some of the fundamentals of app development in Excel.  'Hello World' is the rite of passage and often the first programme written in any new language being learnt. It ensures that the environment is capable of editing, generating and executing a simple piece of code.

Make sure to reproduce this at home, pause and rewind the video if you need to.

Preview 02:49

Check that you have understood the content of the lectures

Summary Quiz
1 question
+ Subs and Functions
1 lecture 11:57

Check that you understand the basics of what they are and why we use them

Functions and Subs Roundup
4 questions
+ Variables and Data Types
2 lectures 09:30
Variables and Data Types Part 1
03:56
Variables and Data Types Part 2 (advanced)
05:34

Check you understand the fundamentals.  Before we get to the good stuff.

Did you get it?
4 questions
+ Operators, Decision Making And Loops
6 lectures 25:25
Arithmetic Operators
02:32
Logical Operators
02:30
Comparison Operators
01:52
Concatenation Operators
04:13
Decision Making
05:53
Loops
08:25
+ Classes and Objects
4 lectures 18:37
Class Properties
04:37
Accessing our objects properties
07:42
Adding Min and Max Property Access
01:13
Custom Logic Within Property Access
05:05

Check you have understood the content of these lectures

Summary Quiz
6 questions
+ Debugging And Testing Our Code
2 lectures 07:37
Calling the Code Under Test
05:33
Debugging Continued
02:04
+ Storing Data
4 lectures 24:56
Creating a collection
04:49
Using a collection
08:59
Excel Inbuilt Collections
02:47
Collection of Custom Objects
08:21
+ Building our Plotter App
17 lectures 01:23:54
Create The Bare UI
04:28
Write Some Launch Code
01:22
Define The 'Channel' Class
06:38
Add Channels to The Picker
08:29
Selecting Channels To Plot
05:20
Managing Collections of Channels
04:44
Scraping Data from the Worksheet
02:22
Working With Chart Object
03:06
Debugging the Code - Important Add Option Explicit
03:05
Defining the Plot Range
08:11
Using the inbuilt Macro Recorder
10:07
Debugging, Reproducing and Fixing the All Series Plot Issue
10:19
Moving the Plotted Chart into a New Workbook
03:59
Rename a Sheet
01:59
Creating a Button To Run Our Code
02:05
Set X and Y Titles Then Hide / Close The UI
05:17
Unloading vs Hiding User Forms
02:23