|  

Automate Data Processing and Transformations with Excel VBA --> [ CourseWikia ]
Size :1.16 GB
Peers : Seeders : 0      Leechers : 0
Added : 6 months ago » by FreeCourseWeb » in Other
Language : English
Last Updated :6 months ago
Info_Hash :9C4BBBD0B0B94C605CB93396CD86B19A46BCBA5E

Torrent File Contents

Automate Data Processing and Transformations with Excel VBA --> [ CourseWikia ]
  Get Bonus Downloads Here.url
  -  181 Bytes

  ~Get Your Files Here !/1. Overview/1. Course Overview.mp4
  -  10.72 MB

  ~Get Your Files Here !/1. Overview/2. 1D Arrays Refresher.mp4
  -  37.91 MB

  ~Get Your Files Here !/1. Overview/3. 2D Arrays Refresher.mp4
  -  23.11 MB

  ~Get Your Files Here !/1. Overview/4. Conventions Used.html
  -  1.85 KB

  ~Get Your Files Here !/1. Overview/5. VBA Editor Introduction (Optional).mp4
  -  17.48 MB

  ~Get Your Files Here !/1. Overview/Resources/02 - Objects/Objects Overview (Code).xlsm
  -  16.54 KB

  ~Get Your Files Here !/1. Overview/Resources/02 - Objects/Objects Overview (No Code).xlsm
  -  11.24 KB

  ~Get Your Files Here !/1. Overview/Resources/02 - Objects/TestWB.xlsx
  -  8.62 KB

  ~Get Your Files Here !/1. Overview/Resources/03 - Get Data/Data/AirPassengers.csv
  -  1.71 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.75 KB

  ~Get Your Files Here !/1. Overview/Resources/03 - Get Data/Get Data (code).xlsm
  -  18.57 KB

  ~Get Your Files Here !/1. Overview/Resources/03 - Get Data/Get Data (no code).xlsm
  -  11.46 KB

  ~Get Your Files Here !/1. Overview/Resources/03 - Get Data/WBScrape (code).xlsm
  -  19.99 KB

  ~Get Your Files Here !/1. Overview/Resources/03 - Get Data/WBScrape (no code).xlsm
  -  16.88 KB

  ~Get Your Files Here !/1. Overview/Resources/04 - Transform Functions/Transform Functions (Code).xlsm
  -  33.26 KB

  ~Get Your Files Here !/1. Overview/Resources/04 - Transform Functions/Transform Functions (No Code).xlsm
  -  28.24 KB

  ~Get Your Files Here !/1. Overview/Resources/05 - Header Index/Header Index (Code).xlsm
  -  34.73 KB

  ~Get Your Files Here !/1. Overview/Resources/05 - Header Index/Header Index (No Code).xlsm
  -  31.23 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Data Output and Validation.pdf
  -  79.62 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.91 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/ERP Upload Requirements.pdf
  -  39.63 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2000 Income Statement.xlsx
  -  18.22 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2001 Income Statement.xlsx
  -  18.25 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2002 Income Statement.xlsx
  -  18.45 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2003 Income Statement.xlsx
  -  18.58 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2004 Income Statement.xlsx
  -  18.67 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2005 Income Statement.xlsx
  -  18.69 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2006 Income Statement.xlsx
  -  18.69 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2007 Income Statement.xlsx
  -  18.68 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2008 Income Statement.xlsx
  -  18.73 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2009 Income Statement.xlsx
  -  18.76 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.74 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2012 Income Statement.xlsx
  -  18.79 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2013 Income Statement.xlsx
  -  18.74 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2014 Income Statement.xlsx
  -  18.74 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2015 Income Statement.xlsx
  -  18.77 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2016 Income Statement.xlsx
  -  18.78 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2017 Income Statement.xlsx
  -  18.74 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2018 Income Statement.xlsx
  -  18.74 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2019 Income Statement.xlsx
  -  18.76 KB

  ~Get Your Files Here !/1. Overview/Resources/06 _ ERP Project/Project Data/2020 Income Statement.xlsx
  -  18.78 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.39 KB

  ~Get Your Files Here !/2. Excel VBA Overview/1. Classes & Objects Overview.mp4
  -  4.91 MB

  ~Get Your Files Here !/2. Excel VBA Overview/2. Creating Objects.mp4
  -  60.04 MB

  ~Get Your Files Here !/2. Excel VBA Overview/3. Excel Objects Part 1.mp4
  -  3.73 MB

  ~Get Your Files Here !/2. Excel VBA Overview/4. Excel Objects Part 2.mp4
  -  55.28 MB

  ~Get Your Files Here !/2. Excel VBA Overview/5. Excel Objects Part 3.mp4
  -  5.32 MB

  ~Get Your Files Here !/3. Get Data/1. Data Structures.mp4
  -  3.97 MB

  ~Get Your Files Here !/3. Get Data/2. Files, Folders, & Paths.mp4
  -  16.52 MB

  ~Get Your Files Here !/3. Get Data/3. Last Row.mp4
  -  23.01 MB

  ~Get Your Files Here !/3. Get Data/4. Last Column.mp4
  -  15.14 MB

  ~Get Your Files Here !/3. Get Data/5. Get Data.mp4
  -  64.47 MB

  ~Get Your Files Here !/3. Get Data/6. Export Data.mp4
  -  33.38 MB

  ~Get Your Files Here !/3. Get Data/7. Workbook Scrape.mp4
  -  31.96 MB

  ~Get Your Files Here !/4. Transform Functions/1. Overview.mp4
  -  6.71 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.85 MB

  ~Get Your Files Here !/4. Transform Functions/12. Move Column.mp4
  -  33.11 MB

  ~Get Your Files Here !/4. Transform Functions/13. Select Columns.mp4
  -  28.62 MB

  ~Get Your Files Here !/4. Transform Functions/14. Stack.mp4
  -  51.06 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.88 MB

  ~Get Your Files Here !/4. Transform Functions/3. Sum Columns.mp4
  -  35.11 MB

  ~Get Your Files Here !/4. Transform Functions/4. Add Columns.mp4
  -  16.74 MB

  ~Get Your Files Here !/4. Transform Functions/5. Math Part 1.mp4
  -  42.35 MB

  ~Get Your Files Here !/4. Transform Functions/6. Math Part 2.mp4
  -  65.41 MB

  ~Get Your Files Here !/4. Transform Functions/7. Compare.mp4
  -  49.51 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.72 MB

  ~Get Your Files Here !/5. Header Index/1. Scalar.mp4
  -  31.96 MB

  ~Get Your Files Here !/5. Header Index/2. Arrays.mp4
  -  30.41 MB

  ~Get Your Files Here !/5. Header Index/3. Update Transform Functions.mp4
  -  38.07 MB

  ~Get Your Files Here !/6. ERP Project/1. Project Overview.mp4
  -  8.19 MB

  ~Get Your Files Here !/6. ERP Project/2. Project Libraries.html
  -  406 Bytes

  ~Get Your Files Here !/6. ERP Project/3. Project Code 1.mp4
  -  45.93 MB

  ~Get Your Files Here !/6. ERP Project/4. Project Code 2.mp4
  -  28.81 MB

  ~Get Your Files Here !/6. ERP Project/5. Project Code 3.mp4
  -  37.42 MB

  ~Get Your Files Here !/6. ERP Project/6. Project Code 4.mp4
  -  28.16 MB

  ~Get Your Files Here !/Bonus Resources.txt
  -  386 Bytes



Torrent Description

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

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

Image error

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...

Image error

Image error