Microsoft Excel Training Course 2003 Introduction

Overview and objectives of the Microsoft Excel Training Course

On this Microsoft Excel Training Course you will learn the very basic skills needed to create and edit spreadsheets with Microsoft Excel 2003. You will learn to enter and edit data, create formulas, format data, and create graphs (charts).

Who is this Microsoft Excel Training Course for?

If you are new to Excel or only to formalise the following basic skills: Entering Date, Formatting Data, Basic Formulas, Creating Graphs.

Microsoft Excel Training Course prerequisites

You should have basic knowledge of Microsoft Windows and be able to  start an application, get help, and open, close, and save files.

Microsoft Excel Training Course Contents

Excel Introduction

The functions of a spreadsheet , Identify the different elements of the Excel screen.

Creating a Workbook with Microsoft Excel

Create new workbooks, navigate the worksheet with the mouse or keyboard, Select cells with the mouse or keyboard, Use Undo & Redo, Use zoom to change magnification.

Entering and Editing Data in Microsoft Excel

Enter values, text, dates, and formulas , Edit contents of cells, Writing  formulas, Add cells using the AutoSum facility,   Select a range within a formula using the mouse, Relative Cell referencing and absolute cell referencing.

Moving and Copying Data in  Microsoft Excel

Using the AutoFill facility, Set up a custom list, Copy & Move cells by Drag-and-Drop by using the Clipboard.

Editing a Formulas with  Microsoft Excel

Use basic arithmetic & statistical functions   (SUM, MIN, MAX, AVERAGE, COUNT, COUNTIF) .

Formatting Cell Values with  Microsoft Excel

Format numbers (Number, Currency, Accounting Percent, Date), change No. of decimal places, Change currency symbol,

Formatting Cell Contents in Microsoft Excel

Font styles, Alignment and orientation of cell contents, Merge and unmerge cells,  Indent text il,  Format Painter, Clear cell contents and formats.

Structuring a Worksheet in  Microsoft Excel

Modify the size of columns and rows, Insert and delete rows and columns, Insert and delete selected cells.

Microsoft Excel Page Layout

Paper size and orientation, Page margins and alignment, Scale print to fit a set number of pages, Print column &row titles and set other options,  Print Preview, Change margin and column widths in Print Preview, Insert and remove a page break, Headers and footers, Add fields in headers and footers.

Printing Worksheets and Workbooks in  Microsoft Excel

Print a worksheet, Print a workbook , Display formulas i, Print a range of cells, Set & Clear a print area, Print a group of worksheets, Print to a file.

Creating a Chart in  Microsoft Excel

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.