| Attend upcoming webinar and earn continuing education credits. | Excel Spreadsheet Auditing Techniques | | | | | | | Presenter: David Ringstrom, CPA, author and nationally recognized Excel instructor | | | Credits: CPE (Credit Details) | | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | | | Auditing excel spreadsheets improves the integrity of the calculations and data in workbooks. In this webinar, you will learn techniques to verify the integrity of even the most complicated Excel workbooks using formula auditing and error-checking tools. Upon completion of the course, you will be able to: - Learn techniques for accessing password-protected workbooks.
- Identify how to go behind the scenes in a workbook to check for worksheets that can't be viewed or hidden from Excel's primary user interface.
- Find and select all formulas within a worksheet with just a couple of mouse clicks.
- Use the Watch Window to easily monitor the ramifications of even minor changes to your workbooks.
- Describe how range names can minimize errors, save time in Excel, serve as navigation aids, and store information in hidden locations.
- Audit all named cells in a workbook with ease by way of the INDIRECT function in all versions of Excel and the FORMULATEXT function in Excel 2013 and later.
- Move through formulas in slow motion with the Evaluate Formula feature.
- Track down the ripple effect of errors in spreadsheets with Excel's Trace Error command.
- Use the N function to annotate formulas within the formula bar when a cell comment won't suffice.
- Print a list of all cell comments on a worksheet or print visible comments.
- Verify that a pivot table is actually referencing all the data you're expecting to be summarized.
| | | | | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. | | | | | | | | | | | ● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 75 live webinars each month
● More than 1,000 on-demand courses | | | | | | |
No comments:
Post a Comment