In this session Excel expert David Ringstrom, CPA helps 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 gives you some hands on experience with editing and writing programming code in Excel. Excel's Macro Recorder feature is easy to get started with, but those unaware of its nuances will quickly become frustrated with its vagaries. David will show you the ins-and-outs so that you can get started with automating your own repetitive tasks today. Davids materials cover Excel 2016, 2013, 2010, and 2007. When applicable, some slides include alternate instructions for Excel 2003. In this presentation, he demonstrates techniques in Excel 2010, as he finds its presently the version most widely utilized by Excel users. Davids detailed handouts serve as reference tools you can fall back on after completing one of his courses. He also provides an Excel workbook that includes a majority of the examples he uses during each session.
Identify how to prevent macros from being discarded from workbooks when saving. Recall how to use the Unhide command to locate and manage Excel's Personal Macro Workbook. Define how to create general use macros with the Relative Reference setting for Excel's Macro Recorder.
Ratings and Reviews
To review this course, please login.Login