Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Excel VBA
Intro to Mammoth Interactive
00 About Mammoth Interactive (1:05)
01 How to Learn Online Effectively (13:39)
Course Intro
Intermediate Course Overview (2:50)
12 Introduction to Loops
12.00 Topics Overview (0:57)
12.01 Single Loop (5:59)
12.02 Double Loop (5:14)
12.03 Triple Loop (6:24)
12.04 Do While Loop (5:34)
12.05 Build A Commission Table (5:33)
Source Files
13 Loop Projects
13.00 Topics Overview (1:40)
13.01 Loop Through Defined Range (3:37)
13.02 Loop Through Entire Column (3:29)
13.03 Do Until Loop (3:22)
13.04 Use Step To Increment (4:22)
13.05 Build A Pattern Project (4:49)
13.06 How To Sort (5:32)
13.07 Sort By Related Data (8:15)
13.08 Delete Duplicate Values (6:10)
Source Files
14 String Manipulation
14.00 Topics Overview (1:28)
14.01 Join Strings (3:13)
14.02 Extract Substrings From Left Or Right (3:07)
14.03 Extract Substring At Middle (4:12)
14.04 Get Length Of A String (2:40)
14.05 Get Substring Position (3:16)
14.06 How To Split Strings (4:56)
14.07 Reverse Characters (4:10)
14.09 Count Words In A Range (8:17)
14.08 Change String Casing (3:28)
Source Files
15 Build Custom Functions
15.00 Topics Overview (1:19)
15.01 Make And Use Your Own Function (6:33)
15.02 Pass Arguments To A Function (7:43)
15.03 Custom Calculator Function (6:22)
Source Files
16 Build Arrays
16.00 Topics Overview (1:18)
16.01 One Dimensional Array (5:46)
16.02 Two Dimensional Array (6:25)
16.03 Change Array Size (4:54)
16.04 Build An Array (5:09)
16.05 Populate Row With Array (3:21)
16.06 Array Length (6:47)
16.07 Split String Into An Array (4:28)
16.08 Join Array Into A String (3:49)
Source Files
17 Work with Dates
17.00 Topics Overview (1:12)
17.01 Delay A Procedure (4:12)
17.02 Schedule A Procedure (4:18)
17.03 Count Years (5:20)
17.04 Count Days Between Dates (2:41)
17.05 Count Weekdays Between Dates (4:51)
17.06 Sort Dates (6:27)
Source Files
18 Application Object
18.00 Topics Overview (1:36)
18.01 How To Access Excel Functions (4:28)
18.02 Disable Screen Updating (3:19)
18.03 Disable Alerts (3:38)
18.04 Show Progress Of Macro (5:36)
18.05 Read Data From A File (6:35)
18.06 Write Data To A File (5:10)
Source Files
19 VBA Projects
19.00 Topics Overview (0:52)
19.01 Build A Table (4:47)
19.02 Build A Table Of Contents (11:47)
19.03 Build A Table Of Contents 2 (4:42)
19.04 Combine Worksheets (17:42)
19.05 Combine Worksheets By Column (15:48)
Source Files
20 Programming Charts
20.00 Topics Overview (1:20)
20.01 Program A Chart (6:12)
20.03 Delete Charts Programatically (2:19)
20.02 Program An Embedded Chart (4:59)
Source Files
16.07 Split String Into An Array
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience