Excel Essentials: Level 3 - VBA Programming - Unleash The Full Power Of Excel! Premium class

Alan Jarvis, Everything Is Easy, Once You Know How

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
152 Videos (10h 40m)
    • 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 - 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
    • Level 3 Wrap Up

      1:02

About This Class

If your 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 THREE Bonus Sections:

  • Contolling Word
  • Contolling Outlook
  • 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
  • Quizes
  • 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 5 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

Students

--

Projects

0

Reviews (0)

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 answers into Excel...you'd be surprised how many people I meet who still do this!

There were two turning points for me in my journey. The first was a chance conversation with one of our accountants when I was complaining how slow it was to keep having to flip between worksheets to see different bits of data. He introduced me to VLookups and a new world of possibilities opened up. I found that I need never have huge paper accountancy pads (remember those?) and a calculator to produce a production plan again! Suddenly, I could produce my plan in 15 minutes, rather than the day and a half it used to take. I began delving into other features of Excel, and finding ways to incorporate them into the planning "system" I had created, and remember this was back in the day when the internet hadn't been invented! Through trial and error, I refined my Workbook until I could chomp through days of work in seconds, and what's more, using these powerful features of Excel, I could optimise our production runs to get more output from the same working week, something that had never been done before. Promotion soon followed, and I became the "go to guy" for anything Excel related. This was the 90's.

Then, in manufacturing, came the MRP revolution. We had an army of programmers developing a system for us. This was my second turning point. I was awestruck with coders. The skill they had, and how clever they were, and that they were smart enough to go to university in the first place. I wasn't like that. I had no formal education beyond primary and secondary school, but a really cool programmer named Mark let me into a secret...

He said "If you can describe, step by step, how to cross the road without getting killed, you can be a programmer". I recorded my first macro, and took a peek under the hood. I deconstructed the VBA code, and played with it until I understood what everything did. Then I changed it to make it do what I needed it to do. 

Since then, I have developed accountancy systems, simple planning systems, full blown MRP systems and scores of stand alone "helper" systems to simplify and speed up work in almost every department in every company I have worked in. Some of the solutions I created 20 years ago are still being used today! If you doubt the power of Excel, it may surprise you to learn that you can run the procurement of a £1.3b (yes, billion) company with an Excel file with a bit of coding behind it. This is a skill that people will pay highly for!

Not everyone wants to go that far, so over the years I have taught people to create efficient solutions for themselves, either with or without coding. Those who took the time to learn have since had multiple promotions, or have started their own businesses! At the very least, they are getting more work done in less time with less headaches :)

If you are a complete beginner, just want to polish up your skills, or want to create sophisticated super efficient solutions for your business or personal life, my series of courses will help you achieve that. All you need is a little time, and a willingness to learn...I'm looking forward to working with you.

Alan