Live Educational Webinar
Excel Efficiency: Breaking Down Complicated Formulas
Price: FREE
Jul. 19, 2018 Thursday
11:00 AM - 12:00 PM (Pacific)
1 Hour
Free Live Webinar
- Free CPE
- Non-sponsored Events mean you never listen to a 3rd party sales pitch – it’s all just great education
- Expert-instructor-led learning with live Q&A
- Based on a great course on Illumeo
David Ringstrom President and CPA, Accounting Advisors Inc
At times, Excel formulas can grow out of control, or, more likely, you’ve inherited spreadsheets developed by others that you’re to take ownership of. In this insightful presentation, Excel expert David Ringstrom, CPA, shares various ways to make sense of complicated formulas in Excel spreadsheets. After attending this webcast, you’ll have an abundance of tricks at your disposal to quickly decipher even the most complex formulas.
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 as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
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 as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Learning Objectives
After attending this event you will be able to:
List the benefits of using range names.
Apply the Trace Precedents and Trace Error features to identify linked cells.
Apply Excel’s IFERROR function to compensate for temporary situations where a formula may return an error.
Speakers
David Ringstrom
President and CPA, Accounting Advisors Inc
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 on Excel and presents scores of webinars each year. He is an author and served as the technical editor for over 30 books on accounting software. Some of his freelance articles on spreadsheets have been published internationally.
Moderated by Jennifer Robbins
Illumeo Webinar Manager
Jennifer is a marketing specialist and the webinar manager for Illumeo. She has been a part of more than 200 webinar presentations, supporting our expert presenters and Illumeo users alike. When she’s not moderating webinars, she’s creating and managing marketing content.
