Error-Proofing Excel Spreadsheets

Upon successful completion of this course, participants will be able to:

• Recognize the benefits of using data validation in Excel.
• Recall the best ways to format a spreadsheet, and which methods to avoid.
• Recognize the situations in which absolute and relative cell references should be used.
• Specify the tools available for checking logical and formulaic issues in Excel.
• Recall the tools that can be used to clean data.
• Recognize the reasons for not storing numbers as text.
• Recall the Excel features that allow you to monitor selected cells.
• Recognize the situations in which named ranges should be used.
• Specify how conditional formatting can be used to improve a spreadsheet.
• Recall the methods for finding duplicate values in a spreadsheet.
• Recognize the reasons for using standardized templates in Excel.
• Recall the risks of using too many sheets in one Excel file.
• Recognize the situations in which freezing panes in Excel can be useful.
• Specify how the Evaluate Formula tool can be used.
• Recall the steps that should be followed before finalizing a spreadsheet.
• Recognize why excessive formatting should be avoided in a spreadsheet.
• Recall why raw data should be separated from calculations in Excel.
• Recognize what can happen if you do not validate external data in Excel.
• Specify the types of errors that the IFERROR command can manage.