Course Name: 

Microsoft Excel 2000 / 2003

Lesson 3 � Developing a Professional Looking Worksheet

Introduction:

This course teaches how to develop a professional looking worksheet in MS Excel. It is intended for those who already have a basic understanding of how to use the most basic features of MS Excel (97-03).

We offer courses for first time users to advanced users looking to get the most out of this powerful program. With a firm understanding and skill using Microsoft Excel, you can improve the way you turn data into information using powerful tools to analyze, communicate, and share your results with others.

Topics for Discussion:

1.      The Format Cells dialog box

2.      Format data using different fonts, sizes and font styles

3.      Copy existing formats to other cells

4.      Align cell contents

5.      Align using Merge and Center

6.      Examples of text formatting

7.      Borders and backgrounds

8.      Add patterns or colors to cells

9.      Merge a range of cells

10. Hide & unhide rows and/or columns

11. Format the worksheet background and sheet tabs

12. Insert a background image and change a worksheet tab color

13. Find and replace within a worksheet

14. Create and apply styles

15. Apply an AutoFormat to a table

16. The AutoFormat style gallery

17. Format a printout using Print Preview

Pre-Requisites:

• �Lesson 1 - The Fundamentals� or equivalent knowledge from using MS Excel.

�         Any version of MS Excel from 2000-2003

Cost:

$50.00

References:

Course material will be given out at the time of the lecture.