A. G. Jarvis Limited
Add to basket or enquire
So you have done Microsoft Excel Level 1 and Level 2 , do you want to join the Excel Elite, and program your own solutions?
If you really want to harness the full power of Excel, then learning how to program in VBA (Visual Basic for Applications) is ESSENTIAL!
What you'll learn in this Level 3 course:
- Learn to program in VBA from scratch
- Understand coding, and the thought process behind it
- Fully automate Excel using Visual Basic for Applications
- Fully automate report generation
- Develop complex full blown applications from scratch
- Create Word documents using VBA code right from Excel!
- And much more in Excel
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 Microsoft Excel VBA, even if you've never looked at a line of code before!
- 3: Introducing The Visual Basic Editor, & Recording Our First Macro 11:10
- 4: Saving Macro-enabled Workbooks, And Security Settings 03:16
- 5: Moving Code Around 04:38
- 6: Stepping Out. Well, In Actually - Debugging Made Easy 05:50
- 7: With And End With 12:34
- 8: Streamlining You Code, Or, Get Rid Of What You Don't Need 07:53
- 9: Combining Your Code 06:17
- 10: A Little Privacy Please 03:18
- 11: Keyboard Shortcuts, And Why I Don't Use Them 02:03
- 12: Why You Can't Get By With Just Recording Macros 10:52
- 13: Quiz 1 05:00
- 14: Introduction To The Coding Section 05:35
- 15: Getting All The Code For This Section 06:15
- 16: Changing Your VBE Settings 02:47
- 17: Protecting Your Code 02:10
- 18: Objects, Methods And Properties 06:27
- 19: Understanding The Hierarchy 03:36
- 20: The Range Object 03:03
- 21: The Cells Object 02:42
- 22: The Activecell Property 02:15
- 23: The Offset Property 02:18
- 24: The End Property 02:49
- 25: Dynamic Range Selection 02:33
- 26: The CurrentRegion Property 02:05
- 27: ACTIVATE vs. SELECT 01:43
- 28: Between The Sheets 02:40
- 29: Calling A Sheet By Its VB Name 02:54
- 30: Sheets Vs. Worksheets 02:02
- 31: Getting Around The Workbooks 03:10
- 32: The Value Property - Writing Data 05:26
- 33: The Value Property - Reading And Writing Data 02:35
- 34: Copy and Paste 02:58
- 35: Commonly Used Properties 02:52
- 36: CODING EXERCISE - The Rainbow 02:20
- 37: The Address Property 04:04
- 38: The Row and Column Properties 01:34
- 39: Capturing The Column Letter 02:01
- 40: More Useful Properties 03:05
- 41: Even More Useful Properties 02:55
- 42: Opening Another Workbook Programmatically 06:20
- 43: Closing Workbooks Programmatically 03:41
- 44: Coding Exercise - Open Write Close 03:41
- 45: Quiz 2 03:00
- 46: Introduction To The Programmers Toolbox 00:50
- 47: Variables - Local Variables 06:46
- 48: Variables - Local Variables With A Twist 03:40
- 49: Variables - Module Level Variables 03:43
- 50: Variables - Project Level Variables 03:02
- 51: Bonus - Calling A Sub Stored In A COMPLETELY DIFFERENT WORKBOOK 04:18
- 52: A Neat Trick To Force Variable Declaration 01:09
- 53: Variables - All The Techie Bits 09:29
- 54: An Introduction To Looping 01:07
- 55: Looping With Do Loop 05:01
- 56: Looping With For Next 02:33
- 57: Looping With A Stepped For Next 02:02
- 58: Looping With While Wend 07:10
- 59: An Introduction To Logical Testing 01:41
- 60: Logical Testing - A Simple If Test 06:43
- 61: Logical Testing - A Simple If Test Using Cells 05:12
- 62: Logical Testing - If Then Else 03:17
- 63: Logical Testing - If Then Else Using Cells 03:41
- 64: Logical Testing - Testing Multiple Criteria 03:33
- 65: Logical Testing - Testing If One Is True, And One Is False 02:19
- 66: Logical Testing - Testing If Either Value Is True 03:21
- 67: Logical Testing - Select Case 06:16
- 68: Maths - Doing Simple Maths In Code 02:42
- 69: Maths - Writing Formulas To Single Cells 06:56
- 70: Maths - Writing Formulas To Ranges Of Cells 05:19
- 71: Maths - Using Excel's Built-in Functions 03:55
- 72: Maths - Built-in Functions With Defined Ranges 03:25
- 73: InputBox - Getting User Input Using The InputBox Function 05:29
- 74: Manipulating The User Input With Casing 04:20
- 75: InputBox - Getting User Input Using The InputBox Method 05:54
- 76: Message Boxes - Simple Message Boxes 04:06
- 77: Message Boxes - Testing Which Button Was Pressed 04:47
- 78: 3150 - Arrays - An Introduction 02:37
- 79: Arrays - A Simple One Dimensional Static Array 05:56
- 80: Arrays - A Simple One Dimensional Dynamic Array 04:44
- 81: Arrays - A Simple Two Dimensional Static Array 05:33
- 82: Arrays - The Most Efficient Way To Capture An Array 04:55
- 83: Arrays - Extracting Useful Data Based On User Input 07:41
- 84: Using An Array As A Data Source For A VLOOKUP 02:55
- 85: Quiz 3 05:00
- 86: Introduction To Monthly Reporting 02:28
- 87: Automating All Your Reports - 2010 Users 01:20
- 88: Recording The Bones Of The Code 04:25
- 89: Streamlining The "Add New Sheet" Code 06:11
- 90: Deconstructing The "Profit By Day" Code 02:09
- 91: Building Source Data Strings Dynamically At Runtime 07:53
- 92: Creating Run Order and Data Capture Subs 03:47
- 93: Solving That Naming Problem 03:04
- 94: POWER USER - Sizing Your Charts Precisely 03:17
- 95: Changing The Chart Title (And Why We Do It Separately) 02:37
- 96: Deconstructing The Pivot Tables (It's Slightly Different) 07:36
- 97: Titles, Money And Sorting 04:46
- 98: Butchering One Table, To Create Another 04:33
- 99: Adding The Commentary - Building Strings Dynamically At Runtime 07:31
- 100: Adding The Commentary Using Data From The Sheet We're On 03:56
- 101: POWER USER - How DO You Make Specific Words Bold 04:36
- 102: POWER USER - INSTR...A Very Useful Function 05:03
- 103: INSTR And Paying Attention To Detail 02:54
- 104: Tidy Up The Title 03:01
- 105: Easy As Pie (Chart) 05:53
- 106: Pretty Up Our Pie Chart 02:50
- 107: Putting It All Together 04:50
- 108: Introduction To The Web Query section 01:38
- 109: Pulling Data From The Internet - Capturing The Data For Rome 04:18
- 110: Getting To Cancun And London From Rome 05:59
- 111: Data Clean-Up 04:11
- 112: A Simple Find And Replace 02:07
- 113: Getting Our Formulas Right 03:51
- 114: Streamlining The Formulas Code 04:16
- 115: POWER USER - Displaying Messages In The Status Bar (Cool) 03:06
- 116: Putting It All Together 01:55
- 117: Intro To The Events Section 02:06
- 118: WorkBook SheetActivate 04:09
- 119: WorkBook BeforePrint 02:47
- 120: WorkBook SheetChange 01:14
- 121: WorkBook Open - Creating An Auto-Back Up 05:17
- 122: WorkBook Open - Creating A Splash Screen 03:55
- 123: WorkBook Open - Calling Other Code 05:41
- 124: WorkBook BeforeClose 03:09
- 125: WorkSheet Activate - You Can't Pick This 01:44
- 126: WorkSheet Activate - You Might Pick This 02:44
- 127: WorkSheet Change 02:32
- 128: WorkSheet Change - A More Useful Use 04:57
- 129: WorkSheet Activate - Top Secret Classified Information 03:31
- 130: BONUS - WorkSheet Events - 4 New Things To Try 08:34
- 131: User Defined Functions...What They Are, And How You Make Them 05:39
- 132: Using A UDF To Return Information 01:41
- 133: Creating A Countdown Timer With A UDF 08:30
- 134: A Custom UDF For Calculating Volume Discount 04:07
- 135: A UDF For Getting All Your Sheet Names 03:05
- 136: Calling A UDF From A Different Workbook 01:47
- 137: SuperCountIf and SuperSumIf UDF's 10:18
- 138: Introduction To The Folder Creation Gizmo 02:24
- 139: Creating A New Folder With A Single Line Of Code 00:55
- 140: A Single Level Folder Structure 05:27
- 141: Folders Within Folders 05:36
- 142: Introduction To The e-Mailing Section 03:10
- 143: Understanding The e-Mail Routine 04:57
- 144: Capturing All The Data 10:14
- 145: The e-Mail Loop 05:06
- 146: Introduction To The Word Section 00:45
- 147: Understanding The Word Routine 02:17
- 148: Deconstructing How We Capture All The Data 03:02
- 149: Formula Modifications With Unique Values 03:18
- 150: Efficient Sorting 02:56
- 151: Building The Text And Wrap Up 05:16
- 152: Introduction To The PowerPoint Section 01:12
- 153: A Run Through The PowerPoint Base Code 09:23
- 154: Setting Up The Shell Of The Code 03:13
- 155: Who's Presenting This... 02:31
- 156: Adding A Slide With A Logo And Text 08:20
- 157: Prettying Up The Formatting (More Lego Coding!) 02:03
- 158: Using Slide 1 To Create Slide 2 04:33
- 159: Adding A Chart As A Picture 06:43
- 160: Adding Pivot Tables (And Another Chart) 09:12
- 161: Final Slide, And Wrap Up 02:12
- 162: Introduction To Importing Data From A Folder Full Of Files 03:26
- 163: Looping Through All Excel Files In A Folder 03:56
- 164: The Folder Picker 03:11
- 165: A More Useful Loop Through Files 03:20
- 166: The Data Grabber(er) 13:17
- 167: Level 3 SQA 01 - Get Rid Of Rows In An Array 05:49
- 168: Level 3 SQA 02 - Emailing Routine Adding a Specific Attachment Based On a Criter 03:34
- 169: Level 3 SQA 03 - Adding A Date Stamp, And Going To The Insertion Point AUTOMATIC 07:25
- 170: Level 3 SQA 04 - Saving An Individual Sheet To A Specific Folder 11:41
- 171: Level 3 SQA 05 - Saving Multiple Sheets To A Single Workbook In A Specific Folde 27:29
- 172: Level 3 SQA 06 - Animated Charts...With A Little Something Extra! 06:23
- 173: Level 3 SQA 07 - Extracting Specific Data From A Big File, To A Bunch Of Little 07:25
- 174: Level 3 SQA 08 - Finding A Search String in Another Workbook With Multiple Sheet 04:54
- 175: Level 3 SQA 09 - Extracting Unique Tables to Unique Sheets From A Big Data Set 13:06
- 176: Level 3 SQA 10 - Protecting Specific Cells and Data Validation 11:34
- 177: Level 3 SQA 11 - Dynamically Populating A Reusable Array While Looping Through A 05:24
- 178: Level 3 SQA 12 - Sequential PDF Creation With Pictures 17:02
- 179: Level 3 SQA 13 - File Picker, And Report Generator With Intelligent Filing 13:09
- 180: Level 3 SQA 14 - Why Is My Workbook So Big 07:26
- 181: Level 3 SQA 15 - Finding Updated Values In One Workbook, And Adding Them To Anot 09:10
- 182: Level 3 SQA 16 - Gantt Charts With A Little More Sophistication 10:30
- 183: Level 3 SQA 17 - Vlookups (Or Any Application.WorksheetFunction) Over Ranges 12:20
- 184: Level 3 SQA 18 - Adding A Date Stamp If A Change Has Been Made 05:36
- 185: Level 3 SQA 19 - Creating a Toggle Custom Keyboard Shortcut 04:36
- 186: Level 3 SQA20 - Creating Unique Passwords For Individual Sheets 08:54
Excel is the most in commonly used and in demand tool for making sense of data. When you can harness that power, you will be a sought after employee. If you run a business, being proficient in Excel can help you see your business in a completely different light.
"This is a great course! ...I can't wait to start using it. I will certainly be using the emailing program! And reports. My mind is reeling!" - Nickie Student!
"Great course overall, by far the best..." - Antsta
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:
- Controlling Outlook
Yes, even controlling Windows
and now...Automating PowerPoint!
"If you are serious about learning how to make excel work for you, you should take this course" - Beatrice
"I first encountered Alan by doing his level 1 and level 2 courses. I wish I had come across him many years earlier. I'm learning so much about VBA than I could have ever imagined. This is an excellent course..." - Jonathan Balmforth
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 30 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:
15 hours of HD video lectures
74 downloadable resources
All the source code for the course + more!
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. Enroll now, and let's get started!
Who is this course for?
Ideally you will need to have completed Level 1 & 2 of this series
You will have a good understanding of the basics of Excel
This course for those who want to harness the full power of Excel
Anyone who wants to develop their skills and career
No programming or coding experience needed!
This course for those who want to harness the full power of Excel
A desire to develop your skills and career
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reed Courses Certificate of Completion
Digital certificate - Included
Will be downloadable when all lectures have been completed.
Currently there are no reviews for this course. Be the first to leave a review.