Excel 2016: Evaluating Data

This Microsoft Excel 2016 training course teaches you how validate the data in your spreadsheets and to implement conditional formatting to help you better understand your data. To begin, you’ll learn how to audit data for accuracy and check for errors by installing data validation rules, specifying the criteria, and setting rule messages. Next, you’ll learn about conditional formatting and review ways of applying it either to a single cell or a group of cells. In addition to discussing the conditional formatting options readily available in Excel, you’ll also discover how to create, manage, and clear custom formatting rules to enable you to visualize large amounts of data quickly.

Learning objectives:

• Evaluate your data for accuracy by utilizing data validation rules
• Apply conditional formatting based on specific criteria
• Create and manage custom conditional formatting rules