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

Mexican Institute of Greater Houston Logo

Microsoft Excel, Level II Beyond the Basics

Microsoft Excel, Level II Beyond the Basics class is offered by Mexican Institute of Greater Houston. This course was launched as a second level in-depth study of a powerful tracking and calculating tool for everyday tasks.

by Mexican Institute of Greater Houston [Claim Listing ]
Miami Dade College Logo

Microsoft Office Basic

Learn the basics of Word, Excel and PowerPoint including techniques to merge and import documents with other MS Office modules. This new version will encourage users to share data via the cloud for an easier and accessible experience.

by Miami Dade College [Claim Listing ]
The Code Academy Logo

Microsoft Office Specialist 2016 Boot Camp

The Academy’s Microsoft Office Specialist 2016 Boot Camp is a 5-day course that focuses on Word, Excel, and PowerPoint. This course prepares students for Microsoft Exams 77-725 (Word 2016), 77-727 (Excel 2016), 77-729 (PowerPoint 2016).

by The Code Academy [Claim Listing ]
CompuTrain Business Solutions Logo

Microsoft Outlook 365 (Introduction)

This course is the first in a series of two Microsoft® Outlook® 365 courses. It will provide you with the basic skills you need to start using Outlook 365 to manage your email communications, contact information, calendar events, tasks, and notes.

by CompuTrain Business Solutions [Claim Listing ]
American Media Training Logo

Excel Beginner

Microsoft Excel is the premier software application for creating, editing and sharing spreadsheets, with countless practical applications, from financial reporting and general record keeping to operations management and decision support.

by American Media Training [Claim Listing ]

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