Microsoft Excel XP 2002 Level 1; Introduction Course at Freeskills.com

COURSE SEARCH

HOME > COURSE > MICROSOFT EXCEL XP 2002 LEVEL 1; INTRODUCTION

MEMBERS LOGIN

UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW

HOME

COURSE LIBRARY

QUESTIONS & ANSWERS

There are many excellent online courses. This has been hugely beneficial in my day to day work.

- Louise Nolan

MORE INFO

Microsoft Excel XP 2002 Level 1; Introduction

Course Aims
Microsoft Excel XP combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Readers will learn about Excel essentials and how to modify a workbook, manage the worksheet, format a worksheet and print a worksheet/book.

Assumed Knowledge
New or intending users of Excel XP 2002 who want to gain a good understanding of the software in a short space of time.

Course Audience
Readers should have an understanding of any of the following operating systems Windows 98/NT/2000/ME/XP.

This course can be found in the following categories:

Course Library > Microsoft > Office XP
Course Library > Microsoft > Excel
Course Library > MOS

Table of Contents

Excel Essentials

Starting Excel

What is a Worksheet?

What is a Workbook?

Identifying Parts of the Screen

The Task Pane

Identifying the Toolbars

Getting Help from the Office Assistant

Using Selection Techniques

Selecting a Range of Cells

Selecting Nonadjacent Cells and Ranges

Selecting an Entire Worksheet

Entering Data

Entering Text Data into a Cell

Entering Values

Entering Data into a Range

Quickly Adjusting a Column Width

Finishing a Workbook

Saving a Named Workbook

Saving the Workbook in HTML Format

Printing a Worksheet

Closing a Workbook and Exiting from Excel

Assignment

Modifying a Workbook

Opening a Workbook

Creating a New Workbook

Opening a Recently Used Workbook

Creating Simple Formulas

Creating a Formula by Pointing

Using Functions

Using the AutoSum Button

Using the Formula Palette

Editing Data on the Worksheet

Editing the Data in a Cell

Editing a Formula

Clearing the Contents from a Cell or Range

Using Undo and Redo

Assignment

Managing the Worksheet

Navigating in a Worksheet

Using the Scroll Bars and Boxes

Changing Worksheets

Using Go To

Changing the Worksheet Structure

Deleting Cells, Rows, and Columns

Performing a Simple Sort

Creating and Using Named Ranges

Automatically Naming Ranges

Navigating with Named Ranges

Using Range Names in Formulas

Pasting a List of Named Ranges

Deleting and Editing Range Names

Creating Named Constants

Assignment

Formatting the Worksheet

Moving and Copying Data

Copying Data

Copying Data with AutoFill

Creating a Series with AutoFill

Defining Relative, Mixed, and Absolute References

Copying Formulas

Changing the Appearance of Data

Changing Row Height

Applying Fonts

Adding Enhancements

Aligning Data in Cells

Merging and Centering Cells

Rotating and Indenting Text

Adding Borders and Shading

Using Drawing Tools

Creating Graphic Objects

Editing a Graphic Object

Creating and Editing 3-D Objects

Using Other Drawing Tools

Assignment

Printing the Worksheet/book

Printing a Single Worksheet

Using Print Preview

Creating Headers and Footers

Removing the Grid

Printing a Selection

Using Print Areas

Using Advanced Printing Techniques

Aligning the Printout

Fitting a Document onto a Desired Number of Pages

Working with Page Breaks

Working with Page Breaks in Normal View

Setting Print Titles

Removing Print Titles

Assignment

Appendix A; What’s new in Excel XP?

The Office Task Panes

Smart Tags

Smart Data Tags

New Worksheet Features

New Argument and Function Features

Other New Features and Enhancements in Excel 2002

Appendix B; What’s new in Office XP?

What’s new in Office XP?

New Office XP Features Common across Applications

Smart Tags (Word)

AutoCorrect Options (Word)

Office XP Clipboard

Office Email Introduction

Other New Features in Office XP

TRY BEFORE YOU BUY

BECOME A RESELLER

TERMS & PRIVACY

Thursday 9th February 2012