Further Details
TEMPLATES AND STYLES
What are Templates?
Creating Templates
Using Templates
What are Styles?
Creasing and Using Styles
IMPORTING AND EXPORTING DATA
Why Import Data?
The Text Wizard
Importing from a Database
Database Terminology
Using Microsoft Query
“WHAT IF?” UTILITIES
Excel “What IF?” Type Utilities
Goal Seek
Graphical Goal Seeking
Scenario Manager
Solver
Solver Terminology
Solver – An Example
MACROS AND CUSTOM CONTROLS
What are Macros?
To record a Macro
Running Macros
Creating a Button in a Worksheet and Assigning a Macro to it
Attaching Macros to a Button
Drawing, Editing and Formatting Buttons
PIVOT TABLES
What is a Pivot Table?
A Sample Pivot Table
To Create a Pivot Table
Pivot Table Toolbar
CUSTOMISING EXCEL
Customising Excel 2000 – Options
SECURITY AND PROOFING WITHIN EXCEL
Auditing and Security Features within Excel 2000
The Spell Checker
What are Shared Workbooks?
Advanced Workbook Sharing Options
Data Validation
Workbook Password Protection
Workbook Protection
Worksheet Protection
Cell Protection
Excel 2000 Auditing Tools
Auditing Worksheets
Cell Comments
DATA MAPS
What are Data Maps?
The Data Map Control Dialog Box
Placing Data on a Map
Formatting a Data Map
CONSOLIDATION
What is Consolidation?
Consolidating Rows and Columns
SHARING WORKBOOKS
Shared Workbooks
Tracking Changes
EXCEL ADD-INS
Loading Add-Ins
WORKING WITH TOOLBARS
Display Hidden Toolbars
Floating and Docking Toolbars
Customising Toolbars
Creating a New Toolbar
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
Please Call |
