Further Details
WORKSHEETS, A FURTHER LOOK
Renaming Worksheets
Deleting and Inserting Worksheets
Finding Files
Displaying Other Toolbars
Customising the Look of the Toolbars
Freeze Panes
Grouping and Ungrouping Worksheets
The Series Command
FURTHER FORMATTING TECHNIQUES
Conditional Formatting
Creating New Styles Based on Existing Cell Formatting
Using Colours in Excel 2000
Using Colours Based on Values
Gridlines
Hiding Data and Re-Displaying Data
FURTHER FUNCTIONS
What are Functions?
Using Paste Function
The IF() Function
Data Validation Functions
The HLOOKUP/VLOOKUP Functions
A Sample HLOOKUP
The CHOOSE Function
Entering a CHOOSE Function
The DATE Function
Mathematical Date Functions
Time Functions
Text Manipulation Functions
DATABASE AND LIST MANAGEMENT
What is a Database?
Excel 2000 Databases
Database Terminology
Creating, Editing and Navigating a Database
Sorting an Internal Excel 2000 Database
What is AutoFilter?
Filtering Data Top 10 AutoFilter
Advanced Filtering
Totalling and Manipulating Filtered Data
Creating Subtotals
Using Data Forms
The Excel 2000 Data Form
CUSTOMISING CHARTS
The Chart Wizard (1) – Chart Type
The Chart Wizard (2) – Data Source
The Chart Wizard (3) – Chart Options
The Chart Wizard (4) – Chart Location
Adding and Removing Data
Changing Data by Dragging and Dropping Columns
Formatting the Chart Area
Chart Formatting – Legends
Chart Formatting – Axis
Chart Formatting – The Plot Area
Chart Formatting – Gridlines
Chart Formatting – The Data Series
DRAWING AND PICTURES
Drawing Lines, Boxes, Ovals and Arcs
Using AutoShapes
Creating Text Boxes
Pictures
Bring to Front/Send to Back
Grouping and Un-Grouping Objects
EXCEL 2000 AND OTHER APPLICATIONS
Using the Conversion Feature
Cut, Copy and Paste – Using the Clipboard
Using Paste Special
OLE – Embedding Vs Linking
Linking Data from Other Worksheets
Linking Data from Word
Linking Data to Word
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
Guide price
Please Call |
