THE Information Solution Provider P.O Box : 705 Westville 3630
Tel : (031) 266 8130
Fax : (031) 266 9610
Microsoft® Certifications End User Technical Programming Database
Booking Form
Services Queries
Services Support Pricing Queries Web Mail - Netsolution Web Mail - TC
Vista Versions Windows Media Center Thin Client VOIP
Contact Us
Subscribe Unsubscribe

Skip Navigation LinksACB South Africa > Training > Excel Level 1

Microsoft Accreditations: Advanced Infrastructure Solutions(amongst others) Our Microsoft accreditations: Microsoft Certified Learning Solution Provider(amongst others)

Microsoft® Office Excel 2003: Introduction
Course length: 1.0 day(s)
Certification: Microsoft Office Specialist: Microsoft® Excel 2003

Course Description:
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.

Target Audience:
Those wanting to obtain basic skills in using a spreadsheet, such as updating data, applying formatting, printing, and making simple calculations.

Ideally, you will have completed the course "Microsoft Office 2003 and Windows XP Introduction". 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.

With its companion course, Microsoft Excel Intermediate, you can use this course to prepare for Microsoft Office Specialist Excel Core Objectives.

Course Content:
Excel 2003 - What is Excel?
Understand the functions of spreadsheet application • Recognise the different elements of the Excel screen

Excel 2003 - Creating a Workbook
Create a new 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 • Use Undo and Redo

Excel 2003 - Entering and Editing Data
Enter text, values, and dates in cells • Edit cell contents • Print a single copy of a worksheet

Excel 2003 - Creating a Formula
Understand what a formula is and how to create simple calculations • Use AutoSum • 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 the AutoFill tool • Create a custom list • 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 • Revise a formula • Use Insert Function • 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) • Adjust the decimal place • 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) • Indent text in a cell • 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 worksheet • Print a workbook (all sheets in book) • Display formulas in worksheet cells • Print a range of cells • Set, print, and clear a print area • Print a group of worksheets • Print to a file

Excel 2003 - Creating a Chart
Use the Chart Wizard to create different chart types • Reposition, resize, and delete a chart • Change the chart type • Preview and print a chart • Move and copy a chart

Email the webmaster with questions or comments about this web site
Terms and Conditions
Copyright © 2006 A.C.B South Africa