[ CourseWikia.com ] Udemy - Automate Data Processing and Transformations with Excel VBA Torrent Download

Description

[ CourseWikia.com ] Automate Data Processing & Transformations with Excel VBA

If You Need More Stuff, kindly Visit and Support Us -->> 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

If You Need More Stuff, kindly Visit and Support Us -->> https://FreeCourseWeb.com

Get More Tutorials and Support Us -->> https://DevCourseWeb.com

We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...

File list

[ CourseWikia.com ] Udemy - Automate Data Processing and Transformations with Excel VBA
~Get Your Files Here !/1. Overview/1. Course Overview.mp4 10.7 MB
~Get Your Files Here !/1. Overview/2. 1D Arrays Refresher.mp4 37.9 MB
~Get Your Files Here !/1. Overview/3. 2D Arrays Refresher.mp4 23.1 MB
~Get Your Files Here !/1. Overview/4. Conventions Used.html 1.8 KB
~Get Your Files Here !/1. Overview/5. VBA Editor Introduction (Optional).mp4 17.5 MB
~Get Your Files Here !/1. Overview/Resources/02 - Objects/Objects Overview (Code).xlsm 16.5 KB
~Get Your Files Here !/1. Overview/Resources/02 - Objects/Objects Overview (No Code).xlsm 11.2 KB
~Get Your Files Here !/1. Overview/Resources/02 - Objects/TestWB.xlsx 8.6 KB
~Get Your Files Here !/1. Overview/Resources/03 - Get Data/Data/AirPassengers.csv 1.7 KB
~Get Your Files Here !/1. Overview/Resources/03 - Get Data/Data/Dataset1.xlsx 9 KB
~Get Your Files Here !/1. Overview/Resources/03 - Get Data/Data/Titanic.csv 105.7 KB
~Get Your Files Here !/1. Overview/Resources/03 - Get Data/Get Data (code).xlsm 18.6 KB
~Get Your Files Here !/1. Overview/Resources/03 - Get Data/Get Data (no code).xlsm 11.5 KB
~Get Your Files Here !/1. Overview/Resources/03 - Get Data/WBScrape (code).xlsm 20 KB
~Get Your Files Here !/1. Overview/Resources/03 - Get Data/WBScrape (no code).xlsm 16.9 KB
~Get Your Files Here !/1. Overview/Resources/04 - Transform Functions/Transform Functions (Code).xlsm 33.3 KB
~Get Your Files Here !/1. Overview/Resources/04 - Transform Functions/Transform Functions (No Code).xlsm 28.2 KB
~Get Your Files Here !/1. Overview/Resources/05 - Header Index/Header Index (Code).xlsm 34.7 KB
~Get Your Files Here !/1. Overview/Resources/05 - Header Index/Header Index (No Code).xlsm 31.2 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Data Output and Validation.pdf 79.6 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/ERP Project (Code).xlsm 36.3 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/ERP Project (No Code).xlsm 34.9 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/ERP Upload Requirements.pdf 39.6 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2000 Income Statement.xlsx 18.2 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2001 Income Statement.xlsx 18.3 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2002 Income Statement.xlsx 18.4 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2003 Income Statement.xlsx 18.6 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2004 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2005 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2006 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2007 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2008 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2009 Income Statement.xlsx 18.8 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2010 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2011 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2012 Income Statement.xlsx 18.8 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2013 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2014 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2015 Income Statement.xlsx 18.8 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2016 Income Statement.xlsx 18.8 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2017 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2018 Income Statement.xlsx 18.7 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2019 Income Statement.xlsx 18.8 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2020 Income Statement.xlsx 18.8 KB
~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Final Output (For Validation).xlsx 67.9 KB
~Get Your Files Here !/1. Overview/Resources/Beginnner VBA Quick Start.xlsm 35.4 KB
~Get Your Files Here !/2. Excel VBA Overview/1. Classes & Objects Overview.mp4 4.9 MB
~Get Your Files Here !/2. Excel VBA Overview/2. Creating Objects.mp4 60 MB
~Get Your Files Here !/2. Excel VBA Overview/3. Excel Objects Part 1.mp4 3.7 MB
~Get Your Files Here !/2. Excel VBA Overview/4. Excel Objects Part 2.mp4 55.3 MB
~Get Your Files Here !/2. Excel VBA Overview/5. Excel Objects Part 3.mp4 5.3 MB
~Get Your Files Here !/3. Get Data/1. Data Structures.mp4 4 MB
~Get Your Files Here !/3. Get Data/2. Files, Folders, & Paths.mp4 16.5 MB
~Get Your Files Here !/3. Get Data/3. Last Row.mp4 23 MB
~Get Your Files Here !/3. Get Data/4. Last Column.mp4 15.1 MB
~Get Your Files Here !/3. Get Data/5. Get Data.mp4 64.5 MB
~Get Your Files Here !/3. Get Data/6. Export Data.mp4 33.4 MB
~Get Your Files Here !/3. Get Data/7. Workbook Scrape.mp4 32 MB
~Get Your Files Here !/4. Transform Functions/1. Overview.mp4 6.7 MB
~Get Your Files Here !/4. Transform Functions/10. Fill Down.mp4 28.3 MB
~Get Your Files Here !/4. Transform Functions/11. Swap Columns.mp4 19.9 MB
~Get Your Files Here !/4. Transform Functions/12. Move Column.mp4 33.1 MB
~Get Your Files Here !/4. Transform Functions/13. Select Columns.mp4 28.6 MB
~Get Your Files Here !/4. Transform Functions/14. Stack.mp4 51.1 MB
~Get Your Files Here !/4. Transform Functions/15. Transpose.mp4 25.2 MB
~Get Your Files Here !/4. Transform Functions/2. Absolute Values.mp4 18.9 MB
~Get Your Files Here !/4. Transform Functions/3. Sum Columns.mp4 35.1 MB
~Get Your Files Here !/4. Transform Functions/4. Add Columns.mp4 16.7 MB
~Get Your Files Here !/4. Transform Functions/5. Math Part 1.mp4 42.4 MB
~Get Your Files Here !/4. Transform Functions/6. Math Part 2.mp4 65.4 MB
~Get Your Files Here !/4. Transform Functions/7. Compare.mp4 49.5 MB
~Get Your Files Here !/4. Transform Functions/8. Copy Column.mp4 45.3 MB
~Get Your Files Here !/4. Transform Functions/9. Fill Column.mp4 59.7 MB
~Get Your Files Here !/5. Header Index/1. Scalar.mp4 32 MB
~Get Your Files Here !/5. Header Index/2. Arrays.mp4 30.4 MB
~Get Your Files Here !/5. Header Index/3. Update Transform Functions.mp4 38.1 MB
~Get Your Files Here !/6. ERP Project/1. Project Overview.mp4 8.2 MB
~Get Your Files Here !/6. ERP Project/2. Project Libraries.html 406 B
~Get Your Files Here !/6. ERP Project/3. Project Code 1.mp4 45.9 MB
~Get Your Files Here !/6. ERP Project/4. Project Code 2.mp4 28.8 MB
~Get Your Files Here !/6. ERP Project/5. Project Code 3.mp4 37.4 MB
~Get Your Files Here !/6. ERP Project/6. Project Code 4.mp4 28.2 MB
~Get Your Files Here !/Bonus Resources.txt 386 B