You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel® 2003 to manage, edit, and print data.

Duration: 1 day

Fee: $225 per person

Upcoming Dates:
Aug. 21, Oct. 15, Dec.15

Prerequisite: Microsoft Windows: Introductory or similar experience.

Materials: Participants receive reference materials related to course topics. Follow up support by email or phone, on topics covered, is available to participants for 90 days.

Further Learning:
Microsoft Excel: Intermediate and Microsoft Excel: Advanced.

• Create a basic worksheet

• Navigate in Excel: select data, enter data, save a workbook, obtain help

• Modify a worksheet: move and copy data between cells, fill cells with series of data, edit cell data, insert and delete cells, columns and rows

• Find/Replace and go to cell data

• Perform calculations: create basic formulas, calculate with functions, copy formulas and functions

• Create an absolute reference

• Format a worksheet: change font size and type, add borders and color to cells, change column width and row heights, merge cells, apply number formats, create a custom number format

• Align cell contents

• Find and replace formats: apply an Autoformat, apply styles

• Develop a workbook: format worksheet tabs, reposition worksheets in a workbook, insert and delete worksheets, copy and paste worksheets, copy a workbook;

• Print the contents of a workbook: set a print title, create a header and footer, set page margins, change page orientation, insert and remove page breaks, print a range

• Format a worksheet

• Customize the layout of the Excel window: split a worksheet, arrange worksheets, freeze and unfreeze rows and columns, hide and unhide worksheets