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
180 Lessons (14h 29m)
    • 1. Level 3 Promo

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

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

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

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

      3:16
    • 6. 1 - Moving Code Around

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

      5:50
    • 8. 1 - With And End With

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

      7:53
    • 10. 1 - Combining Your Code

      6:17
    • 11. 1 - A Little Privacy Please

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

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

      10:52
    • 14. 2 - Introduction To The Coding Section

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

      6:15
    • 16. 2 - Changing Your VBE Settings

      2:47
    • 17. 2 - Protecting Your Code

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

      6:27
    • 19. 2 - Understanding The Hierarchy

      3:36
    • 20. 2 - The Range Object

      3:03
    • 21. 2 - The Cells Object

      2:42
    • 22. 2 - The Activecell Property

      2:15
    • 23. 2 - The Offset Property

      2:18
    • 24. 2 - The End Property

      2:49
    • 25. 2 - Dynamic Range Selection

      2:33
    • 26. 2 - The CurrentRegion Property

      2:05
    • 27. 2 - ACTIVATE vs SELECT

      1:43
    • 28. 2 - Between The Sheets

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

      2:54
    • 30. 2 - Sheets Vs Worksheets

      2:02
    • 31. 2 - Getting Around The Workbooks

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

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

      2:35
    • 34. 2 - Copy and Paste

      2:58
    • 35. 2 - Commonly Used Properties

      2:52
    • 36. 2 - Coding Exercise - The Rainbow

      2:20
    • 37. 2 - The Address Property

      4:04
    • 38. 2 - The Row and Column Properties

      1:34
    • 39. 2 - Capturing The Column Letter

      2:01
    • 40. 2 - More Useful Properties

      3:05
    • 41. 2 - Even More Useful Properties

      2:55
    • 42. 2 - Opening Another Workbook Programmatically

      6:20
    • 43. 2 - Closing Workbooks Programmatically

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

      3:41
    • 45. 3 - Intro To Programmers Toolbox

      0:50
    • 46. 3 - Variables - Local Variables

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

      3:40
    • 48. 3 - Variables - Module Level Variables

      3:43
    • 49. 3 - Variables - Project Level Variables

      3:02
    • 50. 3 - Variables - Bonus - Calling A Sub Stored In A COMPLETELY DIFFERENT WORKBOOK

      4:18
    • 51. 3 - Variables - All The Techie Bits

      9:30
    • 52. 3 - An Introduction To Looping

      1:07
    • 53. 3 - Looping With Do Loop

      5:01
    • 54. 3 - Looping With For Next

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

      2:02
    • 56. 3 - Looping With While Wend

      7:10
    • 57. 3 - An Introduction To Logical Testing

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

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

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

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

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

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

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

      3:21
    • 65. 3 - Logical Testing - Select Case

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

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

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

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

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

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

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

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

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

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

      4:47
    • 76. 3 - Arrays - An Introduction

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

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

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

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

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

      7:41
    • 82. 3 - Arrays - Using An Array As A Data Source For A VLookup

      2:55
    • 83. 4 - Intro To Monthly Reporting

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

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

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

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

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

      3:47
    • 89. 4 - Solving That Naming Problem

      3:04
    • 90. 4 - Sizing Your Charts Precisely

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

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

      7:36
    • 93. 4 - Titles, Money And Sorting

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

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

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

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

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

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

      2:54
    • 100. 4 - Tidy Up The Title

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

      5:53
    • 102. 4 - Pretty Up Our Pie Chart

      2:50
    • 103. 4 - Putting It All Together

      4:50
    • 104. 5 - Intro To Web Query section

      1:38
    • 105. 5 - Capturing The Data For Rome

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

      5:59
    • 107. 5 - Data Clean Up

      4:11
    • 108. 5 - A Simple Find And Replace

      2:07
    • 109. 5 - Getting Our Formulas Right

      3:51
    • 110. 5 - Streamlining The Formulas Code

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

      3:06
    • 112. 5 - Putting It All Together

      1:55
    • 113. 6 - Intro To The Events Section

      2:06
    • 114. 6 - WorkBook SheetActivate

      4:09
    • 115. 6 - WorkBook BeforePrint

      2:47
    • 116. 6 - WorkBook SheetChange

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

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

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

      5:41
    • 120. 6 - WorkBook BeforeClose

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

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

      2:44
    • 123. 6 - WorkSheet Change

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

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

      3:31
    • 126. 6 - Worksheet Events - BONUS (4 New Things To Play With!)

      8:34
    • 127. 6.5 - User Defined Functions

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

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

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

      4:07
    • 131. 6.5 - A UDF For Getting All Your Sheet Names

      3:05
    • 132. 6.5 - Calling A UDF From A Different Workbook

      1:47
    • 133. 7 - Intro To Folder Creation Gizmo

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

      0:55
    • 135. 7 - A Single Level Folder Structure

      5:27
    • 136. 7 - Folders Within Folders

      5:36
    • 137. 8 - Intro To The Emailing Section

      3:10
    • 138. 8 - Understanding The eMail Routine

      4:57
    • 139. 8 - Capturing All The Data

      10:14
    • 140. 8 - The eMail Loop

      5:06
    • 141. 9 - Intro To The Word Section

      0:45
    • 142. 9 - Understanding The Word Routine

      2:17
    • 143. 9 - Deconstructing The Gather Data Code

      3:02
    • 144. 9 - Formula Modifications With Unique Values

      3:18
    • 145. 9 - Efficient Sorting

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

      5:16
    • 147. 10 - Intro To PowerPoint Section

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

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

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

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

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

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

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

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

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

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

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

      3:56
    • 159. 11 - The Folder Picker

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

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

      13:17
    • 162. Level 3 Wrap Up

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

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

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

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

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

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

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

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

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

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

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

      5:24
    • 174. SQA 12 - Sequential PDFs With Pictures

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

      13:09
    • 176. SQA 14 - Why Is My Workbook So Big?

      7:26
    • 177. SQA 15 - Finding Updated Values In One Workbook, And Adding Them To Another Workbook

      9:10
    • 178. SQA 16 - Gantt Charts With A Little More Sophistication

      10:30
    • 179. SQA 17 - Vlookups (Or Any Application.WorksheetFunction) Over Ranges

      12:20
    • 180. SQA 18 - Adding A Date Stamp If A Change Has Been Made

      5:36
29 students are watching this class
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

17 of 17 students recommend this class