Microsoft Excel Essentials: Level 3 - VBA Programming - Unleash The Full Power Of Excel With VBA | Alan Jarvis | Skillshare

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
37 students are watching this class

Project Description

  • Learn to program in VBA from scratch 
  • Complete routine tasks thousands of times faster! (Yes, see demo)
  • Confifdently tackle any programming project
  • Understand coding, and the thought process behind it
  • Fully automate Excel using Visual Basic for Applications
  • Fully automate report generation
  • Program simple "helper" solutions

Resources(56)

Student Projects

3 comments