Automation with Excel Macros / Excel VBA - Beginner to Advanced | Steve Tran | Skillshare
Browse
Search
Sign In

Playback Speed

  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Automation with Excel Macros / Excel VBA - Beginner to Advanced

teacher avatar Steve Tran, Freelance Software Developer

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

    • 1.

      Introduction - Updated

      4:57

    • 2.

      1.1 Showing Developer Tab

      0:34

    • 3.

      1.2 Recording Macros

      2:41

    • 4.

      1.3 Saving XLSM file type

      1:10

    • 5.

      1.4 Viewing Your Code

      1:27

    • 6.

      1.5 VBA Editor Message Box

      2:47

    • 7.

      1.6 Cell Referencing

      1:50

    • 8.

      1.7 Naming a Cell

      2:25

    • 9.

      1.8 Create a Folder

      2:48

    • 10.

      1.9 Error Debugging

      3:31

    • 11.

      1.10 Writing Data to Cell

      1:02

    • 12.

      1.11 Variables

      1:13

    • 13.

      1.12.1 Basic Math Integers

      1:36

    • 14.

      1.12.2 Integer vs Long

      2:35

    • 15.

      1.13 If Statements

      3:14

    • 16.

      1.14 For Loop

      4:18

    • 17.

      1.15 For Loops Continued Automation!

      2:51

    • 18.

      1.A Class Project 01 Description and Tutorial

      14:37

    • 19.

      1.16 Esc Key to Stop Macro

      4:28

    • 20.

      1.17.1 Do While Loop Intro

      8:20

    • 21.

      1.17.2 Do While Loop Use Case

      9:07

    • 22.

      1.17.3 For Each Loop Intro

      7:46

    • 23.

      1.17.4 Variant Variable Type

      9:23

    • 24.

      1.17.5 For Each Loop using Variant

      4:25

    • 25.

      1.18.1 Object Variables - Set - Intro

      4:11

    • 26.

      1.18.2 Object Vars - Declare + Read All Files in Folder

      7:12

    • 27.

      1.19.1 Workbook Object

      11:11

    • 28.

      1.19.2 Worksheet Object

      5:40

    • 29.

      1.20 Reference Libraries Word Object Intro

      7:50

    • 30.

      1.21.1 Calling Sub From Another Sub

      4:56

    • 31.

      1.21.2 Call Sub with a Parameter

      7:52

    • 32.

      1.21.3 Call Sub with Multiple Parameters

      7:04

    • 33.

      1.21.4 Sub with Optional Parameter

      6:55

    • 34.

      1.22 Functions Intro

      5:19

    • 35.

      1.23 With Statement

      5:52

    • 36.

      1.24.1 Error Catching - Intro - On Error

      9:26

    • 37.

      1.24.2 GoTo - Code Bookmark

      5:27

    • 38.

      1.24.3 On Error Goto Bookmark

      8:05

    • 39.

      1.24.4 On Error - Persistence and Reset

      9:35

    • 40.

      1.C.1 Automate Creating Txt Files

      6:40

    • 41.

      1.C.2 Automate Rename Files Fix

      9:18

    • 42.

      2.1 Moving Data - Create Form Record Macro

      4:24

    • 43.

      2.2 Moving Data - Name the Ranges

      7:11

    • 44.

      2.3 Moving Data - Simplify Recorded Code

      5:12

    • 45.

      2.4 Moving Data - Paste Values Only

      4:19

    • 46.

      2.5 Moving Data - Without Copy and Paste

      3:35

    • 47.

      2.6 Moving Data - Writing to Next Row

      6:00

    • 48.

      2.7 Moving Data - Add Timestamp

      1:35

    • 49.

      2.8 Moving Data - Writing to Different Sheet

      3:59

    • 50.

      2.9 Moving Data - Tidy Up

      6:28

    • 51.

      2.10 Moving Data - Validation Before Process

      15:36

    • 52.

      2.11 Named Table Object (List Object)

      5:04

    • 53.

      2.11.1 ListObjects (Table) - VBA Intro

      10:39

    • 54.

      2.11.2 ListObjects - ListRows and Looping

      6:22

    • 55.

      2.11.3 ListObjects - ListColumns and Row Values

      7:32

    • 56.

      2.11.4 Excercise - Delete Certain Rows

      18:54

    • 57.

      2.11.5 Excercise - Delete Certain Rows Lvl2

      8:05

    • 58.

      2.12 Moving Data Add Row w ListObject

      15:46

    • 59.

      3.1 Quoting Tool Project - Intro

      3:41

    • 60.

      3.2.1 Quote Tool - Create Folder

      13:01

    • 61.

      3.2.2 Quote Tool - Check and Open Folder

      7:20

    • 62.

      3.3.1 Quote Tool - Add Line UI Setup

      3:24

    • 63.

      3.3.2 Quote Tool - Add Line New List Row Part 1

      13:14

    • 64.

      3.3.3 Quote Tool - Item Data Lookup

      10:43