Microsoft Excel XP Level 1 |
|
| |
Overview
An introduction to the essential tools and features available to manage financial worksheet information. This course also provides the skills necessary to pass the ECDL Module 4 exam. ECDL is designed specifically for those who wish to gain a benchmark qualification in computing to enable them to develop their IT skills and enhance their career prospects. Click here for more information on the ECDL (European Computer Driving Licence). |
| |
Prerequisites
Good practical knowledge of how to use a computer. You should be able to use a mouse to select, open and close files and folders. You need to be aware of the file storage areas, such as My documents, desktop and hard drive. You should know how to ‘copy’ and ‘paste’, minimise and maximise a window, the difference between ‘save’ and ‘save as’ and how to switch between one open application and another
If you are unfamiliar with these topics, you may be interested in our PC Basics course. |
| |
Objective
To introduce you to Excel workbooks. To develop and increase your confidence in using Excel. To show you how the essential features of Excel work. By the end of the course, you will be aware of the essential features of Excel. You will be able to create and save worksheets more quickly. You will be able to enter, format and present numerical data in a variety of ways. |
| |
| Available Platforms: PC only | Duration: 1 day |
| |
Price of Course £195.00 ex VAT
(Full payment must be received prior to the course commencing) |
| |
| |
| Course Outline: |
 |
|
Getting to Know Excel
• Excel overview
• Starting Excel
• The Excel interface
• Modifying the toolbar display
• Creating a new workbook
• Entering text and numerical data
• Saving a workbook
Creating Formulae
• Creating simple formulae
• Creating simple functions
• Copying formulae
• Relative cell referencing
• Displaying formulae |
|
Formatting your spreadsheet
• Adjusting column widths and row heights
• Change the appearance of text
• Position text and numbers in columns
• Number formats
• Borders and backgrounds Charts
• Using the chart wizard
• Chart options
• Changing a chart after creation
Printing your spreadsheet
• Print areas
• Previewing a worksheet
• Page orientation
• Margins
• Print options |
|
| |
|
|
If you are confident using all these features, your next step would be our 
