|
SYNOPSIS:
This course introduces the skills necessary for productive development
of workbooks. It includes tasks to explore Excel, create simple formulae,
copy and move data, and print worksheets. The student will also learn
how to work with ranges and use the Office Assistant, basic workbook skills,
and page setup.
PREREQUISITES:
Users familiar with Windows who want to learn the basics of Excel 2003.
OBJECTIVES:
l Exploring Excel
l Using the Office Assistant
l Using Basic Workbook Skills
l Working with Ranges
l Creating Simple Formulae
l Copying/Moving Data
l Printing Worksheets
l Page Setup
DURATION:
Half Day
|
THIS MODULE INCLUDES:
Exploring Excel
Starting and exiting Excel, working with Excel windows and worksheets,
using menu commands - mouse and keyboard, displaying and hiding toolbars.
Using the Office Assistant
Using the Office Assistant, finding an Answer, selecting an Assistant,
changing Assistant options, hiding the Assistant.
Using Basic Workbook Skills
Creating and saving a new workbook, selecting a cell using the keyboard,
scrolling with the mouse, entering text and numbers into cells, closing
a workbook, opening and renaming an existing workbook, using AutoComplete
and Pick From List, editing cell entries.
Working with Ranges
Working with ranges, selecting ranges with the keyboard and mouse, selecting
non-adjacent ranges, entering values into a range, using AutoFill
Creating Simple Formulae
Using formulae, the AutoSum button, Functions, AutoCorrect, Formula Palette
to Create and Edit, the Paste Function button, AutoCalculate, and Range
Finder; entering formulae.
Copying and Moving Data
Copying, cutting and pasting data; creating an Absolute reference; filling
cells; using drag-and-drop editing, Undo and Redo, and the Undo list.
Printing Worksheets
Previewing a worksheet; zooming the preview window; printing a worksheet,
a selected range, multiple copies, and a page range.
Using Page Setup
Changing the page margins and orientation, centering the worksheet, customizing
and editing headers and footers, printing without gridlines, repeating
row and column labels, using Page Break Preview.
|
