1. Home
  2. Course
  3. VBA Basic for Excel

VBA Basic for Excel

  

About this Course

Microsoft Excel 2010 is an extremely powerful tool that you can use to manipulate, analyze and present data. Sometimes though despite the rich set of features in the standard Excel User Interface (UI), you might want to find an easier way to perform a mundane, repetitive task or to perform some task that the UI does not seem to address. Fortunately, Office applications like Excel have Visual Basic for Applications (VBA), a programming language that gives you the ability to extend these applications.

Introduction to Excel VBA 2010easily witrh our step by step, practical, hand on workshop in Singapore. 

After attending the Basic Excel VBA training, you will be able to:

  • Understand what is VBA or Macro
  • Record and Run Macro easily
  • Understand what is VBE and tools.


Course Outline :

Lesson 1: Introducing Excel with VBA Programming

  • What is VBA
  • A brief history of VBA
  • What can VBA do for you?
  • Advantages and Disadvantages of VBA
  • Different versions of Excels
  • Know how to run a Excel Macro in 2007/2010
  • How to migrate Excel Macro 2007 to 2010

Lesson 2: Getting Started with Macros

  • Accessing the VBA Environment
  • Recording the Macro
  • Testing the Macro
  • Examining the Macro
  • Modifying the Macro
  • Understanding Macro Security
  • Saving Workbooks that contain Macros

Lesson 3: Introducing the Visual Basic Editor

  • What is the Visual Basic Editor
  • How to get into VBE
  • Understanding the VBE components 
  • Understanding Modules
  • Using the Object Browser
  • Exiting the VBE

Lesson 4: Working in the VBE

  • Toolbars in the VBE
  • Locating Your Macros
  • Understanding the Code
  • Editing a Macro with Comments
  • Deleting a Macro
  • What is a VBA Module 
  • Inserting a VBA Module 
  • Renaming a VBA Module 
  • Deleting a VBA Module
  • Locking and Protecting the VBE

Course Duration : 15 Hours


Target Audience

If you are non-programmer, who likes to understand the basic of Excel VBA programming. 

Pre-requisites

Proficient with relevant working experience in Microsoft Excel.

Certification

Successful trainees will receive Certificate of Attainment from Genetic Computer School

Course Pathway

VBA Advanced for Excel.

Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Similar Courses Provided By Other Premium Providers

  • ICDL Module 5: ES WSQ - Perform Advanced Database Functions (Microsoft Access 2010) Fast Track

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.The exam requires the candidate to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The candidate shall be able to use the database to organize, extract, view and report on data using what are dee...


    Provider:

  • ICDL Module 5: ES WSQ - Perform Advance Database Functions (Microsoft Access 2013 Fast Track)

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what a...


    Provider:

  • Mobile App Creation for End User

    Information and Communications  

    No programming skills required. Come and join us in this one day workshop and learn how you can create a cross platform mobile application in just ONE day.COURSE OUTLINEModule 1.Introduction To The Mobile App IndustryModule 2.Different Kinds of App Marketing ModelsModule 3.Researching & planning your first appModule 4.Publishing Apps Golden RulesModule 5.How to get Images for your appsModule ...


    Provider:

  • Cross-platform Mobile Applications Development

    Information and Communications  

    HTML5 provides developers with tools such as Offline Web Storage, GeoLocation API, Canvas Drawing, CSS3, and many more. HTML5 applications run on Firefox OS, Tizen, Ubuntu Touch, and WebOS without a browser.COURSE OUTLINEModule 1. Mobile Applications OverviewModule 2. Apache Cordova (PhoneGap)Module 3. Cordova apps with EclipseModule 4. jQuery FundamentalsModule 5. jQuery MobileModule 6. Working w...


    Provider:

  • MCSD Web Applications

    Information and Communications  

    Today's customers need high-quality, interactive line-of-business and consumer web solutions. Get recognized for your expertise in creating and deploying modern web applications and services by earning the Microsoft Certified Solutions Developer (MCSD): Web Applications certification. COURSE OUTLINEProgramming in HTML5 with JavaScript and CSS3Developing ASP.NET 4.5 MVC Web ApplicationsDeveloping ...


    Provider: