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
Intermediate Course Overview
Download
Complete and Continue