Microsoft Excel Macros-4-Part Series: Your Key to Success In The Modern Business World

Duration: 480 Minutes
The first part will provide you with a basic understanding of Excel macros. Program participants will learn how to automate repetitive tasks and learn more about Excel's Record Macro feature, discover how to store macros in a Personal Macro Workbook for future use and learn how to create a shortcut on the Quick Access Toolbar. The second webinar in the four-part macros series will offer attendees a deeper understanding of Excel macros. Program participants will learn to create a macro that can automatically remove unwanted rows and columns from reports. Attendees also will become aware of nuances involved in saving workbooks that contain macros. Part 3 of this four-part macros series will explore how to add enhanced decision-making capabilities to Excel macros. Attendees will discover how to create loops in the programming code as well as learn about the IF and SELECT CASE functions. The last webinar in the four-part macros series will discuss UserForms, an aspect of Visual Basic for Applications (VBA) macros.
Microsoft Excel Macros
Instructor: David H. Ringstrom
Product ID: 502007
Microsoft Excel Series - Part 1: Shake Hands with Macros
Recorded Session

Part 1 of this four-part webinar series on Microsoft Excel macros will cover the automation possibilities that Excel macros offer and the nuances of Excel's Personal Macro Workbook. Excel expert David Ringstrom, CPA, will also define how to use Excel's Record Macro feature to automatize repetitive tasks, including cleaning up reports you've exported from an accounting package, creating your own keyboard shortcuts for Excel features and scrubbing your data.

Objectives of the Presentation
  • Convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes
  • Decipher and manage Excel's macro security prompts
  • Discover how to use Excel's Personal Macro Workbook
  • Learn how to use Excel's Record Macro feature to create simple macros, without having any knowledge of programming
  • Learn the risks and frustrations of using merged cells in Excel worksheets
  • Understand how macros are used in Excel, along with the risks and benefits associated with them
*Note: Click Here to Register only for this Webinar

Microsoft Excel Series - Part 2: Learn More about Macros
Recorded Session

Part 2 of the Microsoft Excel macros series presented by Excel expert David Ringstrom, CPA, will define how to adjust Excel's macro security settings. Attendees will learn how to apply an enhanced understanding of Visual Basic for Applications (VBA) macros and how to enhance the code you have created with the Record Macro feature. Excel's Goal Seek feature-which is helpful in simplifying what-if analyses-will be discussed along with how to use form controls to simplify data entry and control the input of other users.

Objectives of the Presentation
  • Identify how to disable a line of programming code
  • Define how to adjust Excel's macro security settings
  • Recognize which rows in a spreadsheet are affected when data is filtered
  • Apply an enhanced understanding of Visual Basic for Applications (VBA) macros
  • List techniques, features, and keyboard shortcuts that will help eliminate repetitive tasks
  • Identify how to enhance the code that's been created with the Record Macro feature
*Note: Click Here to Register only for this Webinar

Microsoft Excel Series - Part 3: Beyond IF and Excel Macros
Recorded Session

This Excel macros training program presented by Excel expert David Ringstrom, CPA, will help attendees apply their extended knowledge of Excel macros. David will define how to create loops within your spreadsheets and explain when to use the SELECT CASE function versus IF statements. Attendees also will learn how to use Breakpoints to simplify debugging errors in the programming code.

Objectives of the Presentation
  • Learn how to add enhanced decision-making capabilities to Excel macros
  • Discover how to create loops in your programming code
  • Learn about the IF and SELECT CASE functions
  • Apply your extended knowledge of Excel macros
  • Identify how to use Breakpoints to simplify debugging errors in your programming code
  • Compare For, Do Until, and Do While for creating loops within Excel macros
*Note: Click Here to Register only for this Webinar

Microsoft Excel Series - Part 4: Creating Custom Excel Interfaces with User Forms
Recorded Session

Part 4 of this Microsoft Excel macros training series presented by Excel expert David Ringstrom, CPA, will explore how to create a UserForm in Excel. It will help attendees identify how to create macro buttons that enable users to display UserForms on demand. The webinar also will define the benefits of using Visual Basic for Applications (VBA) macros and illustrate how to apply the Tag property within UserForm controls.

Objectives of the Presentation
  • State how to create a UserForm in Microsoft Excel
  • Identify how to create macro buttons that enable you to display UserForms on demand
  • Recall how to create custom forms that allow you to better control a user's actions
  • Apply techniques that empower you to create an input form, test and immediately respond to invalid inputs, and then save the resulting data to a worksheet
  • Define the benefits of using Visual Basic for Applications (VBA) macros
  • Apply the Tag property within UserForm controls
*Note: Click Here to Register only for this Webinar


Who can Benefit
  • Banking
  • Finance
  • Insurance
  • Education
  • Telecom
  • IT
  • CPAs
  • CFOs
  • Controllers
  • Marketing
  • Sales
  • Investments
  • Pharmaceutical
  • Medical Devices
  • FDA
  • Aviation
  • Energy
  • Retail
  • Human Resource
  • Logistics and Supply Chain
  • Accountants
  • Audit
Get your group to attend the webinar series at a discounted price call 510-857-5896
$1200
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $1800.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $600.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. He has served as the technical editor for other 30 books on accounting software, and is the Tech Editor-at-Large for Accounting WEB and Going Concern. David offers Excel training and consulting services nationwide.
View More