| 001 Intro to Data Amalgamation.en.srt | 1.8 KB | ||
| 001 Intro to Data Amalgamation.mp4 | 9.5 MB | ||
| 001 Introduction to data formatting and cleansing.en.srt | 4.2 KB | ||
| 001 Introduction to data formatting and cleansing.mp4 | 44.7 MB | ||
| 001 Introduction.en.srt | 2.6 KB | ||
| 001 Introduction.mp4 | 35.7 MB | ||
| 001 The Problem Brief.en.srt | 2.4 KB | ||
| 001 The Problem Brief.mp4 | 16.9 MB | ||
| 001 What can I automate_.en.srt | 3.9 KB | ||
| 001 What can I automate_.mp4 | 25.3 MB | ||
| 002 Basic WorkSheet Automation.en.srt | 3.4 KB | ||
| 002 Basic WorkSheet Automation.mp4 | 17.9 MB | ||
| 002 Consolidate Data into a Single Workbook.en.srt | 1.5 KB | ||
| 002 Consolidate Data into a Single Workbook.mp4 | 9.1 MB | ||
| 002 How to split columns out into separate columns + Challenge question.en.srt | 3.1 KB | ||
| 002 How to split columns out into separate columns + Challenge question.mp4 | 35.4 MB | ||
| 002 Understand the domain BEFORE automation.en.srt | 3.2 KB | ||
| 002 Understand the domain BEFORE automation.mp4 | 62.4 MB | ||
| 003 Communicating with Someone Else's Software.en.srt | 4.1 KB | ||
| 003 Communicating with Someone Else's Software.mp4 | 29.4 MB | ||
| 003 Create Master Worksheet and Reference Appropriate Columns.en.srt | 4 KB | ||
| 003 Create Master Worksheet and Reference Appropriate Columns.mp4 | 29.8 MB | ||
| 003 Split Names into 'Name' and 'Surname' columns - Answer to challenge.en.srt | 3.3 KB | ||
| 003 Split Names into 'Name' and 'Surname' columns - Answer to challenge.mp4 | 53.6 MB | ||
| 003 Understand KML File Format.en.srt | 5.3 KB | ||
| 003 Understand KML File Format.mp4 | 70.7 MB | ||
| 004 Combining columns with string concat.en.srt | 1.9 KB | ||
| 004 Combining columns with string concat.mp4 | 18.7 MB | ||
| 004 Setup the VBA Automation Environment.en.srt | 2.1 KB | ||
| 004 Setup the VBA Automation Environment.mp4 | 37.3 MB | ||
| 004 Use Lookup to get the Required Data.en.srt | 1.5 KB | ||
| 004 Use Lookup to get the Required Data.mp4 | 9.7 MB | ||
| 004 What are we aiming for_.en.srt | 1.1 KB | ||
| 004 What are we aiming for_.mp4 | 6.9 MB | ||
| 005 Creating a special .xlsm workbook.en.srt | 1 KB | ||
| 005 Creating a special .xlsm workbook.mp4 | 8.1 MB | ||
| 005 Filtering List by Name.en.srt | 716.8 B | ||
| 005 Filtering List by Name.mp4 | 7.6 MB | ||
| 005 Lookup - Check Your Answer.en.srt | 819.2 B | ||
| 005 Lookup - Check Your Answer.mp4 | 6.5 MB | ||
| 005 Using Excel Built-ins to Clean Data set.en.srt | 2.6 KB | ||
| 005 Using Excel Built-ins to Clean Data set.mp4 | 32.2 MB | ||
| 006 Creating a list of unique names #1.en.srt | 2.4 KB | ||
| 006 Creating a list of unique names #1.mp4 | 27.5 MB | ||
| 006 Handling Data Types - Time to String.en.srt | 1.3 KB | ||
| 006 Handling Data Types - Time to String.mp4 | 16.5 MB | ||
| 006 Setting up the VBA Environment.en.srt | 3.6 KB | ||
| 006 Setting up the VBA Environment.mp4 | 17.7 MB | ||
| 007 Creating a list of unique names #2.en.srt | 1.7 KB | ||
| 007 Creating a list of unique names #2.mp4 | 9.4 MB | ||
| 007 How to Access a Sheet in your Workbook.en.srt | 3.6 KB | ||
| 007 How to Access a Sheet in your Workbook.mp4 | 21.7 MB | ||
| 007 Start Writing Some Automation Code.en.srt | 3.2 KB | ||
| 007 Start Writing Some Automation Code.mp4 | 20.6 MB | ||
| 008 Custom buillt in function.en.srt | 2.9 KB | ||
| 008 Custom buillt in function.mp4 | 26.9 MB | ||
| 008 How to get Data from each Row (Use While Loop).en.srt | 8.7 KB | ||
| 008 How to get Data from each Row (Use While Loop).mp4 | 49.7 MB | ||
| 008 Using Objects and Functions to make life easier.en.srt | 11.8 KB | ||
| 008 Using Objects and Functions to make life easier.mp4 | 85.7 MB | ||
| 009 Custom function - Count Unique Elements in Range.en.srt | 5.6 KB | ||
| 009 Custom function - Count Unique Elements in Range.mp4 | 35.7 MB | ||
| 009 Debug some code!.en.srt | 4.3 KB | ||
| 009 Debug some code!.mp4 | 33.3 MB | ||
| 009 Writing a Function.en.srt | 3.3 KB | ||
| 009 Writing a Function.mp4 | 26.1 MB | ||
| 010 Custom function - Array Formula Unique Elements in Range.en.srt | 8.8 KB | ||
| 010 Custom function - Array Formula Unique Elements in Range.mp4 | 70.4 MB | ||
| 010 Don't be afraid to hit Stack Overflow!.en.srt | 11.7 KB | ||
| 010 Don't be afraid to hit Stack Overflow!.mp4 | 90.5 MB | ||
| 010 Functions and how best to use them.en.srt | 1.8 KB | ||
| 010 Functions and how best to use them.mp4 | 16.6 MB | ||
| 011 Creating a HTTP POST request.en.srt | 10.7 KB | ||
| 011 Creating a HTTP POST request.mp4 | 102.9 MB | ||
| 011 How to add rows based on rules (SUMPRODUCT).en.srt | 3.7 KB | ||
| 011 How to add rows based on rules (SUMPRODUCT).mp4 | 26.4 MB | ||
| 011 Writing to File.en.srt | 3.9 KB | ||
| 011 Writing to File.mp4 | 44.1 MB | ||
| 012 Receiving the JSON response back.en.srt | 4 KB | ||
| 012 Receiving the JSON response back.mp4 | 42.9 MB | ||
| 012 String Concatenation and Special Characters.en.srt | 1.7 KB | ||
| 012 String Concatenation and Special Characters.mp4 | 24.8 MB | ||
| 012 Understanding the SUMPRODUCT Formula.en.srt | 2.5 KB | ||
| 012 Understanding the SUMPRODUCT Formula.mp4 | 16.1 MB | ||
| 013 Find and Replace Notepad Tricks.en.srt | 3.3 KB | ||
| 013 Find and Replace Notepad Tricks.mp4 | 38.6 MB | ||
| 013 Importing 3rd party libraries .BAS files.en.srt | 819.2 B | ||
| 013 Importing 3rd party libraries .BAS files.mp4 | 9.5 MB | ||
| 014 Appending Site Information to our File.en.srt | 5.5 KB | ||
| 014 Appending Site Information to our File.mp4 | 75.2 MB | ||
| 014 Parsing JSON response.en.srt | 10 KB | ||
| 014 Parsing JSON response.mp4 | 77.3 MB | ||
| 015 Auto Populating Excel Database.en.srt | 6.5 KB | ||
| 015 Auto Populating Excel Database.mp4 | 60.4 MB | ||
| 015 Using our Collection of Objects.en.srt | 5.1 KB | ||
| 015 Using our Collection of Objects.mp4 | 75.6 MB | ||
| 016 The Final Test in Google Earth!.en.srt | 1 KB | ||
| 016 The Final Test in Google Earth!.mp4 | 15 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 100 total files | |||
How to Automate a Huge Workload in Excel
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 49 lectures (3h 9m) | Size: 1.66 GB
Teaching you how to automate data collection, manipulation and connect to websites using Excel
What you'll learn:
Get Excel to do repetitive tasks for you
Excel VBA
Automation
APIs
JSON
Simplify writing code
Requirements
Microsoft Excel (any version)
Willingness to persevere
Description
How to automate a huge workload in Excel. Where you will learn how to work with Excel once, to complete repetive tasks many times, learn how to simplify writing VBA macro code and cover more advanced topics actually integrating your Excel workflow with other third party software, such as internet web pages.
I developed this course having spent many years working on commercial projects that all use Excel in one way or another. I have a masters degree in Engineering. Have worked in small start-ups and large corporate entities. I have over 12 years of relevant commercial experience and have created a number of successful courses on Udemy with over 7500 active students.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 12.1 MB | CryOrDie2 | 1 week | 46 | 4 | |
| 12.1 MB | CryOrDie2 | 1 week | 22 | 0 | |
| 1.1 GB | freecoursewb | 1 week | 0 | 0 | |
| 770 MB | freecoursewb | 1 week | 0 | 0 | |
| 291.1 MB | freecoursewb | 1 week | 51 | 7 |
All Comments