| 1 - Introduction to the VBA Course English.vtt | 6.4 KB | ||
| 1 - Introduction to the VBA Course.mp4 | 44.1 MB | ||
| 1 - VBA Course Quiz.html | 0 B | ||
| 10 - How to Define and Manage Variables English.vtt | 12 KB | ||
| 10 - How to Define and Manage Variables.mp4 | 22.9 MB | ||
| 11 - Constant Variable Types and Variables through Intellitext English.vtt | 4.6 KB | ||
| 11 - Constant Variable Types and Variables through Intellitext.mp4 | 20.2 MB | ||
| 12 - Subroutines English.vtt | 7 KB | ||
| 12 - Subroutines.mp4 | 35 MB | ||
| 13 - Logical Constructs The Boolean Type English.vtt | 7.5 KB | ||
| 13 - Logical Constructs The Boolean Type.mp4 | 33.6 MB | ||
| 14 - Logical Constructs If and Switch Statements English.vtt | 6.2 KB | ||
| 14 - Logical Constructs If and Switch Statements.mp4 | 24 MB | ||
| 15 - Methods for Communicating to the User English.vtt | 11.2 KB | ||
| 15 - Methods for Communicating to the User.mp4 | 54.7 MB | ||
| 16 - Looping The For and Do While Loops English.vtt | 8.1 KB | ||
| 16 - Looping The For and Do While Loops.mp4 | 54.6 MB | ||
| 17 - Looping Collections and the For Each Loop English.vtt | 5.8 KB | ||
| 17 - Looping Collections and the For Each Loop.mp4 | 41.6 MB | ||
| 18 - Functions English.vtt | 6.2 KB | ||
| 18 - Functions.mp4 | 31.6 MB | ||
| 19 - Returning Values from Functions English.vtt | 6.3 KB | ||
| 19 - Returning Values from Functions.mp4 | 40 MB | ||
| 2 - WATCH ME Essential Information for a Successful Training Experience English.vtt | 1.5 KB | ||
| 2 - WATCH ME Essential Information for a Successful Training Experience.mp4 | 34.9 MB | ||
| 20 - Sending Values to Functions English.vtt | 8.7 KB | ||
| 20 - Sending Values to Functions.mp4 | 56.7 MB | ||
| 21 - Determining Limitations English.vtt | 6.1 KB | ||
| 21 - Determining Limitations.mp4 | 37 MB | ||
| 22 - The Worksheet Function Object English.vtt | 11.6 KB | ||
| 22 - The Worksheet Function Object.mp4 | 90 MB | ||
| 23 - Completing Exercise 5 English.vtt | 10 KB | ||
| 23 - Completing Exercise 5.mp4 | 67.4 MB | ||
| 24 - The Range Object English.vtt | 10.7 KB | ||
| 24 - The Range Object.mp4 | 70.4 MB | ||
| 25 - Writing an Array Formula English.vtt | 6.5 KB | ||
| 25 - Writing an Array Formula.mp4 | 48.2 MB | ||
| 26 - The Application Object English.vtt | 12.7 KB | ||
| 26 - The Application Object.mp4 | 74.5 MB | ||
| 27 - The Workbook and Worksheet Objects English.vtt | 15.6 KB | ||
| 27 - The Workbook and Worksheet Objects.mp4 | 87.3 MB | ||
| 28 - Using Errors to Guide You English.vtt | 15.5 KB | ||
| 28 - Using Errors to Guide You.mp4 | 92.2 MB | ||
| 29 - The Name and Names Objects English.vtt | 8 KB | ||
| 29 - The Name and Names Objects.mp4 | 55.6 MB | ||
| 2_3_VBAE_Exercise.xlsm | 29.5 KB | ||
| 2_3_VBAE_Exercise_Solution.xlsm | 36.4 KB | ||
| 3 - Course Exercise and Solution Files.html | 921.6 B | ||
| 30 - The PivotTable Object English.vtt | 8.5 KB | ||
| 30 - The PivotTable Object.mp4 | 66.6 MB | ||
| 31 - The Chart and ChartObject Objects English.vtt | 11.6 KB | ||
| 31 - The Chart and ChartObject Objects.mp4 | 85.8 MB | ||
| 32 - The PageSetup Object and Print Ranges English.vtt | 15.2 KB | ||
| 32 - The PageSetup Object and Print Ranges.mp4 | 120.4 MB | ||
| 33 - One Approach To Completing Exercise 8 English.vtt | 16.2 KB | ||
| 33 - One Approach To Completing Exercise 8.mp4 | 123.6 MB | ||
| 34 - Concluding Remarks English.vtt | 6.4 KB | ||
| 34 - Concluding Remarks.mp4 | 45 MB | ||
| 3_4_VBAE_Exercise.xlsm | 35 KB | ||
| 3_4_VBAE_Exercise_Solution.xlsm | 39.7 KB | ||
| 4 - Getting Started English.vtt | 7.6 KB | ||
| 4 - Getting Started.mp4 | 65.1 MB | ||
| 4_3_VBAE_Exercise.xlsm | 36.8 KB | ||
| 4_3_VBAE_Exercise_Solution.xlsm | 37.5 KB | ||
| 4_6_VBAE_Exercise.xlsm | 37.8 KB | ||
| 4_6_VBAE_Exercise_Solution.xlsm | 39.9 KB | ||
| 5 - The VBA Editor English.vtt | 11.3 KB | ||
| 5 - The VBA Editor.mp4 | 52.3 MB | ||
| 5_5_VBAE_Exercise.xlsm | 22 KB | ||
| 5_5_VBAE_Exercise_Solution.xlsm | 23 KB | ||
| 5_7_VBAE_Exercise.xlsm | 27.1 KB | ||
| 5_7_VBAE_Exercise_Solution.xlsm | 28.8 KB | ||
| 6 - First Coding Manipulations English.vtt | 10.4 KB | ||
| 6 - First Coding Manipulations.mp4 | 53.4 MB | ||
| 6_1_VBAE_Exercise.xlsm | 24.9 KB | ||
| 6_1_VBAE_Exercise_Solution.xlsm | 25.3 KB | ||
| 6_2_Example_Macro.xlsm | 24.8 KB | ||
| 6_7_VBAE_Exercise.xlsm | 100 KB | ||
| 6_7_VBAE_Exercise_Printout.oxps | 255.2 KB | ||
| 6_7_VBAE_Exercise_Solution.xlsm | 118.1 KB | ||
| 7 - VBA Syntax Keywords and Comments English.vtt | 10.7 KB | ||
| 7 - VBA Syntax Keywords and Comments.mp4 | 40.7 MB | ||
| 8 - Objects and VBAs Intellitext English.vtt | 8 KB | ||
| 8 - Objects and VBAs Intellitext.mp4 | 35.6 MB | ||
| 9 - Variables and Method Calling Rules English.vtt | 11.6 KB | ||
| 9 - Variables and Method Calling Rules.mp4 | 46.5 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 88 total files | |||
Essential Vba Training For Excel - Automate Repetitive Tasks
https://DevCourseWeb.com
Last updated 3/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.81 GB | Duration: 4h 0m
Learn Microsoft VBA to automate your time-consuming procedures in Excel.
What you'll learn
How to automate tasks and operations that you perform frequently.
General syntax rules, what keywords are, and how to add comments.
What variables are, and how they relate to functions versus methods and subroutines.
How to specify different variables, including arrays, and how to manage them in code.
How to use intellitext with variables, particularly those that are defined constants.
What functions are, how they are used, and how to stage a scenario to complete.
How functions return values.
How to define inputs for functions.
How to use input boxes and message boxes to interact with the user.
The intricacies surrounding creating an array formula.
How to use the application object to control the user experience.
How to use errors to improve your code.
How to use the name and names object to manage named ranges.
General information about the PivotTable object and basic approaches to utilizing it.
Requirements
Microsoft Excel. The course was created using Excel 2013. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, and Excel 2013.
Intermediate knowledge of Microsoft Excel.
Description
Master Automation by Learning the Ins and Outs of Microsoft Visual Basic for Applications (VBA) for ExcelIn Essential VBA Training for Excel - get up to speed on using VBA to help automate time-consuming procedures in Excel.Great for automating repetitive tasks and operations that you perform frequently, VBA is a powerful tool to increase your productivity. Contents and OverviewThe course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel.Find out how to use the VBA editor, VBA syntax, keywords, and comments. Discover how to define and manage variables, set up subroutines, and create functions.Also, find out how to use input boxes and message boxes to interact with end users.Learn practical methods for using macro errors to improve your VBA code.When you complete this course, you'll be well on your way to using VBA macros in Excel to help you and others automate tasks and operations performed frequently.This course includes:Exercise filesAn optional quiz to test what you've learnedA certificate of completionAll of our videos are high definition; therefore, they are best viewed with the HD setting on and the videos enlarged.
Overview
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 286 MB | freecoursewb | 1 week | 0 | 0 | |
| 772.9 MB | freecoursewb | 1 week | 64 | 4 | |
| 264.8 MB | freecoursewb | 3 weeks | 8 | 2 | |
|
Udemy - British Sign Language -Learn Bsl Like A Pro Essential Skills Posted by
freecoursewb in Other
|
790.5 MB | freecoursewb | 2 months | 10 | 4 |
| 4 GB | freecoursewb | 2 months | 7 | 1 |
All Comments