{\rtf1\ansi\ansicpg1252\uc1 \deff0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;}}{\colortbl;\red0\green0\blue0;
\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;
\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{\li720\widctlpar\adjustright \f1\fs20\cgrid \snext0 Normal;}{\s1\li720\widctlpar\adjustright \b\f1\fs28\cgrid \sbasedon0 \snext0 heading 1;}{
\s2\li720\sb240\sa160\widctlpar\adjustright \i\f1\cgrid \sbasedon0 \snext0 heading 2;}{\s3\li720\widctlpar\tx1800\adjustright \b\f1\fs18\cgrid \sbasedon0 \snext3 heading 3;}{\*\cs10 \additive Default Paragraph Font;}{\s15\widctlpar
\tqr\tx10080\adjustright \i\f1\fs18\cgrid \sbasedon0 \snext15 footer;}{\*\cs16 \additive \fs16 \sbasedon10 annotation reference;}{\s17\widctlpar\tqc\tx4320\tqr\tx8640\adjustright \i\f1\fs16\cgrid \sbasedon0 \snext17 header;}{
\s18\li720\widctlpar\adjustright \f1\fs20\cgrid \sbasedon0 \snext18 annotation text;}}{\info{\author Robert N. Kulik}{\operator Robert Voelcker}{\creatim\yr1998\mo12\dy30\hr15\min24}{\revtim\yr1998\mo12\dy30\hr15\min24}
{\printim\yr1998\mo12\dy28\hr9\min33}{\version2}{\edmins0}{\nofpages3}{\nofwords617}{\nofchars3519}{\*\company Logical Operations}{\nofcharsws4321}{\vern89}}\margl1080\margr1080\margt1555\margb1080 
\facingp\widowctrl\ftnbj\aenddoc\sprsspbf\lytprtmet\formshade\viewkind1\viewscale100\pgbrdrhead\pgbrdrfoot \fet0{\*\template C:\\WINWORD\\TEMPLATE\\N-CRSOUT.DOT}{\*\docvar {cnum}{52220}}\sectd 
\psz1\linex0\headery504\footery504\endnhere\titlepg\sectdefaultcl {\headerl \pard\plain \s17\widctlpar\tqc\tx4320\tqr\tx8640\adjustright \i\f1\fs16\cgrid {\field{\*\fldinst { REF cname  \\* CHARFORMAT }}{\fldrslt {Excel 2000: Worksheets}}}{
\par }}{\headerr \pard\plain \s17\widctlpar\tqr\tx10080\adjustright \i\f1\fs16\cgrid {\tab Course Outline
\par }}{\footerl \pard\plain \s15\widctlpar\tqr\tx10080\adjustright \i\f1\fs18\cgrid {Page }{\field{\*\fldinst { PAGE  \\* CHARFORMAT }}{\fldrslt {\lang1024 2}}}{\tab 
\par }}{\footerr \pard\plain \s15\widctlpar\tqr\tx10080\adjustright \i\f1\fs18\cgrid {\tab Page }{\field{\*\fldinst { PAGE  \\* CHARFORMAT }}{\fldrslt {\lang1024 3}}}{
\par }}{\footerf \pard\plain \s15\widctlpar\tqr\tx10080\adjustright \i\f1\fs18\cgrid {\tab Page }{\field{\*\fldinst {PAGE \\* CHARFORMAT}}{\fldrslt {\lang1024 1}}}{
\par }}{\*\pnseclvl1\pnucrm\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang{\pntxta )}}
{\*\pnseclvl5\pndec\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl8
\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}\pard\plain \li720\widctlpar\adjustright \f1\fs20\cgrid {\field{\*\fldinst {\v set cname "Excel 2000: Worksheets"}}{\fldrslt 
{\v\lang1024 {\*\bkmkstart cname}Excel 2000: Worksheets{\*\bkmkend cname}}}}{\v 
\par }\pard \li720\widctlpar\adjustright {\field{\*\fldinst {\v set cnum "074 200"}}{\fldrslt {\v\lang1024 {\*\bkmkstart cnum}074 200{\*\bkmkend cnum}}}}{\v 
\par }{\field{\*\fldinst {\v set svernum "2000"}}{\fldrslt {\v\lang1024 {\*\bkmkstart softnum}{\*\bkmkstart svernum}2000{\*\bkmkend svernum}{\*\bkmkend softnum}}}}{\v 
\par }{\field{\*\fldinst {\v set clength "1"}}{\fldrslt {\v\lang1024 {\*\bkmkstart clength}1{\*\bkmkend clength}}}}{\v 
\par }{\field{\*\fldinst {\v set ram "6"}}{\fldrslt {\v\lang1024 {\*\bkmkstart course_name}{\*\bkmkstart ram}6{\*\bkmkend ram}{\*\bkmkend course_name}}}}{\v 
\par }{\field{\*\fldinst {\v set pgmname "Excel"}}{\fldrslt {\v\lang1024 {\*\bkmkstart program}{\*\bkmkstart pgmname}Excel{\*\bkmkend pgmname}{\*\bkmkend program}}}}{\v 
\par }{\field{\*\fldinst {\v set addinfo "This course has been designed to help students prepare for the Proficient User certification of the Certified Microsoft Office User Certification with Microsoft Excel 97."}}{\fldrslt {\v\lang1024 {\*\bkmkstart addinfo}
This course has been designed to help students prepare for the Proficient User certification of the Certified Microsoft Office User Certification with Microsoft Excel 97.{\*\bkmkend addinfo}}}}{\v 
\par }{\field{\*\fldinst {\b\fs28  REF cname \\* CHARFORMAT }}{\fldrslt {\b\fs28 Excel 2000: Worksheets}}}{\b\fs28 
\par }{\b\fs24 
\par Course specifications
\par }{Course number: }{\field{\*\fldinst { REF cnum \\* CHARFORMAT }}{\fldrslt {074 200}}}{
\par }\pard \li720\widctlpar\adjustright {Software version number: }{\field{\*\fldinst { REF softnum \\* CHARFORMAT }}{\fldrslt {2000}}}{
\par Course length: }{\field{\*\fldinst { REF clength \\* CHARFORMAT }}{\fldrslt {1}}}{ day
\par }{\b 
\par }\pard \li720\widctlpar\adjustright {\b\fs24 Hardware/software required to run this course
\par }{\b 
\par }{
You will need 32 megabytes (MB) of Random Access Memory (RAM) in order 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 is needed. A typical instal
lation of Windows 98 and a full-suite installation of Microsoft Office 2000 is needed. In addition, you will need printers if you want to print }{\cf1 the worksheets created in the}{ course. At a minimum, you will 
need to install a printer driver. This book has been developed using the Windows 98 platform; however, this course has been tested and runs on Windows 95, Windows 98, and Windows NT 4.0. 
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b\fs24 Course description
\par }{\b 
\par Overview:}{ Students will learn basic worksheets skills and how to work with data in worksheets.
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Prerequisites:}{ }{\i Windows 98: Introduction,}{ or equivalent knowledge.
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Delivery method:}{ Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Benefits:}{ Students will learn how to use an electronic spreadsheet to create basic data reports.
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Target student:}{ Students enrolling in this course should understand how to use Windows 98.
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b What's next:}{ }{\i Excel 2000: Worksheets }{is the first course in this series. }{\i Excel 2000: Charting and Organizing Data, }{
the next course in this series, teaches students how to use the charting and list management capabilities in Excel. Students who want to learn advanced features can take }{\i Excel 2000: Advanced.}{
\par }\pard \li720\widctlpar\adjustright {\page }{\field{\*\fldinst {\b\fs28  REF cname \\* CHARFORMAT }}{\fldrslt {\b\fs28 Excel 2000: Worksheets}}}{\b\fs28 
\par }\pard \li720\widctlpar\adjustright {\b\fs24 
\par Performance-based objectives
\par }{
\par }\pard \li720\widctlpar\adjustright {Lesson objectives help students become comfortable with the course, and also provide a means to \line evaluate learning. Upon successful completion of this course, students will be able to:
\par 
\par }\pard \fi-360\li1440\widctlpar\adjustright {*\tab Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.
\par }\pard \fi-360\li1440\widctlpar\adjustright {*\tab Create a basic worksheet by entering text, values, and formulas.
\par *\tab Create formulas by using Excel\rquote s built-in functions.
\par *\tab Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.
\par *\tab Change the appearance of worksheet data by using a variety of formatting techniques.
\par *\tab Prepare a document for printing by using the spell checking feature and a variety of printing options.
\par *\tab Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.
\par }\pard \fi-360\li1440\widctlpar\adjustright {*\tab Save an Excel workbook as a Web page.
\par }\pard \li720\widctlpar\adjustright {\page }{\field{\*\fldinst {\b\fs28  REF cname \\* CHARFORMAT }}{\fldrslt {\b\fs28 Excel 2000: Worksheets}}}{\b\fs28 
\par }\pard \li720\widctlpar\adjustright {\b\fs24 
\par Course content
\par }{\b 
\par Lesson 1: Excel basics
\par }\pard \li1080\widctlpar\adjustright {The paper spreadsheet
\par }\pard \li1080\widctlpar\adjustright {The Excel program
\par The workbook environment
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Lesson 2: Entering data and navigating in a worksheet
\par }\pard \li1080\widctlpar\adjustright {Entering and correcting data
\par }\pard \li1080\widctlpar\adjustright {Saving a file
\par Using formulas
\par Opening a second file
\par Navigation and movement techniques
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Lesson 3: Modifying a workbook
\par }\pard \li1080\widctlpar\adjustright {Working with ranges
\par }\pard \li1080\widctlpar\adjustright {Working with functions
\par Editing cell contents
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Lesson 4: Moving and copying data
\par }\pard \li1080\widctlpar\adjustright {Inserting rows and ranges
\par }\pard \li1080\widctlpar\adjustright {Moving data
\par Copying data
\par Absolute references
\par Using the Fill Series feature
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Lesson 5: Formatting a worksheet
\par }\pard \li1080\widctlpar\adjustright {Formatting a worksheet
\par }\pard \li1080\widctlpar\adjustright {Number formats and text alignment
\par Copying and pasting formats
\par Special and custom formatting
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Lesson 6: Printing a worksheet
\par }\pard \li1080\widctlpar\adjustright {Checking spelling
\par }\pard \li1080\widctlpar\adjustright {Using the Print Preview command
\par Printing a large worksheet
\par Additional print options
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Lesson 7: Introduction to the workbook environment
\par }\pard \li1080\widctlpar\adjustright {Using a multiple-sheet workbook
\par }\pard \li1080\widctlpar\adjustright {Creating a chart
\par }\pard \li1080\widctlpar\adjustright {Outlining
\par }\pard \li1080\widctlpar\adjustright {Spreadsheet Solutions
\par }\pard \li720\widctlpar\adjustright {\b 
\par }\pard \li720\widctlpar\adjustright {\b Lesson 8: Creating Excel Web pages
\par }\pard \li1080\widctlpar\adjustright {Using Excel as a Web tool
\par }\pard \li720\widctlpar\adjustright {
\par }}