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.


LEARNING OBJECTIVES
  • Upon completion of this course, participants will be able to:
  • Record and run macros related to data cleanup and other features
  • Add and edit macro code in the Visual Basic Editor that that cannot be recorded
  • Work with the Message Box and the Input Box
  • Use the Visual Basic tools on the Developer Ribbon tab

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.

FIELD OF STUDY
Specialized Knowledge & Application

PREREQUISITES
Familiarity with Excel features

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
2.0

LEVEL
Advanced

This course is available for your group as:

Webcast
 

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