Microsoft Excel Essentials: Level 3 - VBA Programming - Unleash The Full Power Of Excel With VBA

Alan Jarvis, Everything Is Easy, Once You Know How

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
171 Videos (13h 25m)
    • Level 3 Promo

      1:59
    • 0 - Why Should I Learn How To Code

      10:28
    • 0 - The 15 Golden Rules Of Coding

      6:24
    • 1 - Introducing The Visual Basic Editor, & Recording Our First Macro

      11:10
    • 1 - Saving Macro enabled Workbooks, And Security Settings

      3:16
    • 1 - Moving Code Around

      4:38
    • 1 - Stepping Out. Well, In Actually - Debugging Made Easy

      5:50
    • 1 - With And End With

      12:34
    • 1 - Streamlining You Code, Or, Get Rid Of What You Don't Need

      7:53
    • 1 - Combining Your Code

      6:17
    • 1 - A Little Privacy Please

      3:18
    • 1 - Keyboard Shortcuts, And Why I Don't Use Them

      2:03
    • 1 - Why You Can't Get By With Just Recording Macros

      10:52
    • 2 - Introduction To The Coding Section

      5:35
    • 2 - Getting All The Code For This Section

      6:15
    • 2 - Changing Your VBE Settings

      2:47
    • 2 - Protecting Your Code

      2:10
    • 2 - Objects, Methods And Properties (New)

      6:27
    • 2 - Understanding The Hierarchy

      3:36
    • 2 - The Range Object

      3:03
    • 2 - The Cells Object

      2:42
    • 2 - The Activecell Property

      2:15
    • 2 - The Offset Property

      2:18
    • 2 - The End Property

      2:49
    • 2 - Dynamic Range Selection

      2:33
    • 2 - The CurrentRegion Property

      2:05
    • 2 - ACTIVATE vs SELECT

      1:43
    • 2 - Between The Sheets

      2:40
    • 2 - Calling A Sheet By Its VB Name

      2:54
    • 2 - Sheets Vs Worksheets

      2:02
    • 2 - Getting Around The Workbooks

      3:10
    • 2 - The Value Property - Writing Data

      5:26
    • 2 - The Value Property - Reading And Writing Data

      2:35
    • 2 - Copy and Paste

      2:58
    • 2 - Commonly Used Properties

      2:52
    • 2 - Coding Exercise - The Rainbow

      2:20
    • 2 - The Address Property

      4:04
    • 2 - The Row and Column Properties

      1:34
    • 2 - Capturing The Column Letter

      2:01
    • 2 - More Useful Properties

      3:05
    • 2 - Even More Useful Properties

      2:55
    • 2 - Opening Another Workbook Programmatically

      6:20
    • 2 - Closing Workbooks Programmatically

      3:41
    • 2 - Coding Exercise - Open Write Close

      3:41
    • 3 - Intro To Programmers Toolbox

      0:50
    • 3 - Variables - Local Variables

      6:46
    • 3 - Variables - Local Variables With A Twist

      3:40
    • 3 - Variables - Module Level Variables

      3:43
    • 3 - Variables - Project Level Variables

      3:02
    • 3 - Variables - All The Techie Bits

      9:30
    • 3 - An Introduction To Looping

      1:07
    • 3 - Looping With Do Loop

      5:01
    • 3 - Looping With For Next

      2:33
    • 3 - Looping With A Stepped For Next

      2:02
    • 3 - Looping With While Wend

      7:10
    • 3 - An Introduction To Logical Testing

      1:41
    • 3 - Logical Testing - A Simple If Test

      6:43
    • 3 - Logical Testing - A Simple If Test Using Cells

      5:12
    • 3 - Logical Testing - If Then Else

      3:17
    • 3 - Logical Testing - If Then Else Using Cells

      3:41
    • 3 - Logical Testing - Testing Multiple Criteria

      3:33
    • 3 - Logical Testing - Testing If One Is True, And One Is False

      2:19
    • 3 - Logical Testing - Testing If Either Value Is True

      3:21
    • 3 - Logical Testing - Select Case

      6:16
    • 3 - Maths - Doing Simple Maths In Code

      2:42
    • 3 - Maths - Writing Formulas To Single Cells

      6:56
    • 3 - Maths - Writing Formulas To Ranges Of Cells

      5:19
    • 3 - Maths - Using Excel's Built in Functions

      3:55
    • 3 - Maths - Built in Functions With Defined Ranges

      3:25
    • 3 - Getting User Input Using The InputBox Function

      5:29
    • 3 - Manipulating The User Input With Casing

      4:20
    • 3 - Getting User Input Using The InputBox Method

      5:54
    • 3 - Message Boxes - Simple Message Boxes

      4:06
    • 3 - Message Boxes - Testing Which Button Was Pressed

      4:47
    • 3 - Arrays - An Introduction

      2:37
    • 3 - Arrays - A Simple One Dimensional Static Array

      5:56
    • 3 - Arrays - A Simple One Dimensional Dynamic Array

      4:44
    • 3 - Arrays - A Simple Two Dimensional Static Array

      5:33
    • 3 - Arrays - The Most Efficient Way To Capture An Array

      4:55
    • 3 - Arrays - Extracting Useful Data Based On User Input

      7:41
    • 4 - Intro To Monthly Reporting

      2:28
    • 4 - Recording The Bones Of The Code

      4:25
    • 4 - Streamlining The Add New Sheet Code

      6:12
    • 4 - Deconstructing The Profit By Day Code

      2:09
    • 4 - Building Source Data Strings Dynamically At Runtime

      7:53
    • 4 - Creating Run Order and Data Capture Subs

      3:47
    • 4 - Solving That Naming Problem

      3:04
    • 4 - Sizing Your Charts Precisely

      3:17
    • 4 - Changing The Chart Title (And Why We Do It Separately)

      2:37
    • 4 - Deconstructing The Pivot Tables (It's Slightly Different)

      7:36
    • 4 - Titles, Money And Sorting

      4:46
    • 4 - Butchering One Table, To Create Another

      4:33
    • 4 - Adding The Commentary Building Strings Dynamically At Runtime

      7:31
    • 4 - Adding The Comentary Using Data From The Sheet We're On

      3:56
    • 4 - How DO You Make Specific Words Bold

      4:36
    • 4 - INSTR...A Very Useful Function!

      5:03
    • 4 - INSTR And Paying Attention To Detail

      2:54
    • 4 - Tidy Up The Title

      3:01
    • 4 - Easy As Pie (Chart)

      5:53
    • 4 - Pretty Up Our Pie Chart

      2:50
    • 4 - Putting It All Together

      4:50
    • 5 - Intro To Web Query section

      1:38
    • 5 - Capturing The Data For Rome

      4:18
    • 5 - Getting To Cancun And London From Rome

      5:59
    • 5 - Data Clean Up

      4:11
    • 5 - A Simple Find And Replace

      2:07
    • 5 - Getting Our Formulas Right

      3:51
    • 5 - Streamlining The Formulas Code

      4:16
    • 5 - Displaying Messages In The Status Bar (Cool)

      3:06
    • 5 - Putting It All Together

      1:55
    • 6 - Intro To The Events Section

      2:06
    • 6 - WorkBook SheetActivate

      4:09
    • 6 - WorkBook BeforePrint

      2:47
    • 6 - WorkBook SheetChange

      1:14
    • 6 - WorkBook Open - Creating An Auto Back Up

      5:17
    • 6 - WorkBook Open - Creating A Splash Screen

      3:55
    • 6 - WorkBook Open - Calling Other Code

      5:41
    • 6 - WorkBook BeforeClose

      3:09
    • 6 - WorkSheet Activate - You Can't Pick This

      1:44
    • 6 - WorkSheet Activate - You Might Pick This

      2:44
    • 6 - WorkSheet Change

      2:32
    • 6 - WorkSheet Change - A More Useful Use

      4:57
    • 6 - WorkSheet Activate - Top Secret Classified Information

      3:31
    • 6.5 - User Defined Functions

      5:39
    • 6.5 - Using A UDF To Return Information

      1:41
    • 6.5 - Creating A Countdown Timer With A UDF

      8:30
    • 6.5 - A Custom UDF For Calculating Volume Discount

      4:07
    • 6.5 - Calling A UDF From A Different Workbook

      1:47
    • 7 - Intro To Folder Creation Gizmo

      2:24
    • 7 - Creating A New Folder With A Single Line Of Code

      0:55
    • 7 - A Single Level Folder Structure

      5:27
    • 7 - Folders Within Folders

      5:36
    • 8 - Intro To The Emailing Section

      3:10
    • 8 - Understanding The eMail Routine

      4:57
    • 8 - Capturing All The Data

      10:14
    • 8 - The eMail Loop

      5:06
    • 9 - Intro To The Word Section

      0:45
    • 9 - Understanding The Word Routine

      2:17
    • 9 - Deconstructing The Gather Data Code

      3:02
    • 9 - Formula Modifications With Unique Values

      3:18
    • 9 - Efficient Sorting

      2:56
    • 9 - Building The Text And Wrap Up

      5:16
    • 10 - Intro To PowerPoint Section

      1:12
    • 10 - A Run Through The PowerPoint Base Code

      9:23
    • 10 - Setting Up The Shell Of The Code

      3:13
    • 10 - Who's Presenting This?

      2:31
    • 10 - Adding A Slide With A Logo And Text

      8:20
    • 10 - Prettying Up The Formatting (More Lego Coding!)

      2:03
    • 10 - Using Slide 1 To Create Slide 2

      4:33
    • 10 - Adding A Chart As A Picture

      6:43
    • 10 - Adding Pivot Tables (And Another Chart)

      9:12
    • 10 - Final Slide, And Wrap Up

      2:12
    • 11 - Importing Specific Data From Multiple Files - Intro

      3:26
    • 11 - Looping Through All Excel Files In A Folder

      3:56
    • 11 - The Folder Picker

      3:11
    • 11 - A More Useful Loop Through Files

      3:20
    • 11 - The Data Grabber(er)

      13:17
    • Level 3 Wrap Up

      1:02
    • SQA 01 - Get Rid Of Rows In An Array

      5:49
    • SQA 02 - Emailing Routine: Adding a Specific Attachment Based On a Criteria

      3:34
    • SQA 03 - Adding A Date Stamp, And Going To The Insertion Point AUTOMATICALLY

      7:25
    • SQA 04 - Saving An Individual Sheet To A Specific Folder

      11:42
    • SQA 05 - Saving Multiple Sheets To A Single Workbook In A Specific Folder

      27:29
    • SQA 06 - Animated Charts...With A Little Something Extra!

      6:23
    • SQA 07 - Extracting Specific Data From A Big File, To A Bunch Of Little Ones

      7:25
    • SQA 08 - Finding A Search String in Another Workbook With Multiple Sheets

      4:54
    • SQA 09 - Extracting Unique Tables to Unique Sheets From A Big Data Set

      13:06
    • SQA 10 - Protecting Specific Cells and Data Validation

      11:34
    • SQA 11 - Dynamically Populating A Reusable Array While Looping Through A Table

      5:24
    • SQA 12 - Sequential PDFs With Pictures

      17:02
    • SQA 13 - File Picker, And Report Generator With Intelligent Filing

      13:09

About This Class

7bb1b264

If you really want to harness the full power of Excel, then learning how to program in VBA is ESSENTIAL!

My guess is you're reading this because:

  • You want to join the Excel elite, and program your own solutions?
  • Maybe you want to automate most of your work, do more in less time with less effort
  • Could be you want to earn more money?
  • Perhaps you may even fancy a career change?

If you answered yes to any of the above, I want you in my student community!

In this course you will learn everything you need to know about coding in VBA, even if you've never looked at a line of code before!

Introducing Visual Basic For Applications

Visual Basic for Applications, or VBA, is included with Excel, so there's nothing more to buy. If you have Excel, you already have access to VBA.

VBA is the powerhouse. It's the code that lives under the hood where the magic happens.

A lot of people can record a Macro, but being able to program in VBA is quite a different thing. It separates the good from the truly amazing, and I want you to be amazing!

Now, one of those words in "Visual Basic for Applications" carries more weight that the others. And no, it's not "Basic" (though coding the way I will teach you is simple!).

No, it's "Applications". In fact, it's the "s" at the very end. The significance is that VBA works across ALL MICROSOFT APPLICATIONS! Word, Outlook, Access, Internet Explorer, and even WINDOWS ITSELF!

In this course I will not only teach you how to code for Excel, there are even FOUR Bonus Sections:

  • Contolling Word
  • Contolling Outlook
  • Controlling PowerPoint
  • Yes, even contolling Windows

 

What Makes Me Qualified To Teach You?

Well, I'm a regular guy. I don't have a University degree, but what I do have is the drive to learn new things and never be beaten by a problem...a lot like you, I guess.

What I also have is over 20 years of experience in using Excel, and programming solutions with VBA.

I have built simple helper systems to make life easier for my colleagues. I've programmed complete MRP systems to run the procurement division of a £1.3b company, and everything in between.

So, can do it, does that mean I can teach you?

You bet! I have taught hundreds of students one on one, and even more in groups. Many of my students have gone on to better paying jobs, start their own businesses, or at the very least made their work lives less stressful! One of my most recent students got a promotion and a 15% pay rise just 16 weeks after learning how to code! Not bad, hey?

 

Why Is Your Course Different, Alan?

I'm glad you asked! 

If you got this far, you already know you get:

  • Over 9.5 hours of HD video lectures
  • Tons of downloadable resources
  • Programming projects

There are lots of great courses on coding in VBA. There are even lots of free videos on YouTube. Many of them show you all the basics in kind of a "little bit of everything" approach. I looked at what was available, and I knew I had to create something different. Of course I still cover all the basics, just like the other courses, but we will go beyond the basics, and cover in depth the "missing bits".

In addition, I will teach you my step-by-step process, the actual methods I use to build powerful solutions easily and quickly. I'm sure programming can be difficult, but not the way I do it!

You will learn how streamline your code for efficiency (and make it execute faster!) from the beginning. After we've covered all the basics, we will go on to create 6 separate projects using those very tools and techniques, where we will pull together all of your earlier learning, and give you the confidence to program your own solutions as soon as you finish the course!

 

With So Much Power, What Will You Create?

With the skills you will learn in this course you will be limited only by your imagination.

If you can describe it, you can most likely code it. What will YOU create?

Let's see. Enrol now, and let's get started!

9 of 9 students recommendSee All

I was familiar with some of the coding involved in VBA but this guy's style of teaching alone deserves a "how to" class. Beyond that, this is a really complete and mind opening class to people who know a thing or two about excel but not so much about programming.
This is definitely NOT a course to whizz through! I've been through it all, checking it out for serious study later (by my daughter) and I'm literally bewildered by the sheer flexibility of Excel. Alan makes a potentially heavy subject a lot easier to bear, but it still deserves full concentration on the part of the viewer/student. Guess what I'm going to be doing over the next few weeks?!
The inclusion of the macro book alone is enough to get someone started. Comprehensive course that gives the mile-wide, inch-deep understanding of Excel VBA so that beginners and advanced users alike can gain knowledge.

136

Students

1

Project

Alan Jarvis

Everything Is Easy, Once You Know How

Hi, my name is Alan!

I have almost thirty years of experience in teaching various subjects and have held senior management positions at several blue chip and Times Top 100 companies. I now specialise in consultancy, interim work and teaching.

My love for Excel began soon after the program was released. Back then, we really only used it for typing tables in our production planning department. If you can believe it, I was taught to then calculate with a calculator and TYPE the ans...

See full profile