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.

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. 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 Advanced VBA Excel Course: Macros to automate Free

Download Here Totally Free


Do you want to see our Full Free Course Gallery available?

To see our course gallery click here

See Full Free Courses Gallery

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.

LanguageOnly Spanish
File Size282 MB


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!

    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.

    *(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 valiosossaludos 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.
    • Asked by Jose Aguilar
      on 10/07/2018
      Buenos dìas, me sigue saliendo el error. Espero que puedan solucionarlo. GRacias. Answer:
      Que tal Jose, el archivo esta correcto. Debes colocar la clave de descompresión bien. La clave es
    • Asked by Marcos Morales Reyes
      on 02/27/2019
      Pueden enviarme directamente a mi correo electrónico, los cursos gratuitos de Excel? Desde lo básico, principiante Answer:
      Amigo Marcos, los cursos pesan mucho para pasarlos por email. : (

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