Курсове и сертификати > Съдържание на курса

VBA in Excel Macros

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel®. You will be able to automate a wide range of tasks involving the collection, processing, analysis, and visualization of data.

Skip to Available Dates

Learning Objectives

In this course, you will develop and deploy VBA modules to solve business problems. You will:

  • Identify general components of VBA and their appropriate use in solving business solutions.
  • Record VBA macros to automate repetitive tasks.
  • Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
  • Write VBA code to create a custom worksheet function.
  • Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
  • Control how and when macros run.
  • Develop UserForm objects to create custom dialog boxes and windows.
  • Use VBA to read and write data from local files and cloud services.
  • Use VBA to clean and transform data.
  • Run programs and commands outside of Excel and share VBA projects with other users.

     

    Course Details

    Course Outline

    1 - GETTING STARTED
  • Recording a Macro
  • Saving a Macro-Enabled Workbook
  • Running a Macro
  • Understanding Macro Security
  • Editing a Macro in the Visual Basic Editor
  • Understanding Modules
  • Understanding Procedures
    • 2 - UNDERSTANDING OBJECTS
  • Understanding Objects
  • Understanding Excel Object Hierarchy
  • Understanding Collections
  • Working with Properties
  • Using the With Statement
  • Working with Methods
    • 3 - WORKING WITH WORKSHEETS
  • Working with Worksheets
  • Worksheet’s methods
  • Worksheet’s properties
    • 4 - USING EXPRESSIONS, VARIABLES AND CONTROL STRUCTURES
  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Understanding Control-of-Flow Structures
  • Using the If...End If Decision Structures
  • Using the Select Case...End Select Structure
  • Using the For...To...Next Structure
  • Using the Do...Loop Structure
    • 5 - WORKING WITH INTERACTIVE MACROS
  • The MsgBox function
  • The InputBox function

    • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand.

    VBA in Excel Macros

    €495
    Course Length : 3 Days
     

    1. Choose a Date | 2. Click Enroll Now

     PDF Outline With Dates     PDF Outline

    Need Help Picking the Right Course? Give us a call! +359 2 421 0040