Advanced Excel VBA Course: Automating macros


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 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

Technical data:

    Format:. MP4
    Resolution: 1280x720p
    Size: 309 MB
    Language: Spanish
    Content: 34 Videos
    Duration: 2:22 hours
    Software: Excel, Excel 2016
    Base files: If it contains
    Date of publication: 17-ene-2018

See catches

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.

Download area


Follow us on our social networks

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.

License Freeware
Language Only Spanish
File Size 282 MB
Developer Curso


Gran curso

Write your review!

Write a review

Advanced Excel VBA Course: Automating macros

Advanced Excel VBA Course: Automating macros

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.

Ask a question

NO registration required!

10 Question(s) answered

If the question you have has not yet been answered here, use the form below to ask something about this addon.

*(Required to be notified when an answer is available)
  • Asked by Carlos
    on 04/26/2018
    En el Curso Excel VBA avanzado: Macros para automatizar. He intentado abrir los archivos de este curso, pero siempre muestra un error que no existen archivos en el ZIP. Answer:
    Que tal Carlos, revisamos y todo esta en orden. Recuerda que el archivo esta comprimido con claves. la clave es
  • Asked by Freddy Arias
    on 05/03/2018
    Que Buen aporte, gracias por compartir, +573177339943, espero que mis compañeros aprecien tu trabajo y te visiten muy pronto. Answer:
    Muchas gracias por el comentario Freddy.
  • Asked by abel jose
    on 05/03/2018
    sintaxis de una macro Answer:
    No entendimos el comentario Abel, si lo reformulas con gusto te ayudamos.
  • Asked by abel jose
    on 05/03/2018
    siempre me ha gusta automatizar los procesos y macros vba es muy util gracias por este aporte, y espero aprender mucho , para poder realizar tambien apórtes valiosos saludos desde colombia 573135448070 Answer:
    Muchas gracias Abel.
  • Asked by Ingemiero Luis Hernan Barragan
    on 05/03/2018
    Excelente aporte, cada día estos cursos son de mayor utilidad para mejorar procesos de la vida cotidiana y profesional, gracias Answer:
    Muchas gracias por el comentario Ing. Luis Hernan Barragan
  • Asked by Freddy
    on 05/03/2018
    Muchas gracias por el aporte.... Answer:
    Gracias ti tu por tu visita Freddy
  • Asked by Jorge
    on 05/03/2018
    Me gusto el curso Answer:
    Excelente Jorge. Gracias por tu visita.
  • Asked by Julio
    on 06/20/2018
    Descargue el archivo pero al momento de descomprimir sale que el archivo esta dañado Answer:
    Debes insgresar la contraseña para el archivo. Es
  • Asked by Jose Aguilar
    on 09/09/2018
    Hola estimados me parece que hay un error, pues cuando abro el archivo dice que esta dañado, en la descripción dice que pesa 309 MB pero en Mega dice 281,5 MB. Favor revisarlo gracias. Answer:
    Recuerda que debes de colocar la clave. Que es Esta clave esta abajo del enlace de descarga.
  • Asked by Jose Aguilar
    on 09/15/2018
    Hola nuevamente, por favor si pueden revisar el enlace o subirlo en otro servidor, lo descargue en varias oportunidades de diferentes navegadores y de diferentes equipos, sin embargo me dice que esta dañado, no me da lugar ni siquiera a colocar la contraseña. Answer:
    Vamos a revisar Jose el enlace del curso. Ruego que nos disculpes y entras el martes. Mañana Lunes revisamos y subimos nuevamente si hay problemas.

If the download link redirects to another product that is not described in the article or is broken, report it using our Reporting Form