Download Udemy - Automate Data Processing and Transformations with Excel VBA torrent

Udemy - Automate Data Processing and Transformations with Excel VBA

Torrent:

Udemy - Automate Data Processing and Transformations with Excel VBA

VPN:

Downloading torrents is getting riskier every day. Use a VPN to make yourself hidden while downloading torrents.
By using a VPN , your ISP and Government Agencies will not be able to spy on you, neither would they be able to track your online activity!

Description:

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

Downloads:

Category:

Other /Tutorials

Size:

1.2 GB

Show Files »

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

Get Bonus Downloads Here.url (0.2 KB)

~Get Your Files Here !

1. Overview

1. Course Overview.mp4 (10.7 MB)
2. 1D Arrays Refresher.mp4 (37.9 MB)
3. 2D Arrays Refresher.mp4 (23.1 MB)
4. Conventions Used.html (1.8 KB)
5. VBA Editor Introduction (Optional).mp4 (17.5 MB)

Resources

02 - Objects

Objects Overview (Code).xlsm (16.5 KB)
Objects Overview (No Code).xlsm (11.2 KB)
TestWB.xlsx (8.6 KB)

03 - Get Data

Data

AirPassengers.csv (1.7 KB)
Dataset1.xlsx (9.0 KB)
Titanic.csv (105.7 KB)

Get Data (code).xlsm (18.6 KB)
Get Data (no code).xlsm (11.5 KB)
WBScrape (code).xlsm (20.0 KB)
WBScrape (no code).xlsm (16.9 KB)

04 - Transform Functions

Transform Functions (Code).xlsm (33.3 KB)
Transform Functions (No Code).xlsm (28.2 KB)

05 - Header Index

Header Index (Code).xlsm (34.7 KB)
Header Index (No Code).xlsm (31.2 KB)

06 _ ERP Project

Data Output and Validation.pdf (79.6 KB)
ERP Project (Code).xlsm (36.3 KB)
ERP Project (No Code).xlsm (34.9 KB)
ERP Upload Requirements.pdf (39.6 KB)

Project Data

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)

Project Final Output (For Validation).xlsx (67.9 KB)

Beginnner VBA Quick Start.xlsm (35.4 KB)

2. Excel VBA Overview

1. Classes & Objects Overview.mp4 (4.9 MB)
2. Creating Objects.mp4 (60.0 MB)
3. Excel Objects Part 1.mp4 (3.7 MB)
4. Excel Objects Part 2.mp4 (55.3 MB)
5. Excel Objects Part 3.mp4 (5.3 MB)

3. Get Data

1. Data Structures.mp4 (4.0 MB)
2. Files, Folders, & Paths.mp4 (16.5 MB)
3. Last Row.mp4 (23.0 MB)
4. Last Column.mp4 (15.1 MB)
5. Get Data.mp4 (64.5 MB)
6. Export Data.mp4 (33.4 MB)
7. Workbook Scrape.mp4 (32.0 MB)

4. Transform Functions

1. Overview.mp4 (6.7 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. Absolute Values.mp4 (18.9 MB)
3. Sum Columns.mp4 (35.1 MB)
4. Add Columns.mp4 (16.7 MB)
5. Math Part 1.mp4 (42.4 MB)
6. Math Part 2.mp4 (65.4 MB)
7. Compare.mp4 (49.5 MB)
8. Copy Column.mp4 (45.3 MB)
9. Fill Column.mp4 (59.7 MB)

5. Header Index

1. Scalar.mp4 (32.0 MB)
2. Arrays.mp4 (30.4 MB)
3. Update Transform Functions.mp4 (38.1 MB)

6. ERP Project

1. Project Overview.mp4 (8.2 MB)
2. Project Libraries.html (0.4 KB)
3. Project Code 1.mp4 (45.9 MB)
4. Project Code 2.mp4 (28.8 MB)
5. Project Code 3.mp4 (37.4 MB)
6. Project Code 4.mp4 (28.2 MB)

Bonus Resources.txt (0.4 KB)

files

Added:

2024-04-11 18:14:33

Language:

English

Peers:

Seeders : 6 , Leechers : 7

Tags:

Business Excel VBA Udemy

Release name:

Udemy - Automate Data Processing and Transformations with Excel VBA

Trackers:

udp://tracker.torrent.eu.org:451/announce

udp://tracker.tiny-vps.com:6969/announce

http://tracker.foreverpirates.co:80/announce

udp://tracker.cyberia.is:6969/announce

udp://exodus.desync.com:6969/announce

udp://explodie.org:6969/announce

udp://tracker.opentrackr.org:1337/announce

udp://9.rarbg.to:2780/announce

udp://tracker.internetwarriors.net:1337/announce

udp://ipv4.tracker.harry.lu:80/announce

udp://open.stealth.si:80/announce

udp://9.rarbg.to:2900/announce

udp://9.rarbg.me:2720/announce

udp://opentor.org:2710/announce

Download:

Udemy - Automate Data Processing and Transformations with Excel VBA