Print Page   |   Contact Us   |   Sign In   |   Join
Excel Macros: Easier Than You Think (4152812A)
View Registrations 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
12:00 PM - 3:00 PM
Where: Webcast/Webinar
Presenter: Karl Egnatoff, CPA
Contact: April Deneault
801-834-6634


Online registration is closed.
« Go to Upcoming Event List  

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 Subjects:

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

 

Designed For:

Accountants and other professionals who want to learn how to write macros in Excel.
 

Prerequisite: None

 

Advanced Prep: Basic understanding of Excel.

  

Speaker: Karl Egnatoff, CPA

Vendor: CalCPA

Field of Study: Info Tech

Level:  Intermediate

CPE Credit: 2 hours

Acronym: EME

 

Registration Fees:

Members: $70

Nonmembers: $94

 

Meet the Speaker:

Karl Egnatoff is a Certified Public Accountant (CPA) based in the Charleston, West Virginia area. He has worked as a consultant, trainer and programmer related to financial and business technology projects for the past 17 years. Prior to this, Karl worked in public accounting as well as in private sector accounting for a period of approximately six years. In addition to being a CPA, he is also a Certified Information Technology Professional (CITP). Karl is a member of the West Virginia Society of Certified Public Accountants, the American Institute of Certified Public Accountants, and the Information Technology Section of the American Institute of Certified Public Accountants. He has also achieved a number of technology certifications including Microsoft Certified Professional (MCP), Certified Software Engineer (CSE) and Certified Integration Developer (CID). During the course of his career, Mr. Egnatoff has owned and operated a number of successful businesses. All of these were business technology entities that provided consulting and training services. The experience he garnered while with these organizations serves him now as he teaches continuing professional education in association with K2 Enterprises. Karl graduated from Marshall University with a Bachelor of Business Administration degree. During his time in college he participated in division I Cross County competing on the varsity squad. He was also on Marshall’s Track team. Karl and his wife Lana live in Milton, West Virginia and have been married for twenty-two years. They have two sons, Jordan age 20, Steven age 18.

Membership Management Software Powered by YourMembership  ::  Legal