Avenue Training, Letchworth, Hertfordshire :: Microsoft Office Training, Adobe Training, Management and Soft Skills Training
0800 954 0434
Microsoft Training Courses

Microsoft Excel 2003 Foundation

Aims for this course

At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create a spreadsheet from scratch. Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work environment. Spreadsheets that you create will be easier to use and look more presentable.

Course Agenda

Getting Started With Excel
Introduction

What Is Excel?
New Features In Excel 2003
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

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 Colors
Adding Borders
Adding Fill Effects
Working With Styles
Modifying Excel's Toolbars
Hiding Toolbars
Showing Toolbars
Moving Toolbars
Customizing Toolbars
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
Using Templates

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
Using Autocorrect
Using Spell Check
Using 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
Using Undo, Redo, And Repeat
Using Smart Tags And Option Buttons
What Are Smart Tags?
The Error Option Button
The AutoFill Option Button
The Paste Option Button
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 Color-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
Using Headers And Footers
Inserting Page Numbers
Changing Margins And Orientation
Hiding Rows, Columns And Worksheets

Course Title
Microsoft Excel 2003 Foundation

Cost per delegate
145 +vat

Who is this course for?
Users with little or no experience in MS Excel 2003

Related courses
> MS Excel 2003 Intermediate
> MS Excel 2003 Advanced

When is this course running?
Click here to view the latest course schedule

Click here to book or enquire about this course