Course ID: EXCELS03  /  Cost: $6 (member), $9 (public)		Public: access to one version for 30 days
Available versions: Windows XP, Internet Explorer		Members: unlimited access to all versions

To effectively filter data in Excel, information needs to be accurate and uniform. Ensure that data input is accurate by adding a drop-down menu in a cell. You can even create a custom list with your own list items! In this Solution you will learn how to create a custom list, containing your own criteria, that will be added to a cell as a drop-down menu. In the first exercise you will learn how to reference a list from within the same worksheet page. In the second exercise you will learn how to reference a list that exists on a separate worksheet. Public students: Public students have unlimited access to this Solution for 30 days. All available versions are listed above. Only one version can be selected. Members: Blue Eyebrow members have unlimited access to this Solution and can view all available versions multiple times. All available versions are listed above.