Udemy - Automate Data Processing and Transformations with Excel VBA

seeders: 6
leechers: 7
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

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)

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



Download torrent
1.2 GB
seeders:6
leechers:7
Udemy - Automate Data Processing and Transformations with Excel VBA

Trackers

tracker name
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
µTorrent compatible trackers list

Download torrent
1.2 GB
seeders:6
leechers:7
Udemy - Automate Data Processing and Transformations with Excel VBA

Torrent hash: 9C4BBBD0B0B94C605CB93396CD86B19A46BCBA5E