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
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 | 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:
  •  
    Event Title: Automating Excel: An Introduction to VBA
    Presenter(s): Mike Thomas

 
 
 
Our Accreditation Partners
DMCA.com Protection Status
×

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or service@proedtech.com. You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.


Best regards,
The ProEdTech Team