Microsoft Office 2003 Introduction Course Book Now

Price

£99.00 ($160/€110)*

Includes three courses: Word, Excel and PowerPoint courses.

*Prices approximate visit XE Exchange for latest currency rates!

Course Contents

This course contains three courses:

• Word 2003 Introduction
• Excel 2003 Introduction
• PowerPoint 2003 Introduction

Overview

This course is ideal for people wanting to learn Microoft Word, Excel and PowerPoint.

Instructor

Presented by Sheila Farrell

Course Prerequisites

There is no particular requirements for this course, it is aimed at users who wish to learn the Microsoft Office 2003 Suite, including Word, Excel and PowerPoint.

Word 2003 Introduction

Introduction and Overview

• The Word interface
• Toolbars and menus
• Saving and file formats
• Opening, closing and saving files
• Page views
• Document workspaces
• Readability
• Customising the Recently used file list

Creating and Editing Documents

• Entering or importing text
• Moving, deleting and copying text
• Undo and redo buttons
• Searching for and replacing words
• Inserting the date and date formats
• Using the spell checker
• Using the Thesaurus
• Autocorrect

Formatting Documents

• Using different fonts and sizes
• Creating and altering margins
• Paragraph and line spacing
• Using tabs
• Using autotext
• Applying borders and shading
• Inserting page numbers
• Controlling indents
• Using the alignment options

Using Templates

• When to use a template
• Creating and saving templates
• Editing a template
• Using Wizards

Working with Tables

• Creating a table
• Adding rows and columns
• Deleting rows and columns
• Changing column widths
• Creating table headings
• Shading table cells and columns
• Outlining rows and columns
• Sorting information in tables
• Merging and splitting cells
• Creating borders

Printing in Word

• Using the print preview
• Printing envelopes and labels

Excel 2003 Introduction

Introduction and Overview

• The Excel interface
• Toolbars and menus
• Saving and file formats
• Creating a new workbook
• Opening an existing spreadsheet
• Customising the recently used file list

Worksheet Basics

• Entering text and numeric data
• Navigation
• Customising data entry direction
• Different mouse shapes
• Using the AutoFill feature
• Creating your own custom lists
• Inserting rows and columns
• Deleting rows and columns
• Hiding and Unhiding columns
• Freezing and unfreezing panes
• Splitting and unsplitting panes

Formatting Data

• Font formatting
• Using the Format Painter tool
• Fills and borders
• Using Autoformats
• Selecting cells and ranges
• Merging and splitting cells
• Using AutoComplete
• Formatting cells
• Text wrap and text rrientation
• Formatting numbers
• Defining and applying styles
• Column widths
• Working with Excel comments

Modifying Worksheets

• Adding colour to sheet tabs
• Naming worksheets
• Formatting a worksheet tab
• Inserting a new worksheet
• Moving and copying worksheets
• Grouping worksheets
• Show/Hide worksheet gridlines

Working with Calculations

• Entering simple calculations
• Using AutoFill
• Using absolute cell references
• Using the AutoSum tool
• Linking formulas
• Copying and pasting formula results
• Naming cells

Working with Functions

• Using the insert function wizard
• Using the SUM and COUNT functions
• Using AVERAGE, MAX and MIN functions
• Using the NOW and IF Functions
• Using the PMT and FV functions

Data Sorting

• Sorting data and columns
• AutoFilter
• Find and replace

Inserting Objects

• Images and clipart
• AutoShapes
• Objects
• Hyperlinks

Creating Charts

• Creating charts using the keyboard
• Using the chart toolbar
• Different chart types
• Adding data labels
• Editing chart data
• Adding title and legend
• Working with the x and y axis
• Formatting the chart

Printing Worksheets

• Print preview
• Page setup and page orientation
• Page break preview
• Scaling and adjusting print size
• Headers and footers
• Margins

PowerPoint 2003 Introduction

Introduction and Overview

• Getting Started
• PowerPoint Interface
• Toolbars and menus
• Saving and File formats
• Creating a new presentation

PowerPoint Basics

• Adding new slides
• Using the different Views
• Changing the Slide Order
• Adding notes

Working with Master Slides

• Creating a Master Slide
• Creating a Title Master Slide
• Creating a Handout Master
• Creating a Notes Master

Working with Text

• Selecting text objects
• Formatting Text
• Adding text with Outline view
• Using AutoCorrect
• Using Find and Replace
• Creating and editing bulleted lists
• Re-ordering and sorting bullet points

Formatting Slides

• Background image
• Slide Design
• Slide Layout
• Changing the colour scheme
• Adding speakers notes to slides
• Slide sorter view to organise your presentation

Adding Graphics and Tables

• Using the drawing tools to enhance slides
• Inserting images and Clipart
• Adding and formatting AutoShapes
• Adding text to an AutoShape
• Aligning, duplicating and arranging objects
• Inserting and managing tables

Creatings Charts

• Inserting chart data
• Formatting the chart options
• Selecting a chart type
• Working with the datasheet

Working with Organisation Charts & Diagrams

• Introduction to the diagram gallery
• Adding an organisation chart
• Formatting an organisation chart
• Adding a cycle diagram
• Formatting a cycle diagram
• Adding a radial diagram
• Formatting a radial diagram
• Adding a pryamid diagram
• Formatting a pryamid diagram
• Adding a venn diagram
• Formatting a venn diagram
• Adding a target diagram
• Formatting a target diagram

PowerPoint Slideshow

• Adding slide transitions
• Creatng custom animations to slides
• Adding sound effects
• Applying build effects to slides
• Adding action buttons to slides
• Running a slide show with transition effects
• Using the slide show effects while presenting
• Rehearsing timings
• Interactive presentations
• Powerpoint Viewer
• Speaker notes and handouts
• Package for CD

Printing Presentations

• Working with the different printing options
• Creating notes and handouts
• Creating PDF notes

How to Book

If you are new, please create an account.

If you are an existing member, please sign in to your account and subscribe to your course.