|
Training
Materials for:
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint XP
Microsoft Access
Internet
Explorer
Outlook
Expression Web
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Excel 97
Foundation Level Training Course
Courseware Training Manual
1. A first look at Excel 97
- The advantages of using Excel 97
- What are workbooks and worksheets?
- Creating and opening workbooks
- Entering data
- Further data entry techniques
- Autocorrect
- Autocomplete
- Using the pick list
- Navigating in the worksheet
- Selecting items within Excel 97
- Inserting and deleting cells, rows and columns
- Saving workbooks
- Moving between worksheets
- Using the spelling checker
- Closing an Excel 97 workbook
- Exiting Excel 97
2. A closer look at the Excel 97 screen
- The standard toolbar
- The formatting toolbar
- Selecting worksheet views
- Undo and repeat
- The office assistant
3. Formatting and customizing data
- Formatting options within Excel 97
- Alignment
- Data indentation and rotation - introduced with Excel 97
- To center items in a cell/cells
- Using fonts
- Formatting numbers
- Decimal places
- Formatting columns and rows
- Deleting cells, formats, objects and worksheets
- Adding, editing and removing borders
- Using Autoformat
- Copying data
- Copying data using drag and drop
- Copying columns and rows
4. Formulas, functions and named ranges
- Formulas
- Operator evaluation order within Excel 97
- Functions
- Using the sum function
- Other commonly used functions
- Using paste function
- Naming cells and ranges
- Using named ranges with formulas
5. Introducing charts
- Creating a chart
- Moving, re-sizing and deleting charts
- Changing the chart type
6. Printing
- Page setup
- Margins
- Centering printed output
- Headers and footers
- Sheet printing options
- Choosing a printer and changing settings
- Printing a worksheet
- Printing multiple files
|
