Automating Repetitive Excel Tasks Part 2

Duration: 120 Minutes
In this session Excel expert David H. Ringstrom, CPA helps you go beyond the Macro Recorder. David first uses the Goal Seek feature in Excel as a means of showing you how to simplify problem solving in Excel, while also adding interactivity and error-checking to macros that you’ve recorded. Go further by adapting recorded macros to work with data sets of varying size and build in decision making capabilities into recorded macros.
Excel macros
Instructor: David H. Ringstrom
Product ID: 500949

Areas Covered
  • Add error handling features to Excel macros to compensate for unexpected or missing data entry inputs
  • Gain an understanding of Excel's Goal Seek feature, which is useful in simplifying what-if analyses
  • Learn how to play back macros that you've recorded so as to automate repetitive or tedious tasks
  • Learn the nuances of Macro-Enabled workbooks in Excel 2007 and later
  • Learn what to do next if a Debug prompt appears
  • See how to enable the Developer tab in Excel 2007 and later
  • See how to use Excel's Macro Recorder to create simple macros without any programming knowledge required
  • Understand the nuances of assigning keyboard shortcuts to macros in Excel and avoid superseding shortcuts for built-in features
  • Create macro buttons that make it easy for users to launch macros within a spreadsheet
Why Should you Attend
Repetitive tasks in Excel often lead to fatigue and raise the risk of errors. Automating tasks by way of macros ensures that the task can be completed far more quickly than by hand, and also ensures that the task is completed in the same fashion every time.

Objectives of the Presentation
  • Master Excel’s Goal Seek feature
  • Get an introduction to Excel’s Visual Basic for Applications programming language
  • Compare and contrast different ways to launch macros
  • Utilize Excel’s Visual Basic Editor to modify programming code that you’ve recorded
  • Enhance your macros with error handling procedures
  • Request information from users that your macros can then act on
Who can Benefit
  • Accountants
  • Analysts
  • Finance Professionals
This webinar is a part of "Webinar Series on Automating Repetitive Excel Tasks" Click here to know more.

Live Session - How it works
  • Username and password will be sent to you 24 hours prior to the webinar
  • Presentation handouts in PDF format will also be emailed to you
  • Login to the session using the username and password provided to you
  • Get answers to your queries through interactive Q&A sessions via chat
  • Send us your feedback at the end of the webinar
  • Get certificate of attendance
Recorded Session - How it works
  • A link will be provided to you upon purchase of the recorded session
  • Please click on the link to access the session
  • Presentation handouts in PDF format will be emailed to you
  • Get certificate of attendance
$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.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