 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2003 Introduction
Course Aims
This course is designed to help you to obtain the basic skills required to create and use a spreadsheet using Microsoft Excel. You will learn to enter and edit data, create formulas, format elements of a worksheet, and insert charts. |
Assumed Knowledge
Ideally, you will have completed the Windows XP Introduction course. You should be able to use Microsoft Windows and basic functions in Office to start an application, get help, and open, close, and save files. |
Course Audience
Those wanting to obtain basic skills in using a spreadsheet, such as updating data, applying formatting, printing, and making simple calculations. |
|
Table of Contents
|
Excel 2003 - What is Excel?
|
Understand the functions of spreadsheet application
|
|
Recognise the different elements of the Excel screen
|
|
|
|
Excel 2003 - Creating a Workbook
|
Move around the worksheet using the mouse and keyboard
|
|
Select cells using the mouse and the keyboard
|
|
Use zoom to view a worksheet at different magnification
|
|
|
|
Excel 2003 - Entering and Editing Data
|
Enter text, values, and dates in cells
|
|
Print a single copy of a worksheet
|
|
|
|
Excel 2003 - Creating a Formula
|
Understand what a formula is and how to create simple calculations
|
|
Enter a formula by typing or by using the Formula bar
|
|
Enter a range within a formula using the mouse
|
|
Use relative and absolute cell references
|
|
|
|
Excel 2003 - Moving and Copying Data
|
Use Drag-and-Drop to move or copy cell contents
|
|
Move, copy, and paste data using the Windows Clipboard
|
|
|
|
Excel 2003 - Editing a Formula
|
Create a formula using functions
|
|
Use basic arithmetic functions (SUM, AVERAGE, COUNT, MIN, MAX)
|
|
Recognise and resolve common error messages
|
|
Interpret spreadsheet data
|
|
|
|
Excel 2003 - Formatting Cell Values
|
Apply value formats (currency, percent, date, comma)
|
|
Change the currency symbol
|
|
Apply other formats (accounting, time, text, general)
|
|
|
Excel 2003 - Formatting Cell Contents
|
Apply font styles (typeface, size, colour, enhancements)
|
|
Modify the alignment and orientation of cell contents
|
|
Merge and unmerge cells (to centre headings across columns)
|
|
Use the Format Painter to copy cell formats
|
|
Clear cell contents or formats
|
|
|
|
Excel 2003 - Structuring a Worksheet
|
Modify the size of columns and rows
|
|
Insert and delete rows and columns
|
|
Insert and delete selected cells
|
|
|
|
Excel 2003 - Page Layout
|
Change paper size and orientation
|
|
Set page margins and alignment
|
|
Scale print output to fit a defined number of pages
|
|
Print column and row titles and set other options
|
|
View a worksheet in Print Preview
|
|
Change margin and column widths in Print Preview
|
|
Insert and remove a page break
|
|
Set up headers and footers
|
|
Add fields in headers and footers (page number, date/time, file information)
|
|
|
|
Excel 2003 - Printing Worksheets and Workbooks
|
Print a workbook (all sheets in book)
|
|
Display formulas in worksheet cells
|
|
Set, print, and clear a print area
|
|
Print a group of worksheets
|
|
|
|
Excel 2003 - Creating a Chart
|
Use the Chart Wizard to create different chart types
|
|
Reposition, resize, and delete a chart
|
|
Preview and print a chart
|
|
|
|
|
|
