Advanced Skills of the Spreadsheet
- fill cells with a series using AutoFill
- calculate data using formulas
- troubleshoot an error message
- use absolute cell references
- use statistical functions
- format a cell using conditional formatting
- apply an autoformat to a selection of cells
- produce a pivot table and chart
- perform a what-if analysis
- hide or unhide columns
- define a name for a cell
- customize the header or footer
- filter data
- produce multi-level sorts
- add a trend line to a graph
- change the chart type
- view a document in page break view
- insert or delete worksheets
- rename or color a sheet tab
- copy a worksheet
- customize print settings
- set page breaks and print area