This advanced Excel VBA course responds to the needs of applying the VBA language to your Excel spreadsheets to make them more productive and optimal.
This product is no longer in stock
This advanced Excel VBA course responds to the needs of applying the VBA language to your Excel spreadsheets to make them more productive and optimal. The application of macros and, specifically, the Visual Basic for Applications code, extends the possibilities that Excel has when it comes to managing data and performing tasks automatically. Whether by using buttons or through events that occur on a daily basis, such as opening a sheet or writing to a cell, VBA code will instruct Excel to work alone and make such unproductive repetitive tasks without errors.
Excel VBA Advanced. Approach
Who this course is for. Excel 04:03 Levels
What we learn in Excel VBA advanced 04:01
Advanced concepts for programming in efficient VBA 06:44
Ways to refer to ranges and sheets
Reference to sheets and writing conventions 06:25
Reference to ranges by using cells 02:11
Use range to refer to ranges 03:27
Using rank names and writing conventions 04:25
Reference to Excel 05:44 table ranges
End and Offset as reference to ranges 05:54
Other forms of reference to Ranges 05:13
Variables in VBA
What is a variable and what types of data host 02:50
Data Variables 05:00
Object Variables 03:08
Scope and duration of variables 05:11
Constants in VBA 02:57
Variables-Matrix and arrays
Variables-Matrix. Concept 02:03
Variables-Matrix. dimensioned 01:48
Variables-Matrix. Use and examples 03:49
Arrays. Concept 03:32
static and dynamic arrays. dimensioned 03:19
Arrays. Use 03:37
Optimized and end-user-oriented applications
Avoid the Select and Copy 02:08 methods
Blocks with single and nested 02:37
Code-writing Conventions 07:55
User interaction with VBA. MsgBox Advanced 06:16
InputBox, GoTo and use of 03:03 labels
End-user-oriented application protection 02:24
Setting up the 04:28 environment and interface
Global exercise. End-user-oriented application
A walk through the application 03:42
Creating the 02:53 Modules
Creating procedures for navigating the 02:58 application
Managing workers from 10:25 procedures
Creating procedures for importing data 06:33
Code for the ThisWorkBook object 01:29
Size: 309 MB
Content: 34 Videos
Duration: 2:22 hours
Software: Excel, Excel 2016
Base files: If it contains
Date of publication: 17-ene-2018
Totally virus free and malicious software, so don't wait any longer on Descargartelo now.
Don't forget to give us an opinion about the course, to improve the content.
To see our course gallery click here
Note: Do not forget to follow us on our social networks of Facebook and Twitter to form part of our community and receive the notification every time we publish something new, so you will not miss anything.
|File Size||282 MB|
NO registration required!
12 Question(s) answered
If the question you have has not yet been answered here, use the form below to ask something about this addon.