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.
|
CPE Credit: |
Recommended for 4 hours Specialized Knowledge and Applications |
|
Instructional |
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 |
- 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
| 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 |