Seminar In-Depth
Excel Macros - Part I
Course Description

You have used Excel for years and Lotus prior to that. During this time, you have said repeatedly, "One day, I'll learn how to write macros." Well, that time has arrived because this four-hour program will introduce you to the wide world of macros and Visual Basic for Applications (VBA) in Excel.

Designed for those with little, if any, experience working with macros, this course teaches the fundamentals of creating and working with macros in Excel. In this seminar, you will learn how to use Excel's Macro Recorder to write simple, yet effective, macros; how to secure and share macros with other Excel users; how to create user-defined functions to solve specific accountant-centric problems in Excel; and how to create macros that run automatically when a user opens a workbook. You will also learn the basics of VBA, including many necessary elements to write macros that can make you and your team more effective and productive with Excel. Don't miss this unique opportunity to learn how to begin working with macros - one of Excel's most powerful tools.

 

This seminar is new for 2010.

Course Information

CPE Credit:

Recommended for 4 hours Specialized Knowledge and Applications

Instructional
delivery method:

Group-live demo and discussion using color computer projection - NOT a hands-on course 

Prerequisites:

None

Program level:

Basic

Advanced preparation:

None

Designed for:

Accountants who want to learn how to write macros in Excel 

Who should attend:

Accountants in all facets of the profession seeking to extend Excel's functionality with simple, yet highly-effective, macros 

Course Highlights
  • Understanding how to take advantage of Excel's built-in Macro Recorder
  • Learning the proper location for storing various types of macros
  • Optimizing Excel's Macro Security settings
  • Creating macros that run when a workbook is opened
  • Introducing Visual Basic for Applications
  • Sharing macros with other users
  • Creating user-defined functions in Excel
  • Attaching macros to icons for one-click access
  • Receiving access to a library of Excel macros designed specifically for accountants
Dates & Locations
Event Date: Location: Sponsor Name:
5/20/2010 MA Massachusetts Society of CPAs
5/24/2010 Malvern, PA Pennsylvania Institute of CPAs Foundation
5/26/2010 Cranberry Township, PA Pennsylvania Institute of CPAs Foundation
6/9/2010 Ridgeland, MS Mississippi Society of CPAs
6/28/2010 Kansas City, KS Kansas Society of CPAs
7/20/2010 Missoula, MT Montana Society of CPAs
7/29/2010 New York, NY New York State Society of CPAs
8/9/2010 Phoenix, AZ Arizona Society of CPAs
9/20/2010 MN Minnesota Society of CPAs
9/28/2010 Pelham, AL Alabama Society of CPAs
10/20/2010 Roseland, NJ NJSCPA Education Foundation, Inc.
10/25/2010 Baton Rouge, LA Society of Louisiana CPAs
11/3/2010 Albuquerque, NM New Mexico CPA Foundation
11/10/2010 NC North Carolina Association of CPAs
11/19/2010 Greenville, SC South Carolina Association of CPAs

CONTINUING PROFESSIONAL EDUCATION FOR ACCOUNTING AND FINANCIAL PROFESSIONALS

K2 Enterprises | 1250 SW Railroad Avenue - Suite 240A | Hammond, LA 70403 | (985) 542-9390

© 2009 K2 Enterprises | Email Us| Site Map