| 1 - Introduction English.vtt | 3.9 KB | ||
| 1 - Introduction.mp4 | 11.9 MB | ||
| 10 - Loop Through Defined Range English.vtt | 4 KB | ||
| 10 - Loop Through Defined Range.mp4 | 19.7 MB | ||
| 11 - Loop Through Entire Column English.vtt | 4.1 KB | ||
| 11 - Loop Through Entire Column.mp4 | 17.4 MB | ||
| 12 - Do Until Loop English.vtt | 3.5 KB | ||
| 12 - Do Until Loop.mp4 | 17.1 MB | ||
| 12.01 Single Loop.xlsm | 17.2 KB | ||
| 12.02 Double Loop.xlsm | 16.7 KB | ||
| 12.03 Triple Loop.xlsm | 20.4 KB | ||
| 12.04 Do While Loop.xlsm | 16.4 KB | ||
| 12.05 Build a Commission Table.xlsm | 34.9 KB | ||
| 13 - Use Step To Increment English.vtt | 4.2 KB | ||
| 13 - Use Step To Increment.mp4 | 22.2 MB | ||
| 13.01 Loop through Defined Range.xlsm | 16.8 KB | ||
| 13.02 Loop through Entire Column.xlsm | 17 KB | ||
| 13.03 Do Until Loop.xlsm | 16.5 KB | ||
| 13.04 Use Step to Increment.xlsm | 16.4 KB | ||
| 13.05 Build a Pattern Project.xlsm | 16.7 KB | ||
| 13.06 How to Sort.xlsm | 8.1 KB | ||
| 13.07 Sort by Related Data.xlsm | 17.9 KB | ||
| 13.08 Delete Duplicate Values.xlsm | 17.2 KB | ||
| 14 - Build A Pattern Project English.vtt | 5.2 KB | ||
| 14 - Build A Pattern Project.mp4 | 26.7 MB | ||
| 14.01 Join Strings.xlsm | 16.3 KB | ||
| 14.02 Extract Substrings from Left or Right.xlsm | 16.1 KB | ||
| 14.03 Extract Substring at Middle.xlsm | 16 KB | ||
| 14.04 Get Length of a String.xlsm | 15.9 KB | ||
| 14.05 Get Substring Position.xlsm | 16.8 KB | ||
| 14.06 How to Split Strings.xlsm | 17.3 KB | ||
| 14.07 Reverse Characters.xlsm | 17.3 KB | ||
| 14.08 Change String Casing.xlsm | 16.9 KB | ||
| 14.09 Count Words in a Range.xlsm | 17.5 KB | ||
| 15 - How To Sort English.vtt | 6.1 KB | ||
| 15 - How To Sort.mp4 | 31.6 MB | ||
| 15.01 Make and Use Your Own Function.xlsm | 17.8 KB | ||
| 15.02 Pass Arguments to a Function.xlsm | 16.8 KB | ||
| 15.03 Custom Calculator Function.xlsm | 14.7 KB | ||
| 16 - Sort By Related Data English.vtt | 9.1 KB | ||
| 16 - Sort By Related Data.mp4 | 50.7 MB | ||
| 16.01 One Dimensional Array.xlsm | 16.8 KB | ||
| 16.02 Two Dimensional Array.xlsm | 17.8 KB | ||
| 16.03 Change Array Size.xlsm | 18.3 KB | ||
| 16.04 Build an Array.xlsm | 16.9 KB | ||
| 16.05 Populate Row with Array.xlsm | 14.1 KB | ||
| 16.06 Array Length.xlsm | 17.1 KB | ||
| 16.07 Split String into an Array.xlsm | 17.2 KB | ||
| 16.08 Join Array into a String.xlsm | 17.3 KB | ||
| 17 - Delete Duplicate Values English.vtt | 6.4 KB | ||
| 17 - Delete Duplicate Values.mp4 | 33.5 MB | ||
| 17.01 Delay a Procedure.xlsm | 17 KB | ||
| 17.02 Schedule a Procedure.xlsm | 16.8 KB | ||
| 17.03 Count Years.xlsm | 17.7 KB | ||
| 17.04 Count Days Between Dates.xlsm | 16.8 KB | ||
| 17.05 Count Weekdays Between Dates.xlsm | 17.7 KB | ||
| 17.06 Sort Dates.xlsm | 18.1 KB | ||
| 18 - Source Files.html | 0 B | ||
| 18.01 How to Access Excel Functions.xlsm | 17 KB | ||
| 18.02 Disable Screen Updating.xlsm | 16.3 KB | ||
| 18.03 Disable Alerts.xlsm | 15.8 KB | ||
| 18.04 Show Progress of Macro.xlsm | 15.9 KB | ||
| 18.05 Read Data from a File.xlsm | 17.1 KB | ||
| 18.06 Write Data to a File.xlsm | 18.2 KB | ||
| 19 - Topics Overview English.vtt | 1.8 KB | ||
| 19 - Topics Overview.mp4 | 8.2 MB | ||
| 19.01 Build a Table.xlsm | 20.5 KB | ||
| 19.02 and 19.03 Build a Table of Contents.xlsm | 34.9 KB | ||
| 19.04 Combine Worksheets by Column.xlsm | 24.2 KB | ||
| 19.05 Combine Worksheets by Row.xlsm | 24.2 KB | ||
| 2 - Topics Overview English.vtt | 1.1 KB | ||
| 2 - Topics Overview.mp4 | 4.6 MB | ||
| 20 - Join Strings English.vtt | 3.4 KB | ||
| 20 - Join Strings.mp4 | 18.8 MB | ||
| 20.01 Program a Chart.xlsm | 22.2 KB | ||
| 20.02 Program an Embedded Chart.xlsm | 20.3 KB | ||
| 20.03 Delete Charts Programatically.xlsm | 20.4 KB | ||
| 21 - Extract Substrings From Left Or Right English.vtt | 3.5 KB | ||
| 21 - Extract Substrings From Left Or Right.mp4 | 20 MB | ||
| 22 - Extract Substring At Middle English.vtt | 4.9 KB | ||
| 22 - Extract Substring At Middle.mp4 | 22.9 MB | ||
| 23 - Get Length Of A String English.vtt | 2.9 KB | ||
| 23 - Get Length Of A String.mp4 | 12.8 MB | ||
| 24 - Get Substring Position English.vtt | 3.6 KB | ||
| 24 - Get Substring Position.mp4 | 19.5 MB | ||
| 25 - How To Split Strings English.vtt | 5 KB | ||
| 25 - How To Split Strings.mp4 | 28.3 MB | ||
| 26 - Reverse Characters English.vtt | 4.3 KB | ||
| 26 - Reverse Characters.mp4 | 21.5 MB | ||
| 27 - Change String Casing English.vtt | 3.7 KB | ||
| 27 - Change String Casing.mp4 | 20.4 MB | ||
| 28 - Count Words In A Range English.vtt | 9.5 KB | ||
| 28 - Count Words In A Range.mp4 | 44.1 MB | ||
| 29 - Source Files.html | 0 B | ||
| 3 - Single Loop English.vtt | 6.3 KB | ||
| 3 - Single Loop.mp4 | 33 MB | ||
| 30 - Topics Overview English.vtt | 1.7 KB | ||
| 30 - Topics Overview.mp4 | 6.9 MB | ||
| 31 - Make And Use Your Own Function English.vtt | 7.4 KB | ||
| 31 - Make And Use Your Own Function.mp4 | 32.6 MB | ||
| 32 - Pass Arguments To A Function English.vtt | 9 KB | ||
| 32 - Pass Arguments To A Function.mp4 | 31.3 MB | ||
| 33 - Custom Calculator Function English.vtt | 7.5 KB | ||
| 33 - Custom Calculator Function.mp4 | 32.8 MB | ||
| 34 - Source Files.html | 0 B | ||
| 35 - Topics Overview English.vtt | 1.7 KB | ||
| 35 - Topics Overview.mp4 | 7.1 MB | ||
| 36 - One Dimensional Array English.vtt | 6.3 KB | ||
| 36 - One Dimensional Array.mp4 | 29.5 MB | ||
| 37 - Two Dimensional Array English.vtt | 7.1 KB | ||
| 37 - Two Dimensional Array.mp4 | 37.9 MB | ||
| 38 - Change Array Size English.vtt | 5.6 KB | ||
| 38 - Change Array Size.mp4 | 24.1 MB | ||
| 39 - Build An Array English.vtt | 5.4 KB | ||
| 39 - Build An Array.mp4 | 26.7 MB | ||
| 4 - Double Loop English.vtt | 5.2 KB | ||
| 4 - Double Loop.mp4 | 27.5 MB | ||
| 40 - Populate Row With Array English.vtt | 3.5 KB | ||
| 40 - Populate Row With Array.mp4 | 13.1 MB | ||
| 41 - Array Length English.vtt | 7.5 KB | ||
| 41 - Array Length.mp4 | 40.3 MB | ||
| 42 - Split String Into An Array English.vtt | 5.5 KB | ||
| 42 - Split String Into An Array.mp4 | 20.9 MB | ||
| 43 - Join Array Into A String English.vtt | 4.5 KB | ||
| 43 - Join Array Into A String.mp4 | 19.8 MB | ||
| 44 - Source Files.html | 0 B | ||
| 45 - Topics Overview English.vtt | 1.7 KB | ||
| 45 - Topics Overview.mp4 | 7.3 MB | ||
| 46 - Delay A Procedure English.vtt | 5.1 KB | ||
| 46 - Delay A Procedure.mp4 | 20.8 MB | ||
| 47 - Schedule A Procedure English.vtt | 5 KB | ||
| 47 - Schedule A Procedure.mp4 | 22.2 MB | ||
| 48 - Count Years English.vtt | 6 KB | ||
| 48 - Count Years.mp4 | 30.8 MB | ||
| 49 - Count Days Between Dates English.vtt | 3.2 KB | ||
| 49 - Count Days Between Dates.mp4 | 14.9 MB | ||
| 5 - Triple Loop English.vtt | 6.6 KB | ||
| 5 - Triple Loop.mp4 | 35 MB | ||
| 50 - Count Weekdays Between Dates English.vtt | 5.4 KB | ||
| 50 - Count Weekdays Between Dates.mp4 | 28.8 MB | ||
| 51 - Sort Dates English.vtt | 7.9 KB | ||
| 51 - Sort Dates.mp4 | 36.6 MB | ||
| 52 - Source Files.html | 0 B | ||
| 53 - Topics Overview English.vtt | 2.1 KB | ||
| 53 - Topics Overview.mp4 | 9.4 MB | ||
| 54 - How To Access Excel Functions English.vtt | 5.3 KB | ||
| 54 - How To Access Excel Functions.mp4 | 22.7 MB | ||
| 55 - Disable Screen Updating English.vtt | 4.2 KB | ||
| 55 - Disable Screen Updating.mp4 | 18.5 MB | ||
| 56 - Disable Alerts English.vtt | 4.7 KB | ||
| 56 - Disable Alerts.mp4 | 24.4 MB | ||
| 57 - Show Progress Of Macro English.vtt | 6.8 KB | ||
| 57 - Show Progress Of Macro.mp4 | 24.1 MB | ||
| 58 - Show Progress Of Macro English.vtt | 8 KB | ||
| 58 - Show Progress Of Macro.mp4 | 30.7 MB | ||
| 59 - Read Data From A File English.vtt | 8 KB | ||
| 59 - Read Data From A File.mp4 | 30.7 MB | ||
| 6 - Do While Loop English.vtt | 6 KB | ||
| 6 - Do While Loop.mp4 | 26.8 MB | ||
| 60 - Write Data To A File English.vtt | 6.4 KB | ||
| 60 - Write Data To A File.mp4 | 30.6 MB | ||
| 61 - Source Files.html | 0 B | ||
| 62 - Topics Overview English.vtt | 1.3 KB | ||
| 62 - Topics Overview.mp4 | 5.1 MB | ||
| 63 - Build A Table English.vtt | 5.5 KB | ||
| 63 - Build A Table.mp4 | 25.5 MB | ||
| 64 - Build A Table Of Contents English.vtt | 13.3 KB | ||
| 64 - Build A Table Of Contents.mp4 | 65.5 MB | ||
| 65 - Build A Table Of Contents 2 English.vtt | 6.2 KB | ||
| 65 - Build A Table Of Contents 2.mp4 | 33.7 MB | ||
| 66 - Combine Worksheets English.vtt | 20.8 KB | ||
| 66 - Combine Worksheets.mp4 | 96.8 MB | ||
| 67 - Combine Worksheets By Column English.vtt | 18.4 KB | ||
| 67 - Combine Worksheets By Column.mp4 | 87.3 MB | ||
| 68 - Source Files.html | 0 B | ||
| 69 - Topics Overview English.vtt | 1.8 KB | ||
| 69 - Topics Overview.mp4 | 6.8 MB | ||
| 7 - Build A Commission Table English.vtt | 6.7 KB | ||
| 7 - Build A Commission Table.mp4 | 32.1 MB | ||
| 70 - Program A Chart English.vtt | 6.9 KB | ||
| 70 - Program A Chart.mp4 | 32.7 MB | ||
| 71 - Program An Embedded Chart English.vtt | 6 KB | ||
| 71 - Program An Embedded Chart.mp4 | 28.7 MB | ||
| 72 - Delete Charts Programmatically English.vtt | 3.3 KB | ||
| 72 - Delete Charts Programmatically.mp4 | 15.5 MB | ||
| 73 - Source Files.html | 0 B | ||
| 8 - Source Files.html | 0 B | ||
| 9 - Topics Overview English.vtt | 2.2 KB | ||
| 9 - Topics Overview.mp4 | 8.4 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 191 total files | |||
The Complete Zero To Master Excel Vba And Macros
https://DevCourseWeb.com
Last updated 10/2020
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.65 GB | Duration: 5h 13m
Learn how to snag the most in demand role in the tech field today!
What you'll learn
Basic Machine Learning Concepts
Requirements
No experience necessary
Description
This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level.Learn intermediate VBA skills in this hands on course. Only beginners VBA skills required.Hands On Lectures Including:Build projects with loops, a fundamental programming concept.Learn to manipulate strings to automate your Excel workflow.Build custom functions, including a calculator, to maximize your Excel potential.Build arrays, a key programming data structure, in VBA.Learn to work with dates to schedule procedures and much more.Work with the Application object to show progress, read and write data, and more.Learn to build a table of contents project to organize your worksheets.Build charts programatically.And much more!Learning how to code is a great way to jump in a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. Learn it today and get a head start for tomorrow. People who can master technology will rule the future.
Overview
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 784.3 MB | freecoursewb | 1 week | 18 | 6 | |
| 2.2 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.7 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.3 GB | freecoursewb | 1 week | 24 | 16 | |
| 410.6 MB | freecoursewb | 1 week | 21 | 8 |
All Comments