VBA with Microsoft Excel (v1.2)

by New Horizons Central Claim Listing

This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch.

$655

Contact the Institutes

Fill this form

Advertisement

New Horizons Central Logo

img Duration

1 Day

Course Details

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite.

You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually.

This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch.

You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.

 

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.

  • Write VBA code to create VBA subroutines and functions.

  • Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops.

  • Eliminate, avoid, or handle errors in VBA code, and optimize its performance.

  • Nashville Branch

    220 Athens Way, Suite 150, Nashville
  • Saint Louis Branch

    2122 Kratky Rd, St., Saint Louis

Check out more MS Excel courses in USA

Computer Images Logo

Microsoft Excel

This course covers all of Excel’s essential features and shows you how to use it to prepare budgets, manage and analyze data, and make charts.

by Computer Images [Claim Listing ]
NYIM Training Logo

Excel For Business (Advanced)

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more.

by NYIM Training [Claim Listing ]
Sonic Training, Inc. Logo

Excel Training: Introduction

This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.

by Sonic Training, Inc. [Claim Listing ]
Web Age Solutions Logo

Introduction to Microsoft PowerPoint 2019 Training

This Introduction to PowerPoint 2019 training class is designed for students who are interested in learning the fundamentals needed to create and modify basic presentations using Microsoft Office PowerPoint 2019.

by Web Age Solutions [Claim Listing ]
Training The Street (TTS) Logo

Excel Best Practices for PC: Become an Excel Expert

Whether you’re an investment banker, consultant, accountant, or specialist in healthcare, technology or industrials, this class offers the broadest, most valuable Excel skill set of any of course we offer.

by Training The Street (TTS) [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy