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
170 Videos (13h 12m)
    • 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 - Copy and Paste

      2:58
    • 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
    • 11 - Importing Specific Data From Multiple Files - Intro

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

      3:56
    • 11 - The Folder Picker

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

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

      13:17
    • Level 3 Wrap Up

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

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

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

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

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

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

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

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

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

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

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

      5:24
    • SQA 12 Sequential PDFs With Pictures

      17:02