Use common worksheet functions.

Use filling techniques.

Apply a variety of page setup techniques.

Use a range of techniques to work with worksheets.

Apply borders to cells and ranges in a worksheet.

Create and use defined names in a workbook.

Apply conditional formatting in ranges in a worksheet.

Create and work with tables.

Use a variety of financial functions.

Select and change the format of object in a chart.

Use a range of elements and features to enhance charts.

Create more complex formulas and functions.

Apply a range of number formatting techniques to sheet cells.

Understand and use Excel's Quick Analysis tools.

Understand and create basic pivot tables