Using Multiple Spreadsheets
Linking workbooks and worksheets
Format multiple spreadsheets at once
Monitor activity across multiple spreadsheets
using the Watch window
Comparing workbooks side by side

Managing Data in Lists Using Data Forms
Moving through data records
Adding, editing and deleting records
Finding records

Sorting and Filtering Lists
Sorting rows and columns
Sorting and formulas
Creating and using custom sort orders AutoFilter
Removing a filter
Custom AutoFilter
Advanced Filters

Using List Functionality
Designating data as a list and using this interface
to manage and analyse your data
Automatic Subtotals
Applying and removing subtotals
Counting
Multi-level subtotals

Creating Outlines
AutoOutline
Collapsing and expanding outlines
Removing outlines

Creating Charts
Selecting data
Moving and resizing charts
Chart toolbar and ChartWizard
Changing the chart type
Adding titles
Combination charts
Adding and deleting floating text
Adding labels to data points
Formatting the data series
Formatting the plot area
Customising 3D charts
Rotating 3D charts
Exploding slices of pie charts

Drawing
Drawing toolbar
Drawing lines and shapes
Changing colours and patterns
Changing line and arrow styles
Selecting, moving and resizing objects
Including text in a drawing
Grouping and ungrouping objects
Creating diagrams