Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - VBA
Rating: 3.8 out of 5(169 ratings)
713 students

Microsoft Excel - VBA

Extend your knowledge of recorded macros using Excel VBA. Learn about Forms, Loops, Defined Functions and Automation
Created byeLearnExcel
Last updated 9/2013
English

What you'll learn

  • 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 content

9 sections • 55 lectures • 4h 35m total length

  • Introduction1:19

    This section includes the exercise files and sample database for VBA. Please download these before you start the course.

  • Excel Overview1:29
  • Recording a Macro2:39
  • Reviewing Macro Code2:03
  • Overview Of VBA And Office3:18
  • Objects, Methods And Properties11:26
  • Differences Between Office 2003, 2007, 2010 And 20133:31
  • Creating A Macro Enabled Workbook1:40

Requirements

  • Advanced knowledge of Excel

Description

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.

Who this course is for:

  • Users familiar with recording and editing basic macros in Excel who want to go further in automating and customising Excel using VBA – Visual Basic for Applications. No previous programming experience is required but an expert level of Excel use is assumed.

Report abuse