Viewing Worksheets
- Customising View Options
- Displaying and Customising Toolbars
- Hiding Workbooks and Worksheets
- Freezing Panes
- Grouping and Ungrouping Worksheets
More Formatting Techniques
- Using Styles
- Conditional Formatting
- Using the Format Painter
- Using Guidelines
- Hiding and Displaying Cells
Charts
- Chart Wizard
- Chart Toolbar
- Working with Charts
- Formatting the Chart
| More Formulas and Functions
- Using the Series Command
- Using the Insert Function Wizard
- Using the Excel Function Categories
- Correcting Formulas
- Using the Formula Error Checker
- Using the Formula Auditing Toolbar
- Using the Watch Window
Database and List Management
- Using Databases
- Creating and Editing A Database
- Sorting a Database
- Using Autofilters
- Advanced Filters
- Working with Filtered Data
- Using Data Forms
|
Drawing and Picture Objects
- Drawing Toolbar
- Working with Autoshapes
- Creating Text Boxes
- Adding Pictures
- Layering Objects
- Grouping and Ungrouping Objects
Excel 2003 and Other Applications
- Converting Files From Other Applications
- Copying Data From Another Application
- Embedding and Linking Objects
- Hyperlinks
- Managing Links
|
