Maximize Excel: Error Prompts

CPE Credit: 2 hours

Are you baffled and frustrated when you receive error prompts while performing seemingly simple actions in your Excel spreadsheets? After taking this comprehensive course by Excel expert David Ringstrom, CPA, you’ll understand why you encounter error prompts, and you’ll know what actions to take when Excel appears to go awry.
 
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.


Topics Covered

• Understanding how to manage the Protected View prompt in Excel 2010 and later.
• Utilizing the Error Checking command to locate cells that contain errors within a worksheet.
• Using a simple macro to eliminate redundant prompts that appear when you save a file in text or .CSV format.
• Learning the nuances of circular references in Excel.
• Mastering the nuances—and the power—of Excel’s Transpose feature.
• Improving the integrity of spreadsheets with Excel’s VLOOKUP function.
• Discovering new worksheet functions available in Excel 2016.
• Resolving the issue that prevents you from being able to insert rows or columns.
• Using range names to streamline formulas and bookmark key inputs within a workbook.
• Determining at a glance whether a spreadsheet contains links to other workbooks.
• Improving the stability of Excel by deleting accumulations of temporary files in Windows.

• State why certain features, such as slicers, sparklines, and even charts, are disabled in some workbooks.
• Recall which versions of Excel offer the FORMULATEXT function.
• Identify the worksheet function that eliminates extraneous spaces from text within a worksheet.