~Get Your Files Here !/01 Introduction/001 Introduction.mp435.71MB
~Get Your Files Here !/02 Combine Data From Multiple Sources Automatically/001 Intro to Data Amalgamation.mp49.45MB
~Get Your Files Here !/02 Combine Data From Multiple Sources Automatically/002 Consolidate Data into a Single Workbook.mp49.11MB
~Get Your Files Here !/02 Combine Data From Multiple Sources Automatically/003 Create Master Worksheet and Reference Appropriate Columns.mp429.81MB
~Get Your Files Here !/02 Combine Data From Multiple Sources Automatically/004 Use Lookup to get the Required Data.mp49.68MB
~Get Your Files Here !/02 Combine Data From Multiple Sources Automatically/005 Lookup - Check Your Answer.mp46.49MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/001 Introduction to data formatting and cleansing.mp444.71MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/002 How to split columns out into separate columns + Challenge question.mp435.42MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/003 Split Names into 'Name' and 'Surname' columns - Answer to challenge.mp453.56MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/004 Combining columns with string concat.mp418.75MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/005 Filtering List by Name.mp47.61MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/006 Creating a list of unique names #1.mp427.52MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/007 Creating a list of unique names #2.mp49.38MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/008 Custom buillt in function.mp426.94MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/009 Custom function - Count Unique Elements in Range.mp435.67MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/010 Custom function - Array Formula Unique Elements in Range.mp470.41MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/011 How to add rows based on rules (SUMPRODUCT).mp426.38MB
~Get Your Files Here !/03 F1 Data Cleaning, Formatting, Manipulation and Filtering/012 Understanding the SUMPRODUCT Formula.mp416.06MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/001 What can I automate_.mp425.29MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/002 Basic WorkSheet Automation.mp417.87MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/003 Communicating with Someone Else's Software.mp429.36MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/004 What are we aiming for_.mp46.88MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/005 Creating a special .xlsm workbook.mp48.14MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/006 Setting up the VBA Environment.mp417.73MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/007 How to Access a Sheet in your Workbook.mp421.67MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/008 How to get Data from each Row (Use While Loop).mp449.72MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/009 Writing a Function.mp426.08MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/010 Don't be afraid to hit Stack Overflow!.mp490.48MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/011 Creating a HTTP POST request.mp4102.91MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/012 Receiving the JSON response back.mp442.86MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/013 Importing 3rd party libraries .BAS files.mp49.51MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/014 Parsing JSON response.mp477.31MB
~Get Your Files Here !/04 Vehicle Number Plate Lookup Automation Project/015 Auto Populating Excel Database.mp460.39MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/001 The Problem Brief.mp416.91MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/002 Understand the domain BEFORE automation.mp462.42MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/003 Understand KML File Format.mp470.67MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/004 Setup the VBA Automation Environment.mp437.25MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/005 Using Excel Built-ins to Clean Data set.mp432.18MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/006 Handling Data Types - Time to String.mp416.5MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/007 Start Writing Some Automation Code.mp420.59MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/008 Using Objects and Functions to make life easier.mp485.68MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/009 Debug some code!.mp433.33MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/010 Functions and how best to use them.mp416.6MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/011 Writing to File.mp444.09MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/012 String Concatenation and Special Characters.mp424.77MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/013 Find and Replace Notepad Tricks.mp438.6MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/014 Appending Site Information to our File.mp475.23MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/015 Using our Collection of Objects.mp475.62MB
~Get Your Files Here !/05 Visualise Data on Google Earth Map/016 The Final Test in Google Earth!.mp415.01MB