Perform mathematical expressions and review the Order of Operations rule

Review the five key functions: Sum, Average, Max, Min, and Count

Introduces functions used to modify text in Excel

More advanced functions that require more than one input

Changing a cell reference into a constant, which is necessary in certain calculations

The addition of effects to an excel document to provide visual instruction

Use the Format Painer to copy format a from one cell (or range of cells) to another

Create rules that govern specific cell ranges and apply a predetermined format when those rules are triggered

Create a Line chart and Spark lines to visually examine data

Create a Column chart to visually examine data

Create a Pie chart to visually examine data

Explores the special functionality created when data is converted to a Table

Rules and strategies to make printing easy

Insert, move, copy and delete worksheets

Insert, hide, group and freeze rows and columns

Save, close and email your finished product

End of class project to review key concepts from the class