| |
| Aim of Course | To provide an introduction to Microsoft Excel 2000 and its functions. - Windows 95/98. |
| Target Audience | Designed for participants who have basic knowledge of computing and wish to advance their knowledge using Microsoft Excel. |
| Structure of Course | The participant is given exercises that offer hands-on practical experience to enable successful and efficient use of the program. |
| Training Facilities | Training will take place in one of 3 fully equipped training suites delivered by professional lecturers. Up to date multimedia and interactive software/smartboards. Free on-line back-up support after training. |
| Course Content | Accessing Excel 97/2000 Overview of Screen/Toolbars Create a New Worksheet Enter Data/Cursor Movement/Shortcuts Selecting Relevant Data Editing and Format Data Deleting Rows/Columns Inserting Rows/Columns Drag & Drop/Cut, Copy and Paste Undo Function Working in the Format Cell Box Naming a Sheet/Moving Between Sheets Saving Files/Printing a Sheet/Range of Cells Closing/Retrieving Files Using Formulae/Relative & Absolute Cell Addressing Working with Multiple Worksheets Working with Multiple Files Find & Replace Text/numbers/Cells Using Borders Creating Charts/Editing Charts Organising Data/Data Sorting Creating and Using AutoFilters E-mail Attachment to Retrieve and send Excel files |
