1 / 6

Effective Error Handling in Excel: Functions and Formatting Techniques

Learn how to effectively manage and handle errors in Excel with built-in functions. This guide covers the identification of input errors, including case sensitivity and extra spaces, and introduces the concept of error types. Discover useful functions like ISERROR, ISERR, and IFERROR to handle errors gracefully. Additionally, explore formatting techniques, including conditional formatting, cell styles, and page layout options to enhance the usability of your spreadsheets. Mastering these skills allows you to create error-resistant spreadsheets that are user-friendly.

onella
Télécharger la présentation

Effective Error Handling in Excel: Functions and Formatting Techniques

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Handling ErrorsFormatting 3 March 2011

  2. Selecting from a list • CHOOSE • Index and list of options • Example: alternative to grade translation

  3. Two types of errors • Input errors • Will look at case sensitive and extra blanks when we look at strings • For now, worry about content only • Errors in computation • USUALLY from bad input • BUT sometimes other cases

  4. Handling Errors • Do not want Excel error messages But do not want to ignore errors Use built-in functions to be more friendly • Error checking makes expressions complex But do not want to require perfect input Options: • Check and convert • Hide columns or use separate spreadsheets and only change at last step

  5. Available Tools • ISERROR and ISERR Checks if a cell has an error • IFERROR Simple form of IF(ISERROR,,) Simple computation: just use it Complex computation: hide column • Translating their errors ERROR.TYPE CHOOSE =CHOOSE(ERROR.TYPE(C2),"NULL","DIV","VAL","REF","NAME")

  6. Formatting • Conditional Formatting • Cell Styles are short hands • Alignment options • Page Layout • Setup • Sheet options

More Related