|
|
001 Intro to Data Amalgamation.en.srt
|
SRT
|
1.8 KB
|
|
|
001 Intro to Data Amalgamation.mp4
|
MP4
|
9.5 MB
|
|
|
001 Introduction to data formatting and cleansing.en.srt
|
SRT
|
4.2 KB
|
|
|
001 Introduction to data formatting and cleansing.mp4
|
MP4
|
44.7 MB
|
|
|
001 Introduction.en.srt
|
SRT
|
2.6 KB
|
|
|
001 Introduction.mp4
|
MP4
|
35.7 MB
|
|
|
001 The Problem Brief.en.srt
|
SRT
|
2.4 KB
|
|
|
001 The Problem Brief.mp4
|
MP4
|
16.9 MB
|
|
|
001 What can I automate_.en.srt
|
SRT
|
3.9 KB
|
|
|
001 What can I automate_.mp4
|
MP4
|
25.3 MB
|
|
|
002 Basic WorkSheet Automation.en.srt
|
SRT
|
3.4 KB
|
|
|
002 Basic WorkSheet Automation.mp4
|
MP4
|
17.9 MB
|
|
|
002 Consolidate Data into a Single Workbook.en.srt
|
SRT
|
1.5 KB
|
|
|
002 Consolidate Data into a Single Workbook.mp4
|
MP4
|
9.1 MB
|
|
|
002 How to split columns out into separate columns + Challenge question.en.srt
|
SRT
|
3.1 KB
|
|
|
002 How to split columns out into separate columns + Challenge question.mp4
|
MP4
|
35.4 MB
|
|
|
002 Understand the domain BEFORE automation.en.srt
|
SRT
|
3.2 KB
|
|
|
002 Understand the domain BEFORE automation.mp4
|
MP4
|
62.4 MB
|
|
|
003 Communicating with Someone Else's Software.en.srt
|
SRT
|
4.1 KB
|
|
|
003 Communicating with Someone Else's Software.mp4
|
MP4
|
29.4 MB
|
|
|
003 Create Master Worksheet and Reference Appropriate Columns.en.srt
|
SRT
|
4 KB
|
|
|
003 Create Master Worksheet and Reference Appropriate Columns.mp4
|
MP4
|
29.8 MB
|
|
|
003 Split Names into 'Name' and 'Surname' columns - Answer to challenge.en.srt
|
SRT
|
3.3 KB
|
|
|
003 Split Names into 'Name' and 'Surname' columns - Answer to challenge.mp4
|
MP4
|
53.6 MB
|
|
|
003 Understand KML File Format.en.srt
|
SRT
|
5.3 KB
|
|
|
003 Understand KML File Format.mp4
|
MP4
|
70.7 MB
|
|
|
004 Combining columns with string concat.en.srt
|
SRT
|
1.9 KB
|
|
|
004 Combining columns with string concat.mp4
|
MP4
|
18.7 MB
|
|
|
004 Setup the VBA Automation Environment.en.srt
|
SRT
|
2.1 KB
|
|
|
004 Setup the VBA Automation Environment.mp4
|
MP4
|
37.3 MB
|
|
|
004 Use Lookup to get the Required Data.en.srt
|
SRT
|
1.5 KB
|
|
|
004 Use Lookup to get the Required Data.mp4
|
MP4
|
9.7 MB
|
|
|
004 What are we aiming for_.en.srt
|
SRT
|
1.1 KB
|
|
|
004 What are we aiming for_.mp4
|
MP4
|
6.9 MB
|
|
|
005 Creating a special .xlsm workbook.en.srt
|
SRT
|
1 KB
|
|
|
005 Creating a special .xlsm workbook.mp4
|
MP4
|
8.1 MB
|
|
|
005 Filtering List by Name.en.srt
|
SRT
|
716.8 B
|
|
|
005 Filtering List by Name.mp4
|
MP4
|
7.6 MB
|
|
|
005 Lookup - Check Your Answer.en.srt
|
SRT
|
819.2 B
|
|
|
005 Lookup - Check Your Answer.mp4
|
MP4
|
6.5 MB
|
|
|
005 Using Excel Built-ins to Clean Data set.en.srt
|
SRT
|
2.6 KB
|
|
|
005 Using Excel Built-ins to Clean Data set.mp4
|
MP4
|
32.2 MB
|
|
|
006 Creating a list of unique names #1.en.srt
|
SRT
|
2.4 KB
|
|
|
006 Creating a list of unique names #1.mp4
|
MP4
|
27.5 MB
|
|
|
006 Handling Data Types - Time to String.en.srt
|
SRT
|
1.3 KB
|
|
|
006 Handling Data Types - Time to String.mp4
|
MP4
|
16.5 MB
|
|
|
006 Setting up the VBA Environment.en.srt
|
SRT
|
3.6 KB
|
|
|
006 Setting up the VBA Environment.mp4
|
MP4
|
17.7 MB
|
|
|
007 Creating a list of unique names #2.en.srt
|
SRT
|
1.7 KB
|
|
|
007 Creating a list of unique names #2.mp4
|
MP4
|
9.4 MB
|
|
|
007 How to Access a Sheet in your Workbook.en.srt
|
SRT
|
3.6 KB
|
|
|
007 How to Access a Sheet in your Workbook.mp4
|
MP4
|
21.7 MB
|
|
|
007 Start Writing Some Automation Code.en.srt
|
SRT
|
3.2 KB
|
|
|
007 Start Writing Some Automation Code.mp4
|
MP4
|
20.6 MB
|
|
|
008 Custom buillt in function.en.srt
|
SRT
|
2.9 KB
|
|
|
008 Custom buillt in function.mp4
|
MP4
|
26.9 MB
|
|
|
008 How to get Data from each Row (Use While Loop).en.srt
|
SRT
|
8.7 KB
|
|
|
008 How to get Data from each Row (Use While Loop).mp4
|
MP4
|
49.7 MB
|
|
|
008 Using Objects and Functions to make life easier.en.srt
|
SRT
|
11.8 KB
|
|
|
008 Using Objects and Functions to make life easier.mp4
|
MP4
|
85.7 MB
|
|
|
009 Custom function - Count Unique Elements in Range.en.srt
|
SRT
|
5.6 KB
|
|
|
009 Custom function - Count Unique Elements in Range.mp4
|
MP4
|
35.7 MB
|
|
|
009 Debug some code!.en.srt
|
SRT
|
4.3 KB
|
|
|
009 Debug some code!.mp4
|
MP4
|
33.3 MB
|
|
|
009 Writing a Function.en.srt
|
SRT
|
3.3 KB
|
|
|
009 Writing a Function.mp4
|
MP4
|
26.1 MB
|
|
|
010 Custom function - Array Formula Unique Elements in Range.en.srt
|
SRT
|
8.8 KB
|
|
|
010 Custom function - Array Formula Unique Elements in Range.mp4
|
MP4
|
70.4 MB
|
|
|
010 Don't be afraid to hit Stack Overflow!.en.srt
|
SRT
|
11.7 KB
|
|
|
010 Don't be afraid to hit Stack Overflow!.mp4
|
MP4
|
90.5 MB
|
|
|
010 Functions and how best to use them.en.srt
|
SRT
|
1.8 KB
|
|
|
010 Functions and how best to use them.mp4
|
MP4
|
16.6 MB
|
|
|
011 Creating a HTTP POST request.en.srt
|
SRT
|
10.7 KB
|
|
|
011 Creating a HTTP POST request.mp4
|
MP4
|
102.9 MB
|
|
|
011 How to add rows based on rules (SUMPRODUCT).en.srt
|
SRT
|
3.7 KB
|
|
|
011 How to add rows based on rules (SUMPRODUCT).mp4
|
MP4
|
26.4 MB
|
|
|
011 Writing to File.en.srt
|
SRT
|
3.9 KB
|
|
|
011 Writing to File.mp4
|
MP4
|
44.1 MB
|
|
|
012 Receiving the JSON response back.en.srt
|
SRT
|
4 KB
|
|
|
012 Receiving the JSON response back.mp4
|
MP4
|
42.9 MB
|
|
|
012 String Concatenation and Special Characters.en.srt
|
SRT
|
1.7 KB
|
|
|
012 String Concatenation and Special Characters.mp4
|
MP4
|
24.8 MB
|
|
|
012 Understanding the SUMPRODUCT Formula.en.srt
|
SRT
|
2.5 KB
|
|
|
012 Understanding the SUMPRODUCT Formula.mp4
|
MP4
|
16.1 MB
|
|
|
013 Find and Replace Notepad Tricks.en.srt
|
SRT
|
3.3 KB
|
|
|
013 Find and Replace Notepad Tricks.mp4
|
MP4
|
38.6 MB
|
|
|
013 Importing 3rd party libraries .BAS files.en.srt
|
SRT
|
819.2 B
|
|
|
013 Importing 3rd party libraries .BAS files.mp4
|
MP4
|
9.5 MB
|
|
|
014 Appending Site Information to our File.en.srt
|
SRT
|
5.5 KB
|
|
|
014 Appending Site Information to our File.mp4
|
MP4
|
75.2 MB
|
|
|
014 Parsing JSON response.en.srt
|
SRT
|
10 KB
|
|
|
014 Parsing JSON response.mp4
|
MP4
|
77.3 MB
|
|
|
015 Auto Populating Excel Database.en.srt
|
SRT
|
6.5 KB
|
|
|
015 Auto Populating Excel Database.mp4
|
MP4
|
60.4 MB
|
|
|
015 Using our Collection of Objects.en.srt
|
SRT
|
5.1 KB
|
|
|
015 Using our Collection of Objects.mp4
|
MP4
|
75.6 MB
|
|
|
016 The Final Test in Google Earth!.en.srt
|
SRT
|
1 KB
|
|
|
016 The Final Test in Google Earth!.mp4
|
MP4
|
15 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
