Excel Essentials: Level 3 - VBA Programming

Unleash The Full Power Of Excel, From Helper Programs to Complete Solutions
Course Created by Alan Jarvis
Hi, my name is Alan, and 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.

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!

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

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

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 than 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, PowerPoint, Internet Explorer, and even WINDOWS ITSELF!

In this course I will not only teach you how to code for Excel, there are even THREE, no...FOUR Bonus Sections:
  • Contolling Word
  • Contolling Outlook
  • Yes, even controlling Windows
  • and now...Automating PowerPoint!
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, I 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 10.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!

Course Outline

Chapter 1: What's It All About, Alan?

  • Lesson 1
    0005 - Why Should I Learn H…
    10:29
  • Lesson 2
    0010 - The 15 Golden Rules …
    06:25

Chapter 2: Introducing Your Personal Built In Translator...the Macro Recorder

  • Lesson 3
    1005 - Introducing The Visu…
    11:11
  • Lesson 4
    1010 - Saving Macro-enabled…
    03:17
  • Lesson 5
    1015 - Moving Code Around
    04:39
  • Lesson 6
    1020 - Stepping Out. Well, …
    05:51
  • Lesson 7
    1025 - With And End With
    12:35
  • Lesson 8
    1030 - Streamlining You Cod…
    07:54
  • Lesson 9
    1035 - Combining Your Code
    06:18
  • Lesson 10
    1040 - A Little Privacy Please
    03:19
  • Lesson 11
    1045 - Keyboard Shortcuts, …
    02:04
  • Lesson 12
    1050 - Why You Cant Get By …
    10:53

Chapter 3: The Building Blocks Of Coding...Your Dictionary & Phrase Book Of Success!

  • Lesson 13
    2000 - Introduction To The …
    05:36
  • Lesson 14
    2005 - Getting All The Code…
    06:16
  • Lesson 15
    2010 - Changing Your VBE Se…
    02:48
  • Lesson 16
    2015 - Protecting Your Code
    02:11
  • Lesson 17
    2020 - Objects, Methods And…
    06:28
  • Lesson 18
    2025 - Understanding The Hi…
    03:37
  • Lesson 19
    2030 - The Range Object
    03:04
  • Lesson 20
    2035 - The Cells Object
    02:43
  • Lesson 21
    2040 - The Activecell Property
    02:16
  • Lesson 22
    2045 - The Offset Property
    02:19
  • Lesson 23
    2050 - The End Property
    02:50
  • Lesson 24
    2055 - Dynamic Range Selection
    02:34
  • Lesson 25
    2060 - The CurrentRegion Pr…
    02:06
  • Lesson 26
    2065 - ACTIVATE vs. SELECT
    01:44
  • Lesson 27
    2070 - Between The Sheets
    02:41
  • Lesson 28
    2075 - Calling A Sheet By I…
    02:55
  • Lesson 29
    2080 - Sheets Vs. Worksheets
    02:03
  • Lesson 30
    2085 - Getting Around The W…
    03:11
  • Lesson 31
    2090 - The Value Property -…
    05:27
  • Lesson 32
    2095 - The Value Property -…
    02:36
  • Lesson 33
    2100 - Commonly Used Proper…
    02:53
  • Lesson 34
    2101 - Coding Exercise - Th…
    02:21
  • Lesson 35
    2105 - The Address Property
    04:05
  • Lesson 36
    2110 - The Row and Column P…
    01:35
  • Lesson 37
    2115 - Capturing The Column…
    02:02
  • Lesson 38
    2120 - More Useful Properties
    03:07
  • Lesson 39
    2125 - Even More Useful Pro…
    02:56
  • Lesson 40
    2130 - Opening Another Work…
    06:21
  • Lesson 41
    2135 - Closing Workbooks Pr…
    03:42
  • Lesson 42
    2137 - Coding Exercise - Op…
    03:42

Chapter 4: The Programmers Toolbox...The Techie Stuff, Made Easy (Honest!)

  • Lesson 43
    3000 - Intro To Programmers…
    00:51
  • Lesson 44
    3005 - Variables - Local Va…
    06:47
  • Lesson 45
    3010 - Variables - Local Va…
    03:41
  • Lesson 46
    3015 - Variables - Module L…
    03:44
  • Lesson 47
    3020 - Variables - Project …
    03:03
  • Lesson 48
    3025 - Variables - All The …
    09:31
  • Lesson 49
    3030 - An Introduction To L…
    01:08
  • Lesson 50
    3035 - Looping With Do Loop
    05:02
  • Lesson 51
    3040 - Looping With For Next
    02:34
  • Lesson 52
    3045 - Looping With A Stepp…
    02:03
  • Lesson 53
    3050 - Looping With While Wend
    07:11
  • Lesson 54
    3055 - An Introduction To L…
    01:42
  • Lesson 55
    3060 - Logical Testing - A …
    06:44
  • Lesson 56
    3065 - Logical Testing - A …
    05:13
  • Lesson 57
    3070 - Logical Testing - If…
    03:18
  • Lesson 58
    3075 - Logical Testing - If…
    03:42
  • Lesson 59
    3080 - Logical Testing - Te…
    03:34
  • Lesson 60
    3085 - Logical Testing - Te…
    02:20
  • Lesson 61
    3090 - Logical Testing - Te…
    03:23
  • Lesson 62
    3095 - Logical Testing - Se…
    06:17
  • Lesson 63
    3100 - Maths - Doing Simple…
    02:43
  • Lesson 64
    3105 - Maths - Writing Form…
    06:57
  • Lesson 65
    3110 - Maths - Writing Form…
    05:20
  • Lesson 66
    3115 - Maths - Using Excels…
    03:56
  • Lesson 67
    3120 - Maths - Built-in Fun…
    03:26
  • Lesson 68
    3125 - Getting User Input U…
    05:30
  • Lesson 69
    3130 - Manipulating The Use…
    04:21
  • Lesson 70
    3135 - Getting User Input U…
    05:55
  • Lesson 71
    3140 - Message Boxes - Simp…
    04:07
  • Lesson 72
    3145 - Message Boxes - Test…
    04:48
  • Lesson 73
    3150 - Arrays - An Introduc…
    02:38
  • Lesson 74
    3155 - Arrays - A Simple On…
    05:57
  • Lesson 75
    3160 - Arrays - A Simple On…
    04:45
  • Lesson 76
    3165 - Arrays - A Simple Tw…
    05:34
  • Lesson 77
    3170 - Arrays - The Most Ef…
    04:56
  • Lesson 78
    3175 - Arrays - Extracting …
    07:43

Chapter 5: Automating All Your Reports!

  • Lesson 79
    4000 - Intro To Monthly Rep…
    02:29
  • Lesson 80
    4005 - Recording The Bones …
    04:26
  • Lesson 81
    4010 - Streamlining The Add…
    06:13
  • Lesson 82
    4015 - Deconstructing The P…
    02:10
  • Lesson 83
    4020 - Building Source Data…
    07:54
  • Lesson 84
    4025 - Creating Run Order a…
    03:48
  • Lesson 85
    4030 - Solving That Naming …
    03:05
  • Lesson 86
    4035 - Sizing Your Charts P…
    03:18
  • Lesson 87
    4040 - Changing The Chart T…
    02:38
  • Lesson 88
    4045 - Deconstructing The P…
    07:37
  • Lesson 89
    4050 - Titles, Money And So…
    04:47
  • Lesson 90
    4055 - Butchering One Table…
    04:34
  • Lesson 91
    4060 - Adding The Commentar…
    07:32
  • Lesson 92
    4065 - Adding The Comentary…
    03:57
  • Lesson 93
    4070 - How DO You Make Spec…
    04:37
  • Lesson 94
    4075 - INSTR. . .A Very Use…
    05:04
  • Lesson 95
    4080 - INSTR And Paying Att…
    02:55
  • Lesson 96
    4085 - Tidy Up The Title
    03:02
  • Lesson 97
    4090 - Easy As Pie (Chart)
    05:54
  • Lesson 98
    4095 - Pretty Up Our Pie Chart
    02:51
  • Lesson 99
    4100 - Putting It All Together
    04:51

Chapter 6: The Data Is Out There...On The Internet, That Is

  • Lesson 100
    5000 - Intro To Web Query s…
    01:39
  • Lesson 101
    5005 - Capturing The Data F…
    04:19
  • Lesson 102
    5010 - Getting To Cancun An…
    06:00
  • Lesson 103
    5015 - Data Clean Up
    04:12
  • Lesson 104
    5020 - A Simple Find And Re…
    02:08
  • Lesson 105
    5025 - Getting Our Formulas…
    03:52
  • Lesson 106
    5030 - Streamlining The For…
    04:17
  • Lesson 107
    5035 - Displaying Messages …
    03:07
  • Lesson 108
    5040 - Putting It All Together
    01:56

Chapter 7: Workbook Events: You Don't Have To Run Code To Have Code Run!

  • Lesson 109
    6000 - Intro To The Events …
    02:07
  • Lesson 110
    6005 - WorkBook SheetActivate
    04:10
  • Lesson 111
    6010 - WorkBook BeforePrint…
    02:48
  • Lesson 112
    6015 - WorkBook SheetChange
    01:15
  • Lesson 113
    6020 - WorkBook Open - Crea…
    05:18
  • Lesson 114
    6025 - WorkBook Open - Crea…
    03:56
  • Lesson 115
    6030 - WorkBook Open - Call…
    05:42
  • Lesson 116
    6035 - WorkBook BeforeClose
    03:10
  • Lesson 117
    6040 - WorkSheet Activate -…
    01:45
  • Lesson 118
    6045 - WorkSheet Activate -…
    02:45
  • Lesson 119
    6050 - WorkSheet Change
    02:33
  • Lesson 120
    6055 - WorkSheet Change - A…
    04:58
  • Lesson 121
    6060 - WorkSheet Activate -…
    03:32

Chapter 8: User Defined Functions...What To Do If The Function You Need Isn't In Excel!

  • Lesson 122
    6505 - User Defined Functio…
    05:40
  • Lesson 123
    6510 - Using A UDF To Retur…
    01:42
  • Lesson 124
    6515 - Creating A Countdown…
    08:31
  • Lesson 125
    6520 - A Custom UDF For Cal…
    04:08
  • Lesson 126
    6525 - Calling A UDF From A…
    01:48

Chapter 9: Bonus Section: Controlling Windows - Folder Creation Gizmo

  • Lesson 127
    7000 - Intro To Folder Crea…
    02:25
  • Lesson 128
    7005 - Creating A New Folde…
    00:56
  • Lesson 129
    7010 - A Single Level Folde…
    05:28
  • Lesson 130
    7015 - Folders Within Folders
    05:37

Chapter 10: Bonus Section: eMail Automation...Why WRITE emails!

  • Lesson 131
    8000 - Intro To The Emailin…
    03:11
  • Lesson 132
    8005 - Understanding The eM…
    04:58
  • Lesson 133
    8010 - Capturing All The Data
    10:15
  • Lesson 134
    8015 - The eMail Loop
    05:07

Chapter 11: Bonus Section: Word Automation - Controlling Word From Excel

  • Lesson 135
    9000 - Intro To The Word Se…
    00:46
  • Lesson 136
    9005 - Understanding The Wo…
    02:18
  • Lesson 137
    9010 - Deconstructing The G…
    03:03
  • Lesson 138
    9015 - Formula Modification…
    03:19
  • Lesson 139
    9020 - Efficient Sorting
    02:57
  • Lesson 140
    9025 - Building The Text An…
    05:17

Chapter 12: Bonus Section: PowerPoint Automation - Create Your Presentation In Seconds!

  • Lesson 141
    10000 - Intro To PowerPoint…
    01:13
  • Lesson 142
    10005 - A Run Through The P…
    09:24
  • Lesson 143
    10010 - Setting Up The Shel…
    03:14
  • Lesson 144
    10015 - Whos Presenting Thi…
    02:32
  • Lesson 145
    10020 - Adding A Slide With…
    08:21
  • Lesson 146
    10025 - Prettying Up The Fo…
    02:04
  • Lesson 147
    10030 - Using Slide 1 To Cr…
    04:34
  • Lesson 148
    10035 - Adding A Chart As A…
    06:44
  • Lesson 149
    10040 - Adding Pivot Tables…
    09:13
  • Lesson 150
    10045 - Final Slide, And Wr…
    02:13

Chapter 13: Thank You And Congratulations On Finishing The Course!

  • Lesson 151
    Congratulations, You Finish…
    01:03

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)