| Program Contents: |
- Cells, formulas and functions
- Entering and editing data
- Cells and ranges: select, copy, names, comments, formatting
- Entering and editing formulas, using functions and range names in formulas
- Dragging formulas: relative and absolute cell addresses
- Converting to values
- Functions: math, stat, finance, date/time, text
- Charts and graphics
- Creating a chart from worksheet data
- Chart types and modifications
- Using shapes, smart art and other graphics
- Trend lines, regression equation
- Analyzing data
- Filtering, sorting, subtotals
- Pivot tables and pivot charts
- What-if analysis: 2-D tables, scenario manager
- Goal seek and solver
- Analysis tool pack: correlation, histogram, regression etc.
- Additional features
- Data validation
- Conditional formatting
- Array formulas
- Hyperlinks, watch window, freeze/split panes
|