Sum or Count cells, based on criteria Build a Pivot Table Write a formula with absolute and relative references Create a drop down list of options in a cell Sort a list without messing up the data Use a formula to look up a value in a table Record and modify a simple macro Design and build a simple application, such as an order form Create a chart from worksheet data Apply conditional formatting that uses a formula Nest two or more functions in a formula Insert and protect worksheets (and understand the limits of Excel's protection) Perform simple date and time arithmetic Filter unique items from a list