COURSE DESCRIPTION FOR
MICROSOFT EXCEL - INTRODUCTION
This class description basically covers all versions of Excel.
To request the class description and system requirements for your version
of Excel,
send e-mail to the Office Wiz
Master all the techniques to produce accurate and professional
looking worksheets. This class will introduce you to basic electronic spreadsheets,
worksheets skills and generating data reports. The class is instructor-led
with hands-on activities. Learn to:
- Create a basic worksheet by entering text, values and
formulas.
- Create formulas.
- Move and copy data.
- Change the appearance of worksheet data by using a variety
of formatting techniques.
- Produce attractive documents with different print options
and use the spell checking feature.
- Write formulas that refer to cells on multiple worksheets.
- Save your Excel workbook as a Web page.
LENGTH
Approximately eight hours. Recommend two four hour sessions.
PREREQUISITES
No knowledge of Excel is required, but you must have a
good understanding of basic Microsoft Windows, file management and personal
computers.
SPECIFIC CLASS CONTENT
Lesson 1: Excel basics
The paper spreadsheet
The Excel program
The workbook environment
Lesson 2: Entering data and navigating in a worksheet
Entering and correcting data
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques
Lesson 3: Modifying a workbook
Working with ranges
Working with functions
Editing cell contents
Lesson 4: Moving and copying data
Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature
Lesson 5: Formatting a worksheet
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Lesson 6: Printing a worksheet
Checking spelling
Using the Print Preview command
Printing a large worksheet
Additional print options
Lesson 7: Introduction to the workbook environment
Using a multiple-sheet workbook
Creating a chart
Outlining
Spreadsheet Solutions
Lesson 8: Creating Excel Web pages
Using Excel as a Web tool
NECESSARY SOFTWARE AND HARDWARE
- 32 megabytes (MB) of Random Access Memory (RAM) necessary
to run Excel. You will need a minimum of 500 MB of hard-disk space available
for Office 2000 after Windows 98 is installed.
- A Pentium 90 or higher processor.
- Windows 95, 98 or Windows NT 4.0 with Service Pack 3
(or higher) installed.
- Microsoft Office.
- Microsoft mouse or compatible pointing device.
- A printer (optional). You must have an installed printer
driver to use Print Preview.
WHAT'S NEXT?
- Excel - Charting and Organizing Data. Explore all of Excel's impressive charting capabilities and
list management functions.
- Excel - Advanced. Master
advanced formulas and other advanced features including macros and pivot
tables.
- Mini Power Sessions:
--Create And Manage A Worksheet Database Using Excel
--Integrate Data And Graphs Into Your Word Document Using Excel And MS
Graph
--Make Sense Of Sales And Product Data With Pivot Tables Using Excel
--Save Time With Functions Using Excel
--Showcase Your Data With Charts Using Excel
--Track And Analyze Business Data Using Excel
| 