To the right, in column G, is a list of possible states. The last column is meant to show the current state of a given opportunity. This table is a simple list of projects showing a sales pipeline. We'll also look at how to use the values in a table for data validation. In this video we'll look at how to apply data validation to an Excel Table.