Automating Repetitive Excel Tasks Part 1

Duration: 120 Minutes
In this session Excel expert David Ringstrom, CPA will help you get started with one of Excel's most powerful features. David will introduce you to the concept of macros in Excel, which are a means of automating repetitive tasks. Much of Part 1 of this series focuses on mastering Excel's Macro Recorder, while Part 2 goes beyond the limitations of the macro recorder to empower you to add interactivity, error handling, and decision-making within macros that you create.
Excel Automation
Instructor: David H. Ringstrom
Product ID: 500948

The Macro Recorder is available in all Windows-based versions of Excel, as well as Excel for Mac 2011 and later. This feature transforms actions that you carry out in Excel into programming code that you can play back on demand whenever you need to execute a repetitive task.

Areas Covered
  • Decipher and manage Excel's macro security prompts
  • Discover how to use Excel's Personal Macro Workbook
  • Learn the risks and frustrations of using merged cells in Excel worksheets
  • Learn what a macro is in Excel, along with the risks and benefits
  • See how to use Excel's Macro Recorder to create simple macros without any programming knowledge required
  • Use the Text to Columns feature to eliminate unwanted text without retyping, or to separate text into separate columns
  • Create a macro that automatically removes unwanted rows and data from an accounting report
  • Automatically transform a list of phone numbers with extraneous characters into a consistently formatted list
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
  • Gain a comfort level with Excel's Macro Recorder
  • Understand what's possible by way of macros
  • Discover some of the risks and challenges related to macros
  • Create keyboard or mouse shortcuts for Excel features that don’t offer shortcuts
  • Understand the limitations of Excel’s Macro Recorder
  • Use the Personal Macro Workbook to create a library of automation tools
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.

$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