Udemy - Excel VBA for Beginners - udemy

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

Files

[ TutPig.com ] Excel VBA for Beginners - udemy
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Begin with VBA
    • 1. About the author-en_US.srt (1.8 KB)
    • 1. About the author.mp4 (4.1 MB)
    • 10. Modify the code of a recorded macro-en_US.srt (5.5 KB)
    • 10. Modify the code of a recorded macro.mp4 (16.8 MB)
    • 2. Why VBA-en_US.srt (6.2 KB)
    • 2. Why VBA.mp4 (83.4 MB)
    • 3. Introduction-en_US.srt (2.6 KB)
    • 3. Introduction.mp4 (8.5 MB)
    • 4. The prerequisites the developer ribbon and the Excel file format-en_US.srt (4.2 KB)
    • 4. The prerequisites the developer ribbon and the Excel file format.mp4 (10.0 MB)
    • 5. The VBA Editor VBE-en_US.srt (7.6 KB)
    • 5. The VBA Editor VBE.mp4 (18.0 MB)
    • 6. The concept of Macro-en_US.srt (2.5 KB)
    • 6. The concept of Macro.mp4 (6.8 MB)
    • 7. Record a macro-en_US.srt (5.4 KB)
    • 7. Record a macro.mp4 (14.1 MB)
    • 8. Macro Security-en_US.srt (4.7 KB)
    • 8. Macro Security.mp4 (15.0 MB)
    • 9. Understand the recorded VBA code-en_US.srt (7.4 KB)
    • 9. Understand the recorded VBA code.mp4 (24.4 MB)
    • customers.xlsm (57.3 KB)
    • example-vba-01.xlsm (24.4 KB)
    10. Errors
    • 1. Manage errors-en_US.srt (3.8 KB)
    • 1. Manage errors.mp4 (12.9 MB)
    • 2. Ignore errors-en_US.srt (2.9 KB)
    • 2. Ignore errors.mp4 (9.1 MB)
    11. Conclusions
    • 1. Final Example prepare the routines-en_US.srt (8.6 KB)
    • 1. Final Example prepare the routines.mp4 (35.2 MB)
    • 2. Final Example view and format the results-en_US.srt (3.6 KB)
    • 2. Final Example view and format the results.mp4 (14.2 MB)
    • Exercise Create and find lists.html (0.7 KB)
    • Exercise Format a given Excel table.html (0.9 KB)
    • Exercise Merge Workbooks.html (1.0 KB)
    • Exercise Retrieve the common elements.html (0.8 KB)
    • Exercise Save data into a CSV file.html (0.2 KB)
    2. Understand the VBA Code and the Excel Object Hierarchy
    • 1. The Workbook object-en_US.srt (3.5 KB)
    • 1. The Workbook object.mp4 (8.3 MB)
    • 2. The Worksheet object-en_US.srt (2.9 KB)
    • 2. The Worksheet object.mp4 (8.6 MB)
    • 3. The Cell and Range objects-en_US.srt (3.5 KB)
    • 3. The Cell and Range objects.mp4 (12.4 MB)
    3. The VBA Project
    • 1. The VBA Project structure and composition-en_US.srt (3.0 KB)
    • 1. The VBA Project structure and composition.mp4 (8.0 MB)
    • 2. The Worksheet Module Code-en_US.srt (3.3 KB)
    • 2. The Worksheet Module Code.mp4 (8.1 MB)
    • 3. The Worksheet Properties-en_US.srt (3.8 KB)
    • 3. The Worksheet Properties.mp4 (13.8 MB)
    • 4. The Worksheet Methods-en_US.srt (2.2 KB)
    • 4. The Worksheet Methods.mp4 (6.5 MB)
    • 5. The General variables and subroutines-en_US.srt (3.9 KB)
    • 5. The General variables and subroutines.mp4 (13.2 MB)
    • 6. The Workbook Methods-en_US.srt (2.4 KB)
    • 6. The Workbook Methods.mp4 (8.1 MB)
    4. The VBA Programming Principles
    • 1. Variables and Constants-en_US.srt (2.1 KB)
    • 1. Variables and Constants.mp4 (6.9 MB)
    • 2. Subroutines and Functions-en_US.srt (2.3 KB)
    • 2. Subroutines and Functions.mp4 (9.7 MB)
    • 3. User Defined Functions-en_US.srt (1.4 KB)
    • 3. User Defined Functions.mp4 (4.8 MB)
    • 4. VBA Modules-en_US.srt (2.4 KB)
    • 4. VBA Modules.mp4 (8.3 MB)
    • 5. The Worksheet Module-en_US.srt (2.9 KB)
    • 5. The Worksheet Module.mp4 (8.0 MB)
    • 6. Public and Private Subroutines and Functions-en_US.srt (5.8 KB)
    • 6. Public and Private Subroutines and Functions.mp4 (22.6 MB)
    • 7. Public and Private Variables-en_US.srt (4.3 KB)
    • 7. Public and Private Variables.mp4 (17.7 MB)
    • 8. Variable Types and Declarations-en_US.srt (2.5 KB)
    • 8. Variable Types and Declarations.mp4 (7.2 MB)
    5. Interact with the data
    • 1. The Loop For .. Next and For each ...Next-en_US.srt (5.9 KB)
    • 1. The Loop For .. Next and For each ...Next.mp4 (23.9 MB)
    • 2. The Loop While-en_US.srt (1.4 KB)
    • 2. The Loop While.mp4 (5.6 MB)
    • 3. The Loop Do Until-en_US.srt (1.6 KB)
    • 3. The Loop Do Until.mp4 (5.6 MB)
    • 4. The Conditional Instructions If, Else, ElseIF-en_US.srt (3.6 KB)
    • 4. The Conditional Instructions If, Else, ElseIF.mp4 (13.2 MB)
    • 5. The Conditional Instructions Select Case-en_US.srt (1.3 KB)
    • 5. The Conditional Instructions Select Case.mp4 (4.8 MB)
    • 6. Strings and String Functions-en_US.srt (5.8 KB)
    • 6. Strings and String Functions.mp4 (30.2 MB)
    6. Interact with the User
    • 1. The UserForms-en_US.srt (3.6 KB)
    • 1. The UserForms.mp4 (10.5 MB)
    • 10. MsgBox and InputBox Manage User Queries-en_US.srt (5.0 KB)
    • 10. MsgBox and InputBox Manage User Queries.mp4 (19.3 MB)
    • 2. Build a custom UserForm-en_US.srt (5.0 KB)
    • 2. Build a custom UserForm.mp4 (18.3 MB)
    • 3. Customize the events and properties of commands in a UserForm-en_US.srt (4.8 KB)
    • 3. Customize the events and properties of commands in a UserForm.mp4 (12.7 MB)
    • 4. Control the data in textboxes in a UserForm-en_US.srt (6.1 KB)
    • 4. Control the data in textboxes in a UserForm.mp4 (20.9 MB)
    • 5. Customize the properties and methods of button controls-en_US.srt (1.7 KB)
    • 5. Customize the properties and methods of button controls.mp4 (5.2 MB)
    • 6. Dynamically populate a combobox-en_US.srt (1.5 KB)
    • 6. Dynamically populate a combobox.mp4 (5.6 MB)
    • 7. Exchange Data between UserForms and Worksheets-en_US.srt (2.7 KB)
    • 7. Exchange Data between UserForms and Worksheets.mp4 (9.8 MB)
    • 8. MsgBox Customize your messages and warnings for the User-en_US.srt (2.5 KB)
    • 8. MsgBox Customize your messages and warnings for the User.mp4 (7.6 MB)
    • 9. MsgBox Customize the buttons of your message dialog-en_US.srt (0.9 KB)

Description

Excel VBA for Beginners - udemy



MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 835 MB | Duration: 4h 51m
the basic concepts to get started and understand EXCEL VBA however which skill level you are and automate MS Excel
What you'll learn
Register and reuse VBA macro in Excel
Create your own VBA macros in Excel
Understand the VBA code in Excel macros
Generate automated reports in Excel with VBA
Manipulate data in Excel with VBA
Format data and worksheets in Excel with VBA
Import and export external data from files to and from Excel using VBA
Understand and use the VBA editor in Excel to write macros
Understand the concepts of subroutines, functions, constants and variables in VBA for Excel
Manage errors in VBA
Understand and use dialog boxes e.g. msgbox and inputbox
create interactions between worksheets in Excel using VBA
Requirements
basic knowledge of Microsoft Office products
be familiar with computers
Description
I created this corse since I have experienced during my live trainings and even from my students of other VBA courses that I released on the Internet, that most of my students are not IT-skilled people. They are just users of Excel and want to go beyond the basic functionalities of Excel and create automated report or automate daily tasks.

For this reason I have created a course with the right pace to make it clear to anyone.

In this course I start explaining what VBA is and why VBA. For example, if you are an user of Excel, e.g. in the Accounting Department, what VBA is and why you need it.

For this reason it is important to understand first of all the concept of object oriented programming and explain how Excel is an application structured in objects whose properties and actions/events can be managed, manipulated and updated using VBA.



Download torrent
836 MB
seeders:10
leechers:3
Udemy - Excel VBA for Beginners - udemy

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
836 MB
seeders:10
leechers:3
Udemy - Excel VBA for Beginners - udemy

Torrent hash: 5D8203F289C5772E551E3548021F7E14AA30FA34