Visual Basic for Excel - Microsoft VBA Excel Tutorial

Master Visual Basic for Excel and unlock the true power of Excel with our comprehensive training course by a leading Microsoft Expert.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course teaches you how to use Visual Basic for Excel to supercharge your spreadsheets. No previous programming skills needed! You'll learn to create cool scripts and handle errors, all while making your Excel experience way more powerful.

Key Points

  • Learn the basics of Visual Basic for Applications (VBA)
  • Create custom scripts for Excel spreadsheets
  • Understand Functions vs. Subroutines
  • Manipulate Excel Cells effectively
  • Handle errors in your scripts

Learning Outcomes

  • Become familiar with VBA programming language
  • Create interactive, custom Excel spreadsheets
  • Understand how to manipulate data in cells
  • Learn error handling techniques
  • Work alongside the author with provided files

About This Course

Master Visual Basic for Excel, learn to unlock the true power of Excel. Tutorial Taught by a leading Microsoft Expert

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this Visual Basic for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.

The tutorial extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This Visual Basic for Excel tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.

By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn Visual Basic for Microsoft Excel in this video tutorial.

Course Curriculum

1 Lectures

Instructor

Profile photo of Infinite Skills
Infinite Skills

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.The emphasis is on teaching real life skills that are essential for...

Review
4.9 course rating
4K ratings
ui-avatar of Joey Derden
Joey D.
5.0
1 year ago

Advanced course that was professional designed. A must for those wanting to increase their knowledge of Excel VBA.

  • Helpful
  • Not helpful
ui-avatar of Cengiz ISIK
Cengiz I.
4.5
3 years ago

For the time I've spared, I've received a good amount of knowledge as well as an opportunity to refresh some of my previous knowledge on VBA and Excel. Many Thanks.

  • Helpful
  • Not helpful
ui-avatar of TJ Corlew
Tj C.
5.0
4 years ago

Guy is an EXCELLENT instructor! I was hoping to learn a little bit about VBA when I purchased this course, but ended up learning a GREAT DEAL of valuable information. I would recommend this course to anyone wanting to learn VBA.

  • Helpful
  • Not helpful
ui-avatar of Octavian Grigorie
Octavian G.
4.5
4 years ago

The instructor has a clear way of explaining and the voice is well understood. PROs: This is a great course for beginners. CONs: there are enough examples but more practical examples would help!

  • Helpful
  • Not helpful
ui-avatar of Alan MartĂ­nez
Alan M.
4.0
5 years ago

The course is good to start on VBA, well explained but I would like to have some tests or have some extra exercises, it doesn't matter if extra exercises are not solved in video.

  • Helpful
  • Not helpful
ui-avatar of Dudley Mogensen
Dudley M.
5.0
5 years ago

It was a good course, only think I would like to see is stuff on the pivot tables and charts. However the ground work has been laid. just a matter of how to access all that in code.

  • Helpful
  • Not helpful
ui-avatar of Javier Alpizar
Javier A.
4.5
5 years ago

Great explanations, from basic to more complex topics, if the trainer makes a mistake he corrects himself on the way.

  • Helpful
  • Not helpful
ui-avatar of Vivekanandan P
Vivekanandan P.
4.5
5 years ago

Excellent course ! ! ! The syllabus is well designed and the course is fun to learn. Explanations are clear very good course for persons at basic level too..

  • Helpful
  • Not helpful
ui-avatar of Samuel Downing
Samuel D.
4.5
5 years ago

This course is a great starting point for anyone seeking to learn VBA. However, the true value one gets out of this training is by applying the skills to real world problems. Only with practice can someone get the most out of it.

  • Helpful
  • Not helpful
ui-avatar of Samadhi Ghosh
Samadhi G.
4.5
5 years ago

I wanted to achieve knowledge on VBA for Excel so that I can complete a task in my office and at the same time have concept. I didn't wanted to just copy paste the code that is available on Google or rather express the algorithm with the help of expressions that Excel understand (by referring from sample code) instead I should be able to build the code from scratch or make other modifications when and where needed and I am pretty confident now. Thanks for the beautiful course structure.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses