Excel 2016 - Evaluating Data

Platform: PC

Excel’s® validation tools allow you to control and validate the data that is entered into a cell. Data validation also enables you to format and set messages up based upon the data that is entered into a cell. Conditional formatting within Excel allows the user to format cells and data based on existing data in a worksheet – this way, you can create quick visual representation of the data based on specified conditions. This online training series focuses on how to create data validation rules when entering data into your sheet and also to create conditional formatting to help visually analyze data that has already been inputted into the sheet.

You'll learn about:

  • Data validation
  • conditional formatting

Tutorial series by Dan Fanella, PhD

Share Your Expertise

Have a passion for ed tech? Share it by becoming an eLearning Contributor!