Excel - Automation - VBA & Macros 101

6 years ago Posted By : User Ref No: WURUR18582 0
  • Image
  • TypeWebinar
  • Image
  • Location Denver, Colorado, United States
  • Price
  • Date 23-03-2018
Excel - Automation - VBA & Macros 101, Denver, Colorado, United States
Webinar Title
Excel - Automation - VBA & Macros 101
Event Type
Webinar
Webinar Date
23-03-2018
Last Date for Applying
23-03-2018
Location
Denver, Colorado, United States
Organization Name / Organize By
Training Doyens
Organizing/Related Departments
Training Doyens
Organization Type
Organization/Company
WebinarCategory
Both (Technical & Non Technical)
WebinarLevel
All (State/Province/Region, National & International)
Related Industries

Education/Teaching/Training/Development

Business Development

Finance

Accounting/Financial/Banking/Insurance

Location
Denver, Colorado, United States

OVERVIEW

VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse - and if that sounds like a macro - well it is.

Although Excel has a macro recorder, there's a limit to what it can do. So where the macro recorder's functionality ends, VBA takes over. At a more advanced level, VBA enables you to, amongst other things, build your own worksheet functions, create automated workflows and control and interact with other applications.

WHY SHOULD YOU ATTEND

VBA is one of the must have skills for Excel Power Users. VBA will save you, your colleagues, and your customers hours of time by allowing you to automate any Excel-based task or process. If you've never used VBA before and you'd like to learn about the basics of VBA and automation, this webinar is for you.

AREAS COVERED

Session highlights include…

  • Getting familiar with the VBA Editor
  • Understanding VBA jargon such as procedures, modules, methods and properties
  • How to edit an existing macro
  • How to write a simple macro from scratch using VBA
  • Creating inline documentation
  • Using VBA to control what happens a file is opened or closed

LEARNING OBJECTIVES

This webinar is aimed at advanced users of Excel, with little or no programming experience, who wish to "dip their toe into the VBA water"

WHO WILL BENEFIT

This webinar gets you started with VBA. It's aimed at advanced users of Excel, with little or no programming experience, who wish to take their level of automation knowledge beyond the macro recorder. This training is relevant to all industries. It is not industry specific.

Although the training will be delivered using Excel 2016 for Windows, it is just as relevant to users of earlier versions of Excel (2013, 2010 and 2007)

 

For more detail please click on this below link:

https://goo.gl/sce65E

 

Email: [email protected]

Toll Free: +1-888-300-8494

Tel: +1-720-996-1616

Fax: +1-888-909-1882

Others Details

Learn about VBA,the programming language that is built into Excel, and become an Excel power user

Registration Fees
Available
Registration Fees Details
Live Session for one participant $159 Corporate Live Session Group – Max 10 Participants from one location. $449 Recorded Session Get unlimited access to audio recording of the webinar for 6 months. $199 Training DVD or USB Flash Drive MP3 files, PDF presentation and reference manual will be delivered on a CD $379 Super Combo Offer 1 Live and Recorded webinar $289 Super Combo Offer 2 Live and Training CD $429
Registration Ways
Email
Phone
Website
Other
Address/Venue
  26468 E Walker Dr, Aurora, Colorado 80016-6104  Pin/Zip Code : 80016
Landmark
Colorado
Official Email ID
Contact
Training Doyens

26468 E Walker Dr, Aurora, Colorado 80016-6104

[email protected]

   7209961616
Training Doyens

26468 E Walker Dr, Aurora, Colorado 80016-6104

[email protected]

   7209961616    Fax No: Colorado City