New MACPA.org Launching 4/1! Stay tuned for a brand new online experience.

Cancelled: Excel Power User -Automating with Macros (Part 1) (17W233-16)

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.

Learning Objectives
  1. Record and run macros related to data cleanup and other features
  2. Add and edit macro code in the Visual Basic Editor that that cannot be recorded
  3. Work with the Message Box and the Input Box
  4. Use the Visual Basic tools on the Developer Ribbon tab
Major Topics
  1. Explore the uses of the macro recorder for data cleanup
  2. Work with visual basic code in the visual basic editor
  3. Edit visual basic code
  4. Incorporate decision-making code examples
  5. Incorporate code for repetition
  6. Use custom message boxes
  7. Use custom input boxes
Provider
Business Learning Institute
Course Level
Advanced
CPE Field of Study
Specialized Knowledge and Applications*
2
Instructor(s)
Judy Borsher
Prerequisites
Familiarity with Excel features
Location
Online
Event Information
When
Mar 8, 2016
8:00 am - 10:00 am EST
Location
Online
Total CPE Credits
2
Format
Webcast Replay

Register for this Event

Cancelled: Excel Power User -Automating with Macros (Part 1) (17W233-16)


Loading
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×