• Microsoft Excel - Macros & VBA

    ON-DEMAND: Microsoft Excel - Macros & VBA


    Learn to automate your most repetitive tasks at the push of a button with Excel macros and VBA. In this online course that Ken Puls designed and built with a company called GoSkills, you will learn to create powerful macros using VBA (Visual Basic for Applications) to really make Excel work for you. With no prior programming experience required, you'll have your daily spreadsheets running like clockwork to save you hours of time and boost your productivity.

    • 41 practical tutorials.
    • Understand the differences between macros and VBA.
    • Run your macro from the Macro dialog, a keyboard shortcut or worksheet button.
    • Understand the syntax and structure that make up a valid macro.
    • How VBA Objects and the Objects model relate to each other.
    • Using step vs run in entry level debugging.
    • How to create variables and assign strings, values or objects.
    • Implementing logic tests in VBA.
    • Set up looping with Do loops and Do While loops.
    • Create a VBA Message Boxes.
    • Set up an error trap in VBA to handle errors.
    • Create a User Defined Function (UDF).

    Video tutorials are recorded in Microsoft Excel 2016 for PC.


    For full course details and to register, visit the GoSkills website.

    Even better, there's even a discount available if you're ready to sign up. Just enter the code XLGURU at checkout and you end up getting the course at 15% off the regular price.


    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!


    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!