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


Automating Excel: An Introduction to VBA (IME950R)

Presented By : Mike Thomas
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Tue, September 22, 2015
Event Description
See the sneak peek before you buy!
 
1.0 CPE

Learn how to save yourself, colleagues and customer's time and money!

Excel's Macro Recorder lets you automate repetitive tasks, providing you more time for the important things in life. However, the Macro Recorder has a lot of limitations - and that is where VBA (Excel's automation language) takes over.

VBA is one of the "must have skills" for Excel "Power Users" and this 1-hour webinar with expert speaker Mike Thomas will teach you how to take your automation skills to the next level. The session is aimed at non-programmers and those who have dabbled with the macro recorder.

This session will offer you a tour of the VBA Editor, including commonly used VBA procedures such as the Variables, Logic and Loops. You will learn to add comments and notes to your code and troubleshooting methods to follow when all goes wrong. By following the real-world examples of how to automate tasks in Excel, you will learn how to save yours and your colleagues and customers' time and money. Also, you will get example worksheets and VBA codes to use.

Session Highlights:

  • Jargon-busting: Collections, Objects, Methods and Properties.
  • A tour of the VBA Editor
  • Adding comments and notes to your code
  • Writing your first VBA Procedure.
  • Commonly used VBA elements: Variables, Logic and Loops.
  • Troubleshooting - what to do when it all goes wrong.
  • The Macro Recorder - when should I use it?
  • Roll your own Excel Function

 Who should attend?

Any user of Excel for Windows or Excel for Mac who wants to learn the basics of VBA in order to automate repetitive tasks. The training is done keeping in mind the non-programmers who have intermediate-to-advanced knowledge of Excel.

About Our Speaker(s)

Mike Thomas, Excel Tutorial ExpertMike 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: Automating Excel: An Introduction to VBA
    Presenter(s): Mike Thomas

 
DMCA.com Protection Status