Ad

Learnit Training provides this Excel VBA Beginner Tutorial for those looking to boost their Excel skills.

Sure, it’s not Spark or Python, but not everything needs to be. Winking smile

Exercise files: https://bit.ly/2OGV7eu

Content:

  • Introduction 0:03
  • What is VBA? 1:44
  • Object Oriented Programming Languages 5:59
  • Turning on the Developer Tab 10:17
  • The Macro Recorder 13:40
  • Using Relative References 20:39
  • Recording Simple Macros 27:51
  • Multi-Step Macro Recording 39:25
  • Sort and Filter Macro Recording 45:26
  • Protecting and Formatting Sheets with the Macro Recorder 51:35
  • VBA Interface Setup 55:09
  • Recorder Code vs. Manual Code 1:01:11
  • Introduction to Editing Macros 1:12:28
  • Debugging Macros 1:16:53
  • Grammar in VBA 1:28:00
  • Macro Scripting Basics 1:33:04
  • Range 1:40:41
  • Selection & Color 1:47:14
  • Value and Clear 1:52:16
  • ActiveSheet, Sheets, and Name 1:54:01
  • CurrentRegion 1:56:40
  • Practice 1:58:08
tt ads

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.