| 1. Classes & Objects Overview.mp4 | 4.9 MB | ||
| 1. Course Overview.mp4 | 10.7 MB | ||
| 1. Data Structures.mp4 | 4 MB | ||
| 1. Overview.mp4 | 6.7 MB | ||
| 1. Project Overview.mp4 | 8.2 MB | ||
| 1. Scalar.mp4 | 32 MB | ||
| 10. Fill Down.mp4 | 28.3 MB | ||
| 11. Swap Columns.mp4 | 19.9 MB | ||
| 12. Move Column.mp4 | 33.1 MB | ||
| 13. Select Columns.mp4 | 28.6 MB | ||
| 14. Stack.mp4 | 51.1 MB | ||
| 15. Transpose.mp4 | 25.2 MB | ||
| 2. 1D Arrays Refresher.mp4 | 37.9 MB | ||
| 2. Absolute Values.mp4 | 18.9 MB | ||
| 2. Arrays.mp4 | 30.4 MB | ||
| 2. Creating Objects.mp4 | 60 MB | ||
| 2. Files, Folders, & Paths.mp4 | 16.5 MB | ||
| 2. Project Libraries.html | 409.6 B | ||
| 2000 Income Statement.xlsx | 18.2 KB | ||
| 2001 Income Statement.xlsx | 18.3 KB | ||
| 2002 Income Statement.xlsx | 18.4 KB | ||
| 2003 Income Statement.xlsx | 18.6 KB | ||
| 2004 Income Statement.xlsx | 18.7 KB | ||
| 2005 Income Statement.xlsx | 18.7 KB | ||
| 2006 Income Statement.xlsx | 18.7 KB | ||
| 2007 Income Statement.xlsx | 18.7 KB | ||
| 2008 Income Statement.xlsx | 18.7 KB | ||
| 2009 Income Statement.xlsx | 18.8 KB | ||
| 2010 Income Statement.xlsx | 18.7 KB | ||
| 2011 Income Statement.xlsx | 18.7 KB | ||
| 2012 Income Statement.xlsx | 18.8 KB | ||
| 2013 Income Statement.xlsx | 18.7 KB | ||
| 2014 Income Statement.xlsx | 18.7 KB | ||
| 2015 Income Statement.xlsx | 18.8 KB | ||
| 2016 Income Statement.xlsx | 18.8 KB | ||
| 2017 Income Statement.xlsx | 18.7 KB | ||
| 2018 Income Statement.xlsx | 18.7 KB | ||
| 2019 Income Statement.xlsx | 18.8 KB | ||
| 2020 Income Statement.xlsx | 18.8 KB | ||
| 3. 2D Arrays Refresher.mp4 | 23.1 MB | ||
| 3. Excel Objects Part 1.mp4 | 3.7 MB | ||
| 3. Last Row.mp4 | 23 MB | ||
| 3. Project Code 1.mp4 | 45.9 MB | ||
| 3. Sum Columns.mp4 | 35.1 MB | ||
| 3. Update Transform Functions.mp4 | 38.1 MB | ||
| 4. Add Columns.mp4 | 16.7 MB | ||
| 4. Conventions Used.html | 1.8 KB | ||
| 4. Excel Objects Part 2.mp4 | 55.3 MB | ||
| 4. Last Column.mp4 | 15.1 MB | ||
| 4. Project Code 2.mp4 | 28.8 MB | ||
| 5. Excel Objects Part 3.mp4 | 5.3 MB | ||
| 5. Get Data.mp4 | 64.5 MB | ||
| 5. Math Part 1.mp4 | 42.4 MB | ||
| 5. Project Code 3.mp4 | 37.4 MB | ||
| 5. VBA Editor Introduction (Optional).mp4 | 17.5 MB | ||
| 6. Export Data.mp4 | 33.4 MB | ||
| 6. Math Part 2.mp4 | 65.4 MB | ||
| 6. Project Code 4.mp4 | 28.2 MB | ||
| 7. Compare.mp4 | 49.5 MB | ||
| 7. Workbook Scrape.mp4 | 32 MB | ||
| 8. Copy Column.mp4 | 45.3 MB | ||
| 9. Fill Column.mp4 | 59.7 MB | ||
| AirPassengers.csv | 1.7 KB | ||
| Beginnner VBA Quick Start.xlsm | 35.4 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Data Output and Validation.pdf | 79.6 KB | ||
| Dataset1.xlsx | 9 KB | ||
| ERP Project (Code).xlsm | 36.3 KB | ||
| ERP Project (No Code).xlsm | 34.9 KB | ||
| ERP Upload Requirements.pdf | 39.6 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Get Data (code).xlsm | 18.6 KB | ||
| Get Data (no code).xlsm | 11.5 KB | ||
| Header Index (Code).xlsm | 34.7 KB | ||
| Header Index (No Code).xlsm | 31.2 KB | ||
| Objects Overview (Code).xlsm | 16.5 KB | ||
| Objects Overview (No Code).xlsm | 11.2 KB | ||
| Project Final Output (For Validation).xlsx | 67.9 KB | ||
| TestWB.xlsx | 8.6 KB | ||
| Titanic.csv | 105.7 KB | ||
| Transform Functions (Code).xlsm | 33.3 KB | ||
| Transform Functions (No Code).xlsm | 28.2 KB | ||
| WBScrape (code).xlsm | 20 KB | ||
| WBScrape (no code).xlsm | 16.9 KB | ||
| ▲ 84 total files | |||
Automate Data Processing & Transformations with Excel VBA
https://CourseWikia.com
Published 4/2024
Created by Carl Walenciak
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 41 Lectures ( 3h 18m ) | Size: 1.2 GB
Work directly in VBA Editor to develop code that will automate your data processing and transformations.
What you'll learn:
Importing and exporting data
Work with data directly in the Excel VBA Editor
Develop a data preperation workflow
Learn how to structure data for efficient transformation.
Requirements:
Access to Excel.
Beginners knowledge of Excel VBA
Understanding of Subroutines, Functions, Variables, If Statements and For Loops
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 707.7 MB | freecoursewb | 1 week | 17 | 2 | |
| 1.5 GB | freecoursewb | 2 months | 9 | 4 | |
|
Udemy - Ab-620 - Microsoft Copilot Studio and Power Automate Exam Prep Posted by
freecoursewb in Other
|
1.3 GB | freecoursewb | 2 months | 2 | 5 |
|
Udemy - AI-Powered ISO Audits 2026 - Automate Compliance with ChatGPT Posted by
freecoursewb in Other
|
1.2 GB | freecoursewb | 2 months | 2 | 2 |
| 1 GB | freecoursewb | 3 months | 10 | 10 |
All Comments