Acumen IT Training, Inc.

  • +63 917 714 4350 or DUO: (02) 7971 5203
  • 11th Floor, SM Aura Office Tower, 26th Street, Mckinley Parkway, Fort Bonifacio, Taguig City, Metro Manila, Philippines
Facebook Twitter Linkedin Instagram
  • +63 917 714 4350 or DUO: (02) 7971 5203
  • Main: 11th Floor, SM Aura Office Tower, 26th Street, Mckinley Parkway, Fort Bonifacio, Taguig City, Metro Manila, Philippines
    Satellite Office: 2nd Floor, Bonifacio Technology Center, 31st St. cor. 2nd Ave., Bonifacio Global City, Taguig City​
Facebook Twitter Linkedin Instagram

EXCEL VBA

COURSE DESCRIPTION

Creating similar spreadsheets with different data from scratch, for every report that your company processes would add up to an endless number of repetitive steps. Applying VBA to your spreadsheets automates repetitive tasks and deploys custom company-wide functions to increase your productivity, and allows you to easily manage creating large quantities of spreadsheets.

COURSE DURATION - 2 Days

PRE-REQUISITES

Knowledge of the basics of Excel, including how to create, edit, format and print worksheets that include charts and sorted and filtered data. Students are recommended to first take the following courses or having equivalent knowledge: Excel Basic and Excel Advanced

TARGET AUDIENCE

This course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA).

COURSE OUTLINE

  • Developing Macro
  • Formatting Worksheet using Macro
  • Creating an Interactive Worksheet
  • Working with Multiple Worksheet
  • Performing Calculations

For FULL COURSE OUTLINE, please contact us.

Please contact us for the schedules and for booking a private class.

Inquire Now
Back
;