Course ID: EXCELVBA

Excel Power User – Automating with Macros (Part 1)

Judy Borsher demonstrates data cleanup topics using the Excel macro recorder and also how to edit visual basic code to accomplish macro steps that cannot be recorded such as IF testing and repetition. Many easy to follow tips are given to enhance your work with Excel 2007, 2010, or 2013.


MAJOR TOPICS
  • Explore the uses of the macro recorder for data cleanup
  • Work with visual basic code in the visual basic editor
  • Edit visual basic code
  • Incorporate decision-making code examples
  • Incorporate code for repetition
  • Use custom message boxes
  • Use custom input boxes

DESIGNED FOR
CPAs and Professionals at all levels of an organization who desire to learn automation features within Excel.

PREREQUISITES
Familiarity with Excel features

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
2.0

LEVEL
Advanced

This course is available to be scheduled as:

Webcast - 2 hour
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org