|
Training materials for::
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint
Microsoft Access
Internet
Explorer
Outlook
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
 Expression
Web
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Excel 95 Courseware Materials
Foundation Level Training Course
Training Course Outline
1. A first look at Excel 95
- The advantages of using Excel 95
- What are workbooks and worksheets?
- Creating and opening workbooks
- Entering data
- Further data entry techniques
- Autocorrect
- Navigating in the worksheet
- Naming cells and ranges
- Selecting items within Excel 95
- Inserting and deleting cells, rows and columns
- Saving workbooks
- Moving between worksheets
- Using the spelling checker
- Closing an Excel 95 workbook
- Exiting Excel 95
2. The Excel 95 screen
- The standard toolbar
- The formatting toolbar
- Selecting worksheet views
- The view manager
- Undo and repeat
- Using help
3. Formatting and customizing data
- Formatting options within Excel 95
- Alignment
- 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 and functions
- Formulas
- Operator evaluation order within Excel 95
- Functions
- Using the sum function
- Other commonly used functions
- Using function wizard
5. Introducing charts
- How to create a chart
- Manipulating charts
- Formatting charts
- Chart types
- Creating 3-d charts
6. Printing
- Page setup
- Margins
- Centering a report on a page
- Headers and footers
- Sheet printing options
- Choosing a printer and changing settings
- Printing a worksheet
- Printing multiple files
Microsoft Office 2007 Courseware materials
|
