VBA with Microsoft Excel

About this course

Automate Excel with VBA in one day. You will record macros, write VBA code directly, solve problems with code and improve its quality.

What you'll learn

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

Curriculum

Who it's for

Excel users ready to automate.

Before you start

• To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.