Excel - Advanced Spreadsheet Troubleshooting Techniques
Overview
Fix those formulas! (bold)
In this webcast, we will focus on debugging and troubleshooting complex formulas. You will learn various techniques that will assist you in creating complex compound formulas. You will also learn methods to resolve issues when you receive errors.
During this session, we will also discuss Excel’s nine built-in error-checking options and demonstrate different approaches to error resolution. Finally, will review techniques to resolve rounding errors.
Regardless of the version you are using, ALL concepts covered in this webcast apply to ALL versions of Excel.
Highlights
the Value and the art of nesting formulas<@br> different ways to troubleshoot complex formulas<@br> Excel’s Nine builtin errorchecking options
Prerequisites
Basic Excel knowledge
Designed For
all accounting and finance professionals<@br> Anyone who wants to become an expert in using Excel functions and formulas
Objectives
- Use complex spreadsheets more quickly while maintaining accuracy
- Apply advanced skills to build complex formulas
- Calculate complex formulas using various methods
Notice
This course is offered by a 3rd party vendor and will not be accessible in the My CPE Tracker section of the ISCPA website. Course access information will be emailed directly to you by AICPA.
Leader(s):
Leader Bios
Bryan Smith, CPA Crossings LLC
Bryan serves as a trusted adviser to CPAs on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.
Non-Member Price $142.00
Member Price $118.00