Tomorrow: Excel Spreadsheet Auditing Techniques

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Excel Spreadsheet Auditing Techniques January   13 1 pm - 2:40 pm ET Presenter: David Ringstrom, CPA, Owner and Founder of Accounting Advisors, Inc. 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 Learn More Register Today Course Description   In this webinar, Excel expert David Ringstrom, CPA, shares a variety of techniques you can use to verify the integrity of even the most complicated Excel workbooks. You'll learn how to use Excel's formula auditing and error-checking tools and verify which cells contain formulas versus values. Upon completion of this course, you'll be able to: Identify how to add, review, and print worksheet comments with ease Apply Excel tools and techniques that allow you to evaluate portions of a formula or entire formulas Recall how the Names feature can simplify formula auditing Locate buried worksheets Access password-protected workbooks Use the Conditional Formatting feature to identify duplicates in a list Monitor even the most minor changes to your workbooks Use the Apply Names feature to simplify formula auditing Hide, display, and locate cells that contain comments—and much more Topics Covered List techniques for accessing password-protected workbooks Identify worksheets that can't be viewed or hidden from Excel's primary user interface View two worksheets from within the same workbook at the same time 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 Verify sums and totals quickly by selecting cells with your mouse Identify two ways to instantly display all formulas within a worksheet 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 Navigate formulas in slow motion with the Evaluate Formula feature List the pros and cons of using the F9 key within Excel's formula bar to evaluate a portion of a formula Trace dependents and precedents, both with Excel features and keyboard shortcuts Manage Excel's green error-checking prompts Utilize Excel's Trace Error command to track the ripple effect of errors in spreadsheets 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 Explain why Excel is opposed to circular references Verify that a pivot table is actually referencing all the data you're expecting to be summarized David demonstrates every technique at least twice, first on a PowerPoint slide with numbered steps, and second in Excel 2016. He'll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation, as well as in his detailed handouts. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants' questions, so come ready to pick his brain. David's detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast. Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 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. Learn More Register Today All-Access Membership   ● 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 Learn More Upcoming Webinars IRS Form Update January 17 at 1 pm ET Learn More Business Email Compromise Fraud: What Everyone, from the CEO down to Your Accounts Payable, Payroll and Credit Processors, Needs to Know to Protect Your Company January 19 at 1 pm ET Learn More Beginner's Guide to Microsoft Excel January 20 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.