Microsoft Excel - VBA

Enhance your Excel skills with our comprehensive VBA course. Learn about macros, automation, and how to streamline your workflow effectively.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course dives into Excel VBA, teaching how to use recorded macros and automate tasks. You'll pick up skills like working with Forms and Loops, making your Excel life way easier!

Key Points

  • Learn about recorded macros and Excel VBA
  • Discover Forms, Loops, and Defined Functions
  • Understand how to automate tasks in Excel
  • Identify opportunities for automation in data handling
  • Extend your current Excel skills with powerful techniques

Learning Outcomes

  • Become comfortable with using VBA for automation in Excel
  • Identify repetitive tasks that can be automated
  • Create and use Forms and Defined Functions in Excel
  • Gain skills to clean and manage data more efficiently
  • Develop a strong foundation to explore more advanced Excel features

About This Course

Extend your knowledge of recorded macros using Excel VBA. Learn about Forms, Loops, Defined Functions and Automation

The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.

  • If you are performing repeated actions on workbooks or sheets, it may be possible to automate that work. Importing data, cleaning that data, archiving existing information and similar activities are good candidates for automation in Excel. VBA provides extra options for developers looking to automate Excel.

Course Curriculum

1 Lectures

Instructor

Profile photo of eLearnExcel
eLearnExcel

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms. Some of the world’s most prominent businesses choose us to teach their employees Excel – including...

Review
4.9 course rating
4K ratings
ui-avatar of Mohammad Sam
Mohammad S.
4.5
6 years ago

I learned a lot from this course and I recommend it to those who have a basic knowledge about VBA.

  • Helpful
  • Not helpful
ui-avatar of Henry Cooper
Henry C.
4.5
6 years ago

It's good to see the basics since I've never been taught them.

  • Helpful
  • Not helpful
ui-avatar of Enkhmaa Erdene-Ochir
Enkhmaa E.
2.0
7 years ago

The course name is not consistent with the class. It did not go much further with VBA.

  • Helpful
  • Not helpful
ui-avatar of Kim Collins
Kim C.
4.0
7 years ago

Simple concepts are demonstrated clearly.

  • Helpful
  • Not helpful
ui-avatar of Jake Habel
Jake H.
3.0
7 years ago

The description is somewhat misleading. I thought that this was going to be an add-on to the previous course that I took that was offered by Mark Talbert; however, this is very repetitive information that is being presented.

  • Helpful
  • Not helpful
ui-avatar of Hirokazu Abe
Hirokazu A.
4.0
7 years ago

Concise explanation

  • Helpful
  • Not helpful
ui-avatar of Rick grainger
Rick G.
4.0
7 years ago

VEry well spoken and very good!!!!

  • Helpful
  • Not helpful
ui-avatar of James Megliola
James M.
2.0
7 years ago

There was no file to import. There was no raw data to enable the data cleaning macro so it threw off the original macro. Made it tougher to follow. Also, you should provide the original sheet that the instructor is using and the completed one so that we can follow along and update as the instructor is doing.

  • Helpful
  • Not helpful
ui-avatar of Eric Hawkes
Eric H.
5.0
7 years ago

Just what I was looking for.

  • Helpful
  • Not helpful
ui-avatar of Xinning
Xinning
3.5
7 years ago

The instruction of the material was great, but could be improved by increasing the responsiveness. Nobody has yet respond to a query that was posted a year ago for the text file, for us to follow the course.

  • 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