Udemy - Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills

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

Files

[ DevCourseWeb.com ] Udemy - Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Course Preview
    • 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)
    • 2. What's Covered in this course.mp4 (41.3 MB)
    • 2. What's Covered in this course.srt (5.7 KB)
    2. Introduction
    • 1. Welcome.mp4 (17.4 MB)
    • 1. Welcome.srt (2.1 KB)
    • 2. Recommended Learning Procedure.mp4 (14.0 MB)
    • 2. Recommended Learning Procedure.srt (1.9 KB)
    • 3. What is VBA.mp4 (40.0 MB)
    • 3. What is VBA.srt (6.3 KB)
    • 4. Important Word - Before we begin.html (2.4 KB)
    • 4.1 Important Word - Before we begin - Spanish.docx (13.8 KB)
    3. Source files
    • 1. Source File (Developer Environment).html (0.1 KB)
    • 1.1 Date Picker.xlsm (13.9 KB)
    • 2. Source File (Designing the Date Picker).html (0.1 KB)
    • 2.1 Date Picker.xlsm (16.3 KB)
    • 3. Source File (VBA Coding).html (0.1 KB)
    • 3.1 Date Picker .xlsm (19.0 KB)
    • 4. Source File (Enabling the Top Navigation).html (0.1 KB)
    • 5. Source File (The Date Display Defaults - Nested Loops).html (0.1 KB)
    • Date Picker - Enabling the Top Navigation.xlsm (24.9 KB)
    • Date Picker - The Date Display Defaults - Nested Loops.xlsm (20.7 KB)
    4. Setting up the Developer Environment
    • 1. Introduction.mp4 (30.4 MB)
    • 1. Introduction.srt (2.4 KB)
    • 2. Saving a Macro-Enabled Workbook.mp4 (24.8 MB)
    • 2. Saving a Macro-Enabled Workbook.srt (3.8 KB)
    • 3. Adding the Developer Tab.mp4 (24.9 MB)
    • 3. Adding the Developer Tab.srt (3.1 KB)
    • 4. Accessing the VBA Editor.mp4 (11.1 MB)
    • 4. Accessing the VBA Editor.srt (1.2 KB)
    • 5. Understanding the VBA Editor.mp4 (20.1 MB)
    • 5. Understanding the VBA Editor.srt (3.5 KB)
    • 6. Adding a UserForm.mp4 (7.0 MB)
    • 6. Adding a UserForm.srt (0.8 KB)
    • 7. The Toolbox.mp4 (11.1 MB)
    • 7. The Toolbox.srt (1.3 KB)
    • 8. The Properties Window.mp4 (23.1 MB)
    • 8. The Properties Window.srt (2.5 KB)
    • 9. Test Driving the Properties Window.mp4 (23.5 MB)
    • 9. Test Driving the Properties Window.srt (2.9 KB)
    5. Designing the Date Picker
    • 1. Introduction.mp4 (23.3 MB)
    • 1. Introduction.srt (3.2 KB)
    • 2. Learning from the Windows Calendar.mp4 (16.5 MB)
    • 2. Learning from the Windows Calendar.srt (3.1 KB)
    • 3. Designing the Header – Marking Boundary.mp4 (51.1 MB)
    • 3. Designing the Header – Marking Boundary.srt (6.2 KB)
    • 4. Designing the Header - Month Display.mp4 (51.7 MB)
    • 4. Designing the Header - Month Display.srt (5.8 KB)
    • 5. Designing the Header - Year Display.mp4 (39.2 MB)
    • 5. Designing the Header - Year Display.srt (3.8 KB)
    • 6. Adding the Days Section.mp4 (54.0 MB)
    • 6. Adding the Days Section.srt (6.3 KB)
    • 7. Adding the Date Section.mp4 (73.7 MB)
    • 7. Adding the Date Section.srt (9.3 KB)
    • 8. Adding the Footer.mp4 (51.9 MB)
    • 8. Adding the Footer.srt (7.3 KB)
    6. VBA Coding
    • 1. Introduction.mp4 (20.8 MB)
    • 1. Introduction.srt (3.4 KB)
    • 2. Introducing the Code Editor.mp4 (44.6 MB)
    • 2. Introducing the Code Editor.srt (8.5 KB)
    • 3. Understanding the Initialize Event.mp4 (57.3 MB)
    • 3. Understanding the Initialize Event.srt (10.4 KB)
    • 4. Understanding the initialize event - Continued….mp4 (58.1 MB)
    • 4. Understanding the initialize event - Continued….srt (9.3 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 and Calling Private Sub Procedures.mp4 (45.5 MB)
    • 6. Adding and Calling Private Sub Procedures.srt (7.4 KB)
    • 7. Event Procedures & User-Defined Procedures.mp4 (23.3 MB)
    • 7. Event Procedures & User-Defined Procedures.srt (3.4 KB)
    • 8. Header Settings - Month Display.mp4 (36.4 MB)
    • 8. Header Settings - Month Display.srt (4.2 KB)
    • 9. Header Settings - Year Display.mp4 (39.5 MB)
    • 9. Header Settings - Year Display.srt (5.4 KB)
    7. Working with Constants
    • 1. Using RGB function to set colours.mp4 (45.6 MB)
    • 1. Using RGB function to set colours.srt (7.6 KB)
    • 2. Working with Constants - Procedure Level.mp4 (41.3 MB)
    • 2. Working with Constants - Procedure Level.srt (5.9 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)
    • 4. Working with Constants - Module Level.mp4 (11.8 MB)
    • 4. Working with Constants - Module Level.srt (1.5 KB)
    • 5. Adding more constants.mp4 (40.6 MB)
    • 5. Adding more constants.srt (6.8 KB)
    • 6. Working with Constants - Enumeration.mp4 (40.0 MB)
    • 6. Working with Constants - Enumeration.srt (6.2 KB)
    • 7. Arranging Display - Separation of Concerns.mp4 (47.2 MB)
    • 7. Arranging Display - Separation of Concerns.srt (7.3 KB)
    8. Looping Through a Range of Objects
    • 1. Configuring the Days Section.mp4 (42.4 MB)
    • 1. Configuring the Days Section.srt (4.3 KB)
    • 2. Eliminating Redundancy.mp4 (29.2 MB)
    • 2. Eliminating Redundancy.srt (4.9 KB)
    • 3. The Looping Technique.mp4 (45.9 MB)
    • 3. The Looping Technique.srt (7.3 KB)
    • 4. Accessing the Controls Collection.mp4 (40.0 MB)
    • 4. Accessing the Controls Collection.srt (5.7 KB)
    • 5. Indirect Referencing of Labels.mp4 (26.7 MB)
    • 5. Indirect Referencing of Labels.srt (3.5 KB)
    • 6. Dynamically Updating the Left Position.mp4 (15.1 MB)
    • 6. Dynamically Updating the Left Position.srt (2.2 KB)
    • 7. Testing the Left Position.mp4 (26.8 MB)

Description

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.



Download torrent
1.7 GB
seeders:15
leechers:11
Udemy - Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills

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.7 GB
seeders:15
leechers:11
Udemy - Microsoft Excel VBA Fundamentals - Learn Basic Coding Skills

Torrent hash: 696C22530C948A4742A34D6E4A6B1D18E171760C