Working with Worksheets

• Viewing, renaming, and color-coding worksheets
• Editing a group
• Manipulating worksheets
• Creating linked formulas
• Using 3D references
• Protecting workbooks and worksheets

Working with Functions

• Creating and using named ranges
• Creating a relative name
• Using custom zoom
• Using functions
• Working with insert functions
• Using financial functions
• Using date functions

Working with Formatting & Data Validation

• Using conditional formatting
• Using data validation
• Creating and using custom formats
• Working with auditing and error checking tools

Creating Charts

• Using the Chart Wizard
• Modifying charts
• Changing the chart type
• Changing a chart's location and size
• Adding and removing data series
• Changing worksheet data using a chart
• Using the range finder with charts

Working with Charts

• Using text boxes
• Formatting chart elements
• Formatting chart text
• Formatting chart objects
• Printing charts

Creating Advanced Charts

• Working with three-dimensional charts
• Creating a combination chart
• Creating complex pie charts
• Creating a pictograph

Using List Features

• Creating a list
• Using AutoComplete
• Sorting a list
• Using the data form
• Filtering a list using AutoFilter

Using Styles and Templates

• Creating and using styles
• Merging styles
• Using templates
• Creating templates