My Shopping Cart
 
There are no items in your shopping cart.


Visual Basic for Applications (VBA) - Automate Excel Tasks (IME972Z)

Presented by: Mike Thomas
 
This conference is no longer available
But don't worry, our customer care representatives will help you find an event that meets your needs!
Call on (800) 223-8720
Event Description

Save Time and Effort by Implementing VBA Concepts to Automate Excel

Visual Basic for Applications (VBA) is the programming language that is built into Excel (and other applications in the MS Office Suite). VBA is used to automate tasks that would otherwise have to be performed manually by pressing combinations of keys and selecting items with the mouse, and if that sounds like a macro, 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.

This session by renowned Excel trainer Mike Thomas is aimed at assisting the advanced users of Excel with power excel concepts, including VBA. Even those with little or no programming experience who wish to "dip their toe into the VBA water", can benefit from this session. Knowledge of 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 youd like to learn about the basics of VBA and automation, this session is for you.

Session Highlights

  • Get familiar with the VBA Editor
  • Understand VBA jargon such as procedures, modules, methods and properties
  • Learn to edit an existing macro
  • Learn to write a simple macro from scratch using VBA
  • Create inline documentation
  • Use VBA to control what happens when a file is opened or closed

Who Should Attend

  • Advanced users of Excel, with little or no programming experience
  • Executives from all industries
  • Users of Excel 2016, and also those of the earlier versions of Excel (2013, 2010 and 2007)
About Our Speaker(s)

Mike Thomas | Microsoft Excel Technology Training SpeakerMike Thomas
Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with... More info

 
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Visual Basic for Applications (VBA) - Automate Excel Tasks
    Presenter(s): Mike Thomas

 
DMCA.com Protection Status