The Complete Zero to Master Excel VBA and Macros

Learn how to snag the most in demand role in the tech field today!

This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.

What you’ll learn

  • Basic Machine Learning Concepts.

Course Content

  • Introduction –> 1 lecture • 3min.
  • Introduction to Loops –> 7 lectures • 30min.
  • Loop Projects –> 10 lectures • 41min.
  • String Manipulation –> 11 lectures • 39min.
  • Build Custom Functions –> 5 lectures • 22min.
  • Build Arrays –> 10 lectures • 42min.
  • Work with Dates –> 8 lectures • 29min.
  • Application Object –> 9 lectures • 37min.
  • VBA Projects –> 7 lectures • 56min.
  • Programming Charts –> 5 lectures • 15min.

The Complete Zero to Master Excel VBA and Macros

Requirements

This course is project-based so you will not be learning a bunch of useless coding practices. At the end of this course you will have real world apps to use in your portfolio. We feel that project based training content is the best way to get from A to B. Taking this course means that you learn practical, employable skills immediately.

 

You can use the projects you build in this course to add to your LinkedIn profile. Give your portfolio fuel to take your career to the next level.

 

Learn intermediate VBA skills in this hands on course. Only beginners VBA skills required.

Hands On Lectures Including:

Build projects with loops, a fundamental programming concept.

Learn to manipulate strings to automate your Excel workflow.

Build custom functions, including a calculator, to maximize your Excel potential.

Build arrays, a key programming data structure, in VBA.

Learn to work with dates to schedule procedures and much more.

Work with the Application object to show progress, read and write data, and more.

Learn to build a table of contents project to organize your worksheets.

Build charts programatically.

And much more!

 

Learning how to code is a great way to jump in a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. Learn it today and get a head start for tomorrow. People who can master technology will rule the future.

Get Tutorial