CONTACT THE BUSINESS LEARNING INSTITUTE
Name*
Email Address*
Phone Number:
Message:
Please enter the following text in the box below:
captcha
ADDRESS: 901 Dulaney Valley Road, Suite 800
Towson, MD 21204
PHONE: 888-481-3500
FOLLOW BLI:
Excel Power User – Automating with Macros (Part 1)COURSE ID: EXCELVBA
DESCRIPTION

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.

DESIGNED FOR: CPAs and Professionals at all levels of an organization who desire to learn automation features within Excel.FIELD OF STUDY: Specialized Knowledge & ApplicationLEVEL: AdvancedPREREQUISITES: Familiarity with Excel featuresCOURSE PRODUCER: Business Learning InstituteCREDITS: 2.0OBJECTIVES:
  • 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
HIGHLIGHTS:

* 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

Download the 2016 Business Learning Institute Course Catalog DOWNLOAD PDF
Business Learning Institute - Course Catalog
SUBSCRIBE TO THE BLI BLOG