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
