Excel VBA/Macros foundations for beginners

A Beginner’s Roadmap to Learning Excel VBA !

Learn step by step how to automate your spreadsheets using the power of programming in Excel!

What you’ll learn

  • By the end of the course, You will have developed a solid foundation in Excel VBA that will enable you to tackle more advanced topics in Excel VBA with ease..
  • Learn how to deal with cells, worksheets, workbooks, and other objects in Excel using the VBA Language.
  • Learning one programming language can help you learn other programming languages as well!.

Course Content

  • Introduction –> 9 lectures • 39min.
  • Exploring the Visual Basic Environment –> 7 lectures • 19min.
  • The Range Object –> 12 lectures • 55min.
  • Understanding the Cells collection object –> 5 lectures • 16min.
  • Working with Sheets/Worksheets –> 7 lectures • 31min.
  • Understanding Variables in Excel VBA –> 9 lectures • 58min.
  • Dealing with Workbooks –> 6 lectures • 28min.
  • Must Know Excel VBA Logic –> 16 lectures • 1hr 13min.
  • Looping in Excel VBA –> 14 lectures • 54min.
  • Interacting with your users –> 10 lectures • 39min.
  • Error Handling in Excel VBA –> 6 lectures • 31min.
  • Triggering code with Events! –> 28 lectures • 1hr 49min.

Excel VBA/Macros foundations for beginners

Requirements

  • You should be an intermediate user of Excel.
  • You need to know how to write formulas, use pivot tables and draw charts..
  • You need to have Excel 2007 or later.

Learn step by step how to automate your spreadsheets using the power of programming in Excel!

This course is designed to teach beginners who have no background in programming how to program in Excel VBA!

What you need before taking this course

  • The will to learn !
  • You need to be at least an intermediate user of Excel, know how to write formulas, draw charts and use pivot tables.

A Powerful Skill at Your Fingertips

Learning how to program in Excel will increase your market value and allow you to save time on your spreadsheets.

It will also be a great way to tap into the world of programming, and will help lay the foundation in case you need to learn any other programming language!

Who is the target audience?

This course is targeted towards beginners who want to start learning how to program in Excel.

If you don’t know anything about Macros/VBA language, then this course is for you.

If you can only record Macros, but don’t know how to write VBA code, then this course is for you as well.

If you already know how to write VBA code, including IF statements,Loops, and use Events, then this course isn’t for you.

You need to be someone who knows his way around Excel and knows how to write formulas,use pivot tables, and draw charts.

 

Get Tutorial