Microsoft Excel 2003 Introduction

Course Aims
Microsoft Excel 2003 is the popular spreadsheet from Microsoft and part of the Microsoft Office XP suite. This training course is designed to let users get to grips with the main features of Microsoft Excel. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.
Who Should Attend?
New or intending users of Microsoft 2003 or XP who wish to gain a good understanding of the software. Note : A working knowledge of using PCs in the Microsoft Windows environment is required.
Course Outline: Microsoft Excel 2003 Introduction
Getting Started with Excel
Introduction:· Opening Excel · Exiting Excel
Help with Excel:· Finding Help · The Office Assistant · The Help Task Pane
Beginning Excel:· The Standard Toolbar · The Formatting Toolbar · Working with Excel Menus · Exploring Task Panes · Excel Short-cut Keys
The Basics of File Management:· New Workbooks · How to Open Existing Workbooks · How to Save Workbooks · How to Close Workbooks · Excel File Types
Explore your Workbook:· Switching Worksheets · The Active Cell · Selecting Cells · Exploring a Worksheet · The Zoom Feature
Excel Basics
Working with Excel:· Columns, Rows, Cells, and Ranges · Creating Worksheet Labels · Entering and Deleting Data · Printing your Worksheet
Basic Excel Features:· What is AutoFill? · What is AutoSum? · What is AutoComplete? · Working with Basic Formulas
Editing Tools:· AutoCorrect · Spell Check · Find and Replace · Documenting a Worksheet with Comments
Moving your Data:· Dragging and Dropping Cells · How to Cut, Copy, and Paste Cells · How to Cut, Copy, and Paste Multiple Cells and Items · How to Use Paste Special · How to Insert and Delete Cells, Rows, and Columns · Undo, Redo, and Repeat
Smart Tags and Option Buttons:· What are Smart Tags? · The Error Option Button · The AutoFill Option Button · The Paste Option Button
Working with Excel
Modifying Cells and Data:· Changing the Size of Rows or Columns · Working with the Formatting Toolbar · Adjusting Cell Alignment · Rotating Text · Creating Custom Number and Date Formats
Cell Formatting:· Conditional Formatting · What is the Format Painter? · What is AutoFormat? · Cell Merging and AutoFit · Find and Replace Formatting
Enhancing a Worksheet's Appearance:· Adding Patterns and Colours · Adding Borders · Adding Fill Effects · Working with Styles
Modifying Excel's Toolbars:· Hiding Toolbars · Showing Toolbars · Moving Toolbars · Customizing Toolbars
Working with Charts:· Creating a Chart · Formatting a Chart · Manipulating a Chart · Enhancing a Chart with Drawing Tools · Enhancing your Chart with Titles and Tables
Working with Charts and Data:· Changing the Type of Chart · Changing the Source Data · Creating 3-D Charts · Working with the Chart Axes and Data Series · Making Custom Charts
Workbook Management
Organizing your Workbook:· Inserting and Removing Worksheets · Renaming, Moving, and Colour-Coding Worksheets · How to Split and Freeze a Window · Using Multiple Workbooks and Windows · Using a Watch Window · Creating a Custom View
Formatting your Workbook:· Headers and Footers · Inserting Page Numbers · Changing Margins and Orientation · Hiding Rows, Columns and Worksheets
Printing a Workbook:· Choosing a Print Area · Setting up Page Breaks · Choosing Paper Size and Changing Print Scale · Adding Print Titles and Gridlines
More Workbook Features:· Linking Workbooks · Consolidating Workbooks · Combining Worksheets · Protecting Worksheets · Templates