|
|
|
|
|
|
|
|
|
|
TechnicalAdobeMacromediaMicrosoftQuark
|
|
|
|
|
|
AccessExcelFrontPageInternet ExplorerOutlookPowerPointProjectPublisherVisio ProfessionalVisio StandardVisio TechnicalWindowsWord |
|
|
| |
Welcome To Excel
|
|
The Excel Interface |
|
The Excel Menu Bar |
|
The Standard Toolbar |
|
The Formatting Toolbar |
|
Moving Around The Workbook |
| |
Creating a Spreadsheet
|
|
Selecting Cells |
|
Entering Text & Numbers |
|
AutoFill |
|
Using Smart Tags |
|
Cut, Copy and Paste |
|
Drag and Drop |
|
Removing cell contents |
|
The Multiple Undo command |
| |
Saving Workbooks
|
|
Save & Save As |
|
The "Save As..." dialogue box |
|
Naming a Worksheet |
|
Changing directories & drives |
|
Creating directories |
|
Different file types |
|
Password Protection |
| |
Excel Functions
|
|
Formulas & Functions |
|
Using the AutoSum |
|
The Function Command |
|
Commonly used Functions |
|
Relative & Absolute Cell References |
|
AutoCalculate |
| |
Worksheet Formatting
|
|
Using The Toolbars |
|
Shortcut Menus |
|
Changing Fonts |
|
Formatting Numbers |
|
Alignment |
|
Borders & Shading |
|
Format Painter |
|
Column Widths |
|
Autoformat |
|
| |
Worksheet Editing
|
|
Editing the Worksheet |
|
Inserting / Deleting rows & columns |
|
Copy & Paste |
|
Spelling |
|
Find & Replace |
|
AutoComplete |
|
AutoCorrect |
|
Pick from List |
|
The Watch Window |
| |
The Help Facility
|
|
Help Contents |
|
Searching Help |
|
Office Assistant |
|
Using Office Online |
| |
Charts
|
|
Creating Charts |
|
Chart Wizard |
|
Changing Chart types |
|
Editing, Formatting the Chart |
|
Updating the Chart |
|
Printing the Chart |
| |
Printing
|
|
Page Setup |
|
Print Preview |
|
Printing your Worksheet |
|
Setting a Print Area |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
courselevel: |
|
|
courseversion: |
|
|
duration:
1 day
|
price: click here
|
|
|