My Profile   |   Contact Us   |   Your Cart   |   Sign In
Webcast: Excel Macros: Easier Than You Think (CAEME15)
Tell a Friend About This EventTell a Friend
 

Do you shy away from Excel's built-in macro capabilities? If so, you should know that harnessing their power is easier than you think. Learn some quick tips and easy guidelines, from cell formatting to adding formulas to a worksheet, that will help eliminate your macro reservations and save you valuable time.

8/31/2015
When: 08/31/2015
1:00 PM until 4:00 PM
Where: Webcast
Louisiana
United States
Presenter: Karl Egnatoff, CPA


Online registration is closed.
« Go to Upcoming Event List  

Registration Fees
Members $70
Non-Members $94

CPE: 2 hours
Level: Intermediate
Vendor: CalCPA
Category: Specialized Knowledge and Applications
Prerequisites: Basic understanding of Excel.
Advanced prep: None

Who should attend: Accountants and other professionals who want to learn how to write macros in Excel.

Do you shy away from Excel's built-in macro capabilities? If so, you should know that harnessing their power is easier than you think. Learn some quick tips and easy guidelines, from cell formatting to adding formulas to a worksheet, that will help eliminate your macro reservations and save you valuable time.

Objectives

  • Determine uses of macros and how they can save effort and add accuracy.
  • Identify the basic steps to build and implement an Excel macro.
  • Recall the capabilities and limitations of using the Macro Recorder versus writing macros in the Visual Basic Editor.
  • Recognize how to manage macros, including copying and deleting macros.


Major Topics
  • Build and implement macros
  • Macro Recorder tips and tricks, including relative versus absolute references and End + Down and CTRL + End to operate on variable ranges of data
  • Storing macros and the Personal Macro Workbook
  • Deleting macros
  • Visual Basic for Applications and Visual Basic Editor

 



Community Search
Sign In


Forgot your password?

Not a member? Join now!

News & Tax Alerts
CPE/Events

Society of Louisiana
Certified Public Accountants

2400 Veterans Memorial Blvd., Suite 500
Kenner, LA 70062-4739

504.464.1040
800.288.5272 Map/Directions


Advertise/Exhibit

Classifieds

CPA Locator

Press Room

Staff Directory

Facility Rental

Privacy & Terms

About LCPA