| 1. Configuring the Days Section.mp4 | 42.4 MB | ||
| 1. Configuring the Days Section.srt | 4.3 KB | ||
| 1. Introduction.mp4 | 13.8 MB | ||
| 1. Introduction.srt | 2.2 KB | ||
| 1. Source File (Developer Environment).html | 102.4 B | ||
| 1. Using RGB function to set colours.mp4 | 45.6 MB | ||
| 1. Using RGB function to set colours.srt | 7.6 KB | ||
| 1. Welcome.mp4 | 17.4 MB | ||
| 1. Welcome.srt | 2.1 KB | ||
| 1. What's the Best Approach to Learning Excel VBA.mp4 | 57.6 MB | ||
| 1. What's the Best Approach to Learning Excel VBA.srt | 8.3 KB | ||
| 1.1 Date Picker.xlsm | 13.9 KB | ||
| 2. Eliminating Redundancy.mp4 | 29.2 MB | ||
| 2. Eliminating Redundancy.srt | 4.9 KB | ||
| 2. Introducing the Code Editor.mp4 | 44.6 MB | ||
| 2. Introducing the Code Editor.srt | 8.5 KB | ||
| 2. Learning from the Windows Calendar.mp4 | 16.5 MB | ||
| 2. Learning from the Windows Calendar.srt | 3.1 KB | ||
| 2. Recommended Learning Procedure.mp4 | 14 MB | ||
| 2. Recommended Learning Procedure.srt | 1.9 KB | ||
| 2. Saving a Macro-Enabled Workbook.mp4 | 24.8 MB | ||
| 2. Saving a Macro-Enabled Workbook.srt | 3.8 KB | ||
| 2. Setting the Default Properties of the Label R1C1.mp4 | 16.7 MB | ||
| 2. Setting the Default Properties of the Label R1C1.srt | 2.1 KB | ||
| 2. Source File (Designing the Date Picker).html | 102.4 B | ||
| 2. What's Covered in this course.mp4 | 41.3 MB | ||
| 2. What's Covered in this course.srt | 5.7 KB | ||
| 2. Working with Constants - Procedure Level.mp4 | 41.3 MB | ||
| 2. Working with Constants - Procedure Level.srt | 5.9 KB | ||
| 2.1 Date Picker.xlsm | 16.3 KB | ||
| 3. Adding the Developer Tab.mp4 | 24.9 MB | ||
| 3. Adding the Developer Tab.srt | 3.1 KB | ||
| 3. Designing the Header – Marking Boundary.mp4 | 51.1 MB | ||
| 3. Designing the Header – Marking Boundary.srt | 6.2 KB | ||
| 3. Setting the Default Properties of the 1st Row.mp4 | 36.2 MB | ||
| 3. Setting the Default Properties of the 1st Row.srt | 5.5 KB | ||
| 3. Source File (VBA Coding).html | 102.4 B | ||
| 3. The Looping Technique.mp4 | 45.9 MB | ||
| 3. The Looping Technique.srt | 7.3 KB | ||
| 3. The downside of a procedure-level constant.mp4 | 11.1 MB | ||
| 3. The downside of a procedure-level constant.srt | 1.8 KB | ||
| 3. Understanding the Initialize Event.mp4 | 57.3 MB | ||
| 3. Understanding the Initialize Event.srt | 10.4 KB | ||
| 3. What is VBA.mp4 | 40 MB | ||
| 3. What is VBA.srt | 6.3 KB | ||
| 3.1 Date Picker .xlsm | 19 KB | ||
| 4. Accessing the Controls Collection.mp4 | 40 MB | ||
| 4. Accessing the Controls Collection.srt | 5.7 KB | ||
| 4. Accessing the VBA Editor.mp4 | 11.1 MB | ||
| 4. Accessing the VBA Editor.srt | 1.2 KB | ||
| 4. Designing the Header - Month Display.mp4 | 51.7 MB | ||
| 4. Designing the Header - Month Display.srt | 5.8 KB | ||
| 4. Important Word - Before we begin.html | 2.4 KB | ||
| 4. Nested Loop Statements.mp4 | 26.2 MB | ||
| 4. Nested Loop Statements.srt | 3.8 KB | ||
| 4. Source File (Enabling the Top Navigation).html | 102.4 B | ||
| 4. Understanding the initialize event - Continued….mp4 | 58.1 MB | ||
| 4. Understanding the initialize event - Continued….srt | 9.3 KB | ||
| 4. Working with Constants - Module Level.mp4 | 11.8 MB | ||
| 4. Working with Constants - Module Level.srt | 1.5 KB | ||
| 4.1 Important Word - Before we begin - Spanish.docx | 13.8 KB | ||
| 5. Adding more constants.mp4 | 40.6 MB | ||
| 5. Adding more constants.srt | 6.8 KB | ||
| 5. Designing the Header - Year Display.mp4 | 39.2 MB | ||
| 5. Designing the Header - Year Display.srt | 3.8 KB | ||
| 5. Enabling the Dynamic Top Row Position.mp4 | 9.8 MB | ||
| 5. Enabling the Dynamic Top Row Position.srt | 1 KB | ||
| 5. Indirect Referencing of Labels.mp4 | 26.7 MB | ||
| 5. Indirect Referencing of Labels.srt | 3.5 KB | ||
| 5. Source File (The Date Display Defaults - Nested Loops).html | 102.4 B | ||
| 5. Understanding the VBA Editor.mp4 | 20.1 MB | ||
| 5. Understanding the VBA Editor.srt | 3.5 KB | ||
| 5. Working With the Properties of Child Objects.mp4 | 63.3 MB | ||
| 5. Working With the Properties of Child Objects.srt | 8.8 KB | ||
| 6. Adding a UserForm.mp4 | 7 MB | ||
| 6. Adding a UserForm.srt | 819.2 B | ||
| 6. Adding and Calling Private Sub Procedures.mp4 | 45.5 MB | ||
| 6. Adding and Calling Private Sub Procedures.srt | 7.4 KB | ||
| 6. Adding the Days Section.mp4 | 54 MB | ||
| 6. Adding the Days Section.srt | 6.3 KB | ||
| 6. Dynamically Updating the Left Position.mp4 | 15.1 MB | ||
| 6. Dynamically Updating the Left Position.srt | 2.2 KB | ||
| 6. Module - Summary.mp4 | 12.9 MB | ||
| 6. Module - Summary.srt | 1.7 KB | ||
| 6. Working with Constants - Enumeration.mp4 | 40 MB | ||
| 6. Working with Constants - Enumeration.srt | 6.2 KB | ||
| 7. Adding the Date Section.mp4 | 73.7 MB | ||
| 7. Adding the Date Section.srt | 9.3 KB | ||
| 7. Arranging Display - Separation of Concerns.mp4 | 47.2 MB | ||
| 7. Arranging Display - Separation of Concerns.srt | 7.3 KB | ||
| 7. Course Summary & Conclusion.mp4 | 35.3 MB | ||
| 7. Course Summary & Conclusion.srt | 4.8 KB | ||
| 7. Event Procedures & User-Defined Procedures.mp4 | 23.3 MB | ||
| 7. Event Procedures & User-Defined Procedures.srt | 3.4 KB | ||
| 7. Testing the Left Position.mp4 | 26.8 MB | ||
| 7. Testing the Left Position.srt | 4.6 KB | ||
| 7. The Toolbox.mp4 | 11.1 MB | ||
| 7. The Toolbox.srt | 1.3 KB | ||
| 8. Adding the Footer.mp4 | 51.9 MB | ||
| 8. Adding the Footer.srt | 7.3 KB | ||
| 8. Coding the Days Captions.mp4 | 28 MB | ||
| 8. Coding the Days Captions.srt | 4.3 KB | ||
| 8. Header Settings - Month Display.mp4 | 36.4 MB | ||
| 8. Header Settings - Month Display.srt | 4.2 KB | ||
| 8. Link to Part 2 of the Beginner ‘s Guide to Excel VBA.html | 614.4 B | ||
| 8. The Properties Window.mp4 | 23.1 MB | ||
| 8. The Properties Window.srt | 2.5 KB | ||
| 9. Header Settings - Year Display.mp4 | 39.5 MB | ||
| 9. Header Settings - Year Display.srt | 5.4 KB | ||
| 9. Test Driving the Properties Window.mp4 | 23.5 MB | ||
| 9. Test Driving the Properties Window.srt | 2.9 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Date Picker - Enabling the Top Navigation.xlsm | 24.9 KB | ||
| Date Picker - The Date Display Defaults - Nested Loops.xlsm | 20.7 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 121 total files | |||
Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills
https://DevCourseWeb.com
Last updated 11/2022
Duration: 3h 28m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 1.69 GB
Genre: eLearning | Language: English
The Beginner's Guide to Excel VBA (1)
What you'll learn
VBA (Visual Basic for Applications) programming language
Learn how to use the VB code editor
Get a general knowledge about the event procedures
Get a profound knowledge about the Initialize Event
Get a full understanding of Sub procedures
Learn how to write a clean and easy to maintain code
Separation of concerns
Understand the master-slave approach
Learn how to debug the code
Learn how to manipulate objects using the code
Learn how and when to use a With…End With-statement
Requirements
Basic understanding of Microsoft Excel
Zero knowledge of VBA
You must be using Microsoft Excel 2010 to 365
Description
Microsoft Excel VBA Fundamentals course is designed to teach relevant basic coding skills for VBA programming. It is for those who aspire to become a VBA programmer and don’t know where to start. It is also suitable for those who automate their spreadsheets by recording macros but seek to learn how to write the code themselves.
What should you expect in this course?
This course is entitled: Learn basic coding skills, it is NOT entitled Learn VBA basics
Therefore, we are focusing on the skill of writing a VBA code that is clean, maintainable, and easy to understand.
This is what you may call pre-basics or basics that are really basic; something you need to learn before you dive into Excel VBA concepts.
Your journey in your VBA career will start by learning
What is VBA?
What are the tools used by a VBA programmer?
How to design an object, because before you start to learn how to write a VBA code, you need to understand what an object is. Otherwise, you will not understand the language at all.
After that, I will teach you how to send system commands that will manipulate the behaviour of the object you just created.
It is a very short course, but that will be enough to get you started.
What you will learn here is always a missing key to those who are struggling to understand VBA concepts, or to those who think they have understood the concepts, but when faced with a real-world project they get stuck and wonder why.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 650.8 MB | freecoursewb | 3 weeks | 0 | 0 | |
| 637.4 MB | freecoursewb | 3 weeks | 14 | 7 | |
| 1.6 GB | freecoursewb | 3 weeks | 0 | 0 | |
|
Udemy - PL-300 - Microsoft Power BI Data Analyst Associate Course 2026 Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 3 weeks | 23 | 4 |
| 2 GB | freecoursewb | 2 months | 36 | 8 |
All Comments