Applying Macros in Excel Spreadsheet - NASBA CPE 1.5

  • Speaker:David H. Ringstrom, CPA
  • Duration:90Min
  • Product Code:GRC-90363
  • NASBA CPE: 1.5

Live Session - How it works

  • Username and Password will be sent to you within 24 hours prior to the webinar.
  • Presentation handouts in pdf format will be emailed to along with the login instructions or few hours before the meeting starts.
  • Login to the session by clicking on “Join the Meeting” in the login instructions and then dial the number to connect to the meeting audio or use your Computer to connect to audio. Please use the name and the email address you used at the time of registration to join the meeting.
  • Get answer to your queries through interactive Q&A sessions. The Q and A sessions are at the end of the meeting. The expert will complete his/ her presentation and then the phone lines will be open for the audience to discuss your questions.
  • Please let us know your thoughts and views at the end of webinar, your valuable feedback will help us improve our Training programs.
  • Certificate of attendance is emailed to you within 6 working days from the date the webinar was completed. If you don’t receive an email within 6 days. Please email our support@grcts.com

Recorded Session - How it works

  • Login Information with Password to view the webinar will be emailed to you within 48 hours from the date the Live webinar was completed. The link to the recording is for a single person use only and it is valid for 6 months or the actual duration the recording was purchased.
  • Please click on the link to access the Recording and type in the password provided in the email.
  • Presentation and other handouts will be emailed to you in a pdf format.

Training CD - How it works

  • Free shipment within 2 working days, from the date the webinar was completed. The presentation and other handouts will be emailed to you in a pdf format if we are unable to attach them in the CD or USB.

(For more information about our products contact +1- 248-233-2049)

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. 

Certifications

NASBA CPE Certification - 1.5 CPE

Group Internet Based | 1.5 (1 CPE for 50 minutes) | Computer Software & App - 1.5CPE (1.5 CPE) | Specialized Knowledge - 1.5CPE (1.5 CPE) | Intermediate | Prerequisites - None| No advance preparation.

Description: 

This webcast is designed to teach Excel users how to create and implement macros. David introduces you to the concept of macros as well as to the Visual Basic for Applications (VBA) macro. You’ll learn how to use the Record Macro feature and the Personal Macro Workbook, manage Excel’s macro security prompts, and more. After participating is this webcast, you’ll be equipped to begin utilizing macros immediately.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation and in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

What will be Covered:

  • Discovering how to use Excel’s Personal Macro Workbook.
  • Deciphering and managing Excel’s macro security prompts.
  • Converting .XLS workbooks to the up-to-date .XLSX format with just two keystrokes.
  • Understanding how macros are used in Excel, along with the risks and benefits associated with them.
  • Learning the risks and frustrations of using merged cells in Excel worksheets.
  • Learning how to use Excel’s Record Macro feature to create simple macros, without having any knowledge of programming.

Learning Objectives:

  • Apply Visual Basic for Applications (VBA) macros in Excel.
  • Define how to use the Record Macro feature.
  • Apply the Hide and Unhide commands in an Excel Personal Macro Workbook as needed.

Who will benefit:

Practitioners seeking to understand the concept of macros and gaining experience with VBA macros and the Record Macro feature.

  • Payroll Professionals
  • Human Resources
  • Accounting Personnel
  • Finance
  • Banking
  • Business Owners, Officers, Managers and Key Personnel
  • Lawmakers, Attorneys, or any individual or entity that must deal with the complexities and technicalities within the payroll process
  • Anyone who is interested in improving Excel Skills

Instructor:

Nationally recognized Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, later he began teaching continuing education classes as well. His mission since is to offer quality training and consulting services on Microsoft Excel via live webcasts, on-demand self-study webcasts, and in-house engagements. David has taught hundreds of webinars on Excel and other topics, in addition to speaking at conferences and in-house engagements.

David has developed training courses based on his 25 years of experience in Consulting. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what many users don’t know but should know about Microsoft Excel.

His mission is to offer quality training on Excel and additional accounting software via live webcasts, on-demand self-study webcasts, and in-house engagements. More than 24 providers, located throughout the country as well as overseas, now look to David for their Excel and accounting software training needs.
David’s Excel courses cover the gamut of the software’s features and functions to provide CPAs as well as accounting and financial professionals the knowledge they need to work more efficiently and effectively in Excel. His comprehensive yet easy to understand presentations cover Excel 2016, 2013, 2010, and 2007. David’s webcasts are fast paced, and he welcomes attendees’ questions. In addition, his detailed handouts and slides serve as handy reference tools students can fall back on after participating in his webcasts or taking his self-study courses.

Available Options

Recording: 6 Months Access to the Training which can be accessed from any location

$229

Recording Access to 8 Members: 6 months access to 8 participants. Recording can be accessed from any location

$749

CD-DVD: Shipped within 2 working days

$349

USB - Shipped within 2 working days

$389

5 Member Group: 5 people can Attend the Live Online Meeting from any location globally

$2,679

10 Member Group: 10 people can Attend the Live Online Meeting from any location globally

$4,659

Related Products

Financial Modeling with Excel Tools or Dashboard Reporting and Balanced Scorecards |  NASBA CPE - 1.5

Financial Modeling with Excel Tools or Dashboard Reporting and Balanced Scorecards | NASBA CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. CertificationsNASBA CPE Certification - 1.5 CPEGroup Internet Based | 1.5 (1 CPE for 50 minutes) | Computer Software & App - 1.5CPE (1.5 CPE) | Specialized Knowledge - 1.5CPE (1.5 CPE) | Intermediate | Prerequisites - None|..

$249

Excel PivotTables - Analyze lists in a flash with PivotTables - CPE- 1.5

Excel PivotTables - Analyze lists in a flash with PivotTables - CPE- 1.5

 If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.    Description: Although Excel has many tools, like sorting and filtering, to manage large lists of data, if you need to analyze all that data and do it fast, there’s no better feature than a PivotTable. You ..

$149

Excel Data Management Features: Manage Data with Sorting, Filtering and other useful tools

Excel Data Management Features: Manage Data with Sorting, Filtering and other useful tools

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. Description: You can do more with Microsoft Excel worksheets than just calculate data -- you can tackle powerful data management needs with ease too! With just a bit of know-how, you can take advantage of the power of Excel to valida..

$189

Business Email Etiquette: Learn to Process, Route, and Respond in a Timely Manner - NASBA Certificate

Business Email Etiquette: Learn to Process, Route, and Respond in a Timely Manner - NASBA Certificate

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. Certification: NASBA CPE - 1.5Group Internet Based | 1.5 (1 CPE for 50 minutes) | Business Management & Organization - (1.5 CPE) | Basic to Intermediate| Prerequisites: Must have basic Knowledge| Advanced Preparation: Must..

$229

Outlook on Steroids: Tips and Techniques for the Advanced User - NABSA HR CPE - 1.5

Outlook on Steroids: Tips and Techniques for the Advanced User - NABSA HR CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. NASBA CPE - 1.5 | Field - HRDescription:Outlook is a powerful productivity tool and can be treated as a programming tool. The savvy users of Outlook can program its features to be more productive – taking into account their job desc..

$269

Time and Task Management – Working Smarter Every Day - NASBA HR CPE - 1.5

Time and Task Management – Working Smarter Every Day - NASBA HR CPE - 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.Certifications: NASBA : Group Internet Based | 1.5 (1 CPE for 50 minutes) | HR (1.5 CPE) | Intermediate | Prerequisites - None | No advance preparationBackground:Background of the topic if any Take ..

$249

Creating and Implementing Dynamic Excel Dashboards - NASBA Certification

Creating and Implementing Dynamic Excel Dashboards - NASBA Certification

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.Certification: NASBAGroup Internet Based | 1.5 (1 CPE for 50 minutes) | Accounting - 1.5CPE (1.5 CPE) | Finance- 1.5CPE (1.5 CPE) | Intermediate | Prerequisites - Excel Knowledge | No advance preparation.Description: Excel ..

$189

Payroll Techniques and Analysis - HRCI CPE 1.5

Payroll Techniques and Analysis - HRCI CPE 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. HRCI CPE - 1.5HR (General) recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recer..

$259

Leave Work on Time: Outlook Productivity Tools - NASBA CPE

Leave Work on Time: Outlook Productivity Tools - NASBA CPE

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com.  Topic description:  What if you could leave the office on time every night with a calm feeling that you are in control of your tasks and deadlines, leaving you space for your personal life?  You can leave work on..

$225

Excel Charts and Graphs - NASBA and SHRM 1.5

Excel Charts and Graphs - NASBA and SHRM 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. CertificationSHRM PDCs - 1.5GRCTS is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for [1.5] PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information ab..

$249

Move From An Operational Manager to A Strategic Leader - HRCI and SHRM credits 1.5

Move From An Operational Manager to A Strategic Leader - HRCI and SHRM credits 1.5

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. Certifications: SHRM PDCs - 1.5GRCTS is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM. This program is valid for [1.5] PDCs for the SHRM-CPSM or SHRM-SCPSM. For more inform..

$259

Auditing Your Excel Spreadsheets - NASBA CPE 1.5 Hours

Auditing Your Excel Spreadsheets - NASBA CPE 1.5 Hours

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the Recording of the Training for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. Certification: NASBA CPE - 1.5Group Internet Based | 1.5  hours (1 CPE for 50 minutes) | Computer Software & Applications (1.5 CPE) | Intermediate | Prerequisites - Experience Working with Excel Spread..

$2659

Project Management Best Practices: Completing Every Project On Time and On Budget

Project Management Best Practices: Completing Every Project On Time and On Budget

If you are unable to attend the meeting Live then you can opt in for the Live Recording instead. Access the recording of the webinar for 6 months. Contact our support for any questions. To prepare an invoice to pay by Check or Wire email us at support@grcts.com. Background: Managing projects can be a big headache sometimes; well, our Webinar is the perfect prescription!  Our Webinar will provide the best practices of managing projects – you will receive tools, techniques and bes..

$425