Further Details
A FIRST LOOK AT EXCEL 2000
The advantages of Using Excel 2000
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 2000
Inserting and Deleting Cells, Rows and Columns
Saving Workbooks
Moving Between Worksheets
Using the Spelling Checker
Closing an Excel 2000 Workbook
Exiting Excel 2000
A CLOSER LOOK AT THE EXCEL 2000 SCREEN
The Standard Toolbar
The Formatting Toolbar
Selecting Worksheet Views
Undo and Repeat
The Office Assistant
FORMATTING AND CUSTOMIZING DATA
Formatting Options within Excel 2000
AlignmentData
Indentation and Rotation – Introduced with Excel 2000
To Centre 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
Using the new Clipboard Feature
The Fill Handle
FORMULAS, FUNCTIONS AND NAMED RANGES
Formulas Operator Evaluation order within Excel 2000
Functions
Using the SUM Function
Other Commonly Used Functions
Using Paste Function
Naming Cells and Ranges
Using Named Ranges with Formulas
Absolute and Relative Cell References
INTRODUCING CHARTS
Creating a Chart
Moving, Re-sizing and Deleting Charts
Changing the Chart Type
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
Website: http://www.westlothianit.co.uk
* Stadium House* Livingston Football Stadium * Alderstone Road * Livingston* West Lothian * Scotland* UK *Tel: +44 01506-602676 (Main Reception)* Direct Number: +44 01506-602687* Fax: +44 01506-602782 * Mobile: Debbie 07855-323527*
Mobile: Patricia 07775-773973 * E-Mail: contact@westlothianit.co.uk * VAT Registration No: 828 3352 22*
Guide price
£135 |
