Thursday, April 13, 2017

Excel Macro Basics (2-part series)

Attend upcoming webinar and earn continuing education credits.
Live Webinars   |   On-Demand   |   All-Access Plan
Manage Preferences    |    View in Browser
Visit Clear Law Institute
Excel Macro Basics (2-part series)
April
 
27-28
1 pm - 2:40 pm ET each day
Presenter: David Ringstrom, CPA, author and nationally recognized Excel instructor
Credits: CPE (Credit Details)
Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both.
Viewing Options: View on your computer, tablet, or smartphone
Course Reviews: View Testimonials
Can't wait? View previously recorded version now
Learn More
Register Today
Course Description
 
Excel Macro Basics: Part 1
April 27th, 2017, 1:00 PM to 2:40 PM, ET


In this comprehensive webcast, Excel expert David Ringstrom, CPA, introduces you to Visual Basic for Applications (VBA) macros—one of Excel's most powerful features.

You'll learn how to use Excel's Record Macro feature to automate repetitive tasks and create your own keyboard shortcuts for Excel features. In addition, David demonstrates how to manage macro security prompts, how to use Excel's Personal Macro Workbook, and how to convert .XLS workbooks to the up-to-date .XLSX format.

After participating in Part 1 of Excel Macro Basics, you'll be equipped to begin using macros immediately to speed up your work in Excel.

Excel Macro Basics: Part 2
April 28th, 2017, 2017, 1:00 PM to 2:40 PM, ET


In Part 2 of Excel Macro Basics, Excel expert David H. Ringstrom, CPA, guides you beyond the basics of Excel's Record Macro feature. He demonstrates how to enhance the code you've created by adding error-handling features, interactive features, and decision-making capabilities.

In addition, David explains how to:
  • Filter based on cell contents.
  • Simplify what-if analysis with Excel's Goal Seek feature.
  • Play back recorded macros to eliminate repetitive tasks.
  • Create simple macros with the Record Macro feature... and more.

David demonstrates every technique at least twice, first on a PowerPoint slide with numbered steps, and second in Excel 2016. He'll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation, as well as in his detailed handouts.

Course Reviews from Past Attendees

100% of attendees said they would recommend this course to others.
"Very informative."
"Instructor is awesome."
Learn More
Register Today
The Presenter
About The Presenter
 
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.
Learn More
Register Today
All-Access Membership
 
● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 75 live webinars each month
● More than 1,000 on-demand courses
Learn More
Upcoming Webinars
Taxing Policies and Rules for Sales and Use Tax
April 17 at 3 pm ET
Learn More
Implementing Revenue Recognition – Topic 606
April 18 at 1 pm ET
Learn More
Time Saving Techniques with Microsoft Outlook
April 19 at 3 pm ET
Learn More
Questions?
Please call us at 703-372-0550

Our Mailing Address:
Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203
Remove me from future emails.

Manage email preferences.

This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.
 

No comments:

Post a Comment