{\rtf1\ansi\ansicpg1252\uc1 \deff0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;}
{\f2\fmodern\fcharset0\fprq1{\*\panose 02070309020205020404}Courier New;}{\f3\froman\fcharset2\fprq2{\*\panose 05050102010706020507}Symbol;}{\f14\fnil\fcharset2\fprq2{\*\panose 05000000000000000000}Wingdings;}
{\f90\froman\fcharset238\fprq2 Times New Roman CE;}{\f91\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f93\froman\fcharset161\fprq2 Times New Roman Greek;}{\f94\froman\fcharset162\fprq2 Times New Roman Tur;}
{\f95\froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f96\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f97\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f98\fswiss\fcharset238\fprq2 Arial CE;}{\f99\fswiss\fcharset204\fprq2 Arial Cyr;}
{\f101\fswiss\fcharset161\fprq2 Arial Greek;}{\f102\fswiss\fcharset162\fprq2 Arial Tur;}{\f103\fswiss\fcharset177\fprq2 Arial (Hebrew);}{\f104\fswiss\fcharset178\fprq2 Arial (Arabic);}{\f105\fswiss\fcharset186\fprq2 Arial Baltic;}
{\f106\fmodern\fcharset238\fprq1 Courier New CE;}{\f107\fmodern\fcharset204\fprq1 Courier New Cyr;}{\f109\fmodern\fcharset161\fprq1 Courier New Greek;}{\f110\fmodern\fcharset162\fprq1 Courier New Tur;}
{\f111\fmodern\fcharset177\fprq1 Courier New (Hebrew);}{\f112\fmodern\fcharset178\fprq1 Courier New (Arabic);}{\f113\fmodern\fcharset186\fprq1 Courier New Baltic;}}{\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{\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \snext0 Normal;}{\s1\ql \li360\ri0\sl240\slmult0
\keepn\widctlpar\faauto\outlinelevel0\rin0\lin360\itap0 \b\i\f1\fs16\cf1\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext0 heading 1;}{\*\cs10 \additive Default Paragraph Font;}{\s15\ql \li0\ri0\widctlpar
\tqc\tx4320\tqr\tx8640\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext15 header;}{\s16\ql \li0\ri0\widctlpar
\tqc\tx4320\tqr\tx8640\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext16 footer;}{\*\cs17 \additive \sbasedon10 page number;}}{\*\listtable{\list\listtemplateid624210448
\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\leveltemplateid67698693\'01\u-3929 ?;}{\levelnumbers;}\f14\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 
\fi-360\li1080\jclisttab\tx1080 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\leveltemplateid67698691\'01o;}{\levelnumbers;}\f2\chbrdr\brdrnone\brdrcf1 
\chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li1800\jclisttab\tx1800 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\leveltemplateid67698693\'01\u-3929 ?;}{\levelnumbers;}\f14\chbrdr
\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2520\jclisttab\tx2520 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\leveltemplateid67698689
\'01\u-3913 ?;}{\levelnumbers;}\f3\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li3240\jclisttab\tx3240 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext
\leveltemplateid67698691\'01o;}{\levelnumbers;}\f2\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li3960\jclisttab\tx3960 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace360\levelindent0
{\leveltext\leveltemplateid67698693\'01\u-3929 ?;}{\levelnumbers;}\f14\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li4680\jclisttab\tx4680 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1
\levelspace360\levelindent0{\leveltext\leveltemplateid67698689\'01\u-3913 ?;}{\levelnumbers;}\f3\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5400\jclisttab\tx5400 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0
\levelstartat1\levelspace360\levelindent0{\leveltext\leveltemplateid67698691\'01o;}{\levelnumbers;}\f2\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6120\jclisttab\tx6120 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0
\levelfollow0\levelstartat1\levelspace360\levelindent0{\leveltext\leveltemplateid67698693\'01\u-3929 ?;}{\levelnumbers;}\f14\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6840\jclisttab\tx6840 }{\listname ;}\listid1562322649}}
{\*\listoverridetable{\listoverride\listid1562322649\listoverridecount0\ls1}}{\info{\title Excel 2003: Worksheets}{\author jaltieri}{\operator jaltieri}{\creatim\yr2005\mo5\dy9\hr14\min1}{\revtim\yr2005\mo5\dy9\hr14\min1}{\version2}{\edmins0}{\nofpages3}
{\nofwords510}{\nofchars2911}{\*\company Element K}{\nofcharsws3574}{\vern8247}}\margl1440\margr1080 \widowctrl\ftnbj\aenddoc\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\formshade\horzdoc\dgmargin\dghspace180\dgvspace180\dghorigin1440
\dgvorigin1440\dghshow1\dgvshow1\jexpand\viewkind1\viewscale107\viewzk2\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule \fet0\sectd \linex0\titlepg\sectdefaultcl {\header 
\pard\plain \s1\ql \li0\ri0\sl240\slmult0\keepn\widctlpar\tqr\tx9720\faauto\outlinelevel0\rin0\lin0\itap0 \b\i\f1\fs16\cf1\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {Excel 2003: Worksheets\tab 074 220 Course Outline
\par }}{\footer \pard\plain \s16\qc \li0\ri0\widctlpar\tqc\tx4320\tqr\tx8640\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\field{\*\fldinst {\cs17\b\i\f1\fs16  PAGE }}{\fldrslt {
\cs17\b\i\f1\fs16\lang1024\langfe1024\noproof 3}}}{\b\i\f1\fs16 
\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 \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 
\fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs28\cf1 Excel 2003: Worksheets
\par 
\par }{\b\f1\cf1 Course specifications
\par }{\f1\fs20\cf1 Course number: 074 220
\par Software version number: 2003
\par Course length: 1 day
\par 
\par }{\b\f1\cf1 Hardware/software required to run this course
\par 
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}}\pard \ql \fi-360\li1080\ri0\sl240\slmult0\widctlpar\jclisttab\tx1080\faauto\ls1\rin0\lin1080\itap0 {\f1\fs20\cf1 
A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. 300 MHz is recommended.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}128 MB of RAM.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}A 5 GB hard disk or larger if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.

\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}
A 3 GB hard disk or larger if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}A floppy disk drive.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}A mouse or other pointing device.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}An 800 x 600 resolution monitor.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}Network cards and cabling for local network access.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}A printer (optional).
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}A projection system to display the instructor\rquote s computer screen.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 3.
\par {\listtext\pard\plain\f14\fs20\cf1 \loch\af14\dbch\af0\hich\f14 \'a7\tab}Microsoft Office Professional Enterprise Edition 2003.
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 
\par }{\b\f1\cf1 Course description
\par 
\par }{\b\f1\fs20\cf1 Overview:}{\f1\fs20\cf1  Students will learn basic worksheets skills and how to work with data in worksheets.
\par 
\par }{\b\f1\fs20\cf1 Prerequisites:}{\f1\fs20\cf1  To ensure students\rquote  success with this course, we recommend that they have a familiarity with Windows 2002 Professional or Windows XP Professional.
\par 
\par }{\b\f1\fs20\cf1 Delivery method:}{\f1\fs20\cf1  Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
\par 
\par }{\i\f1\fs20\cf1 \page }{\b\f1\fs28\cf1 Excel 2003: Worksheets
\par 
\par }{\b\f1\cf1 Performance-based objectives
\par 
\par }{\f1\fs20\cf1 Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
\par 
\par }\pard \ql \fi-360\li1080\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin1080\itap0 {\f1\fs20\cf1 *\tab Identify the disadvantages of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.
\par *\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 \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 \page 
\par }{\b\f1\fs28\cf1 Excel 2003: Worksheets
\par 
\par }{\b\f1\cf1 Course content
\par 
\par }{\b\f1\fs20\cf1 Lesson 1: Excel basics
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 The paper spreadsheet
\par The Excel program
\par The workbook environment
\par Task pane navigation
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 
\par }{\b\f1\fs20\cf1 Lesson 2: Entering data and navigating in a worksheet
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Entering and correcting data
\par Saving a file
\par Using formulas
\par Opening a second file
\par Navigation and movement techniques
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 
\par }{\b\f1\fs20\cf1 Lesson 3: Modifying a workbook
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Working with ranges
\par Working with functions
\par Editing cell contents
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 
\par }{\b\f1\fs20\cf1 Lesson 4: Moving and copying data
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Inserting rows and ranges
\par Moving data
\par Copying data
\par Absolute references
\par Using the Fill Series feature
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 
\par }{\b\f1\fs20\cf1 Lesson 5: Formatting a worksheet
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Formatting a worksheet
\par Number formats and text alignment
\par Copying and pasting formats
\par Special and custom formatting
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 
\par }{\b\f1\fs20\cf1 Lesson 6: Printing a worksheet
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Checking spelling
\par Using the Print Preview command
\par Printing a large worksheet
\par Additional print options
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 
\par }{\b\f1\fs20\cf1 Lesson 7: Introduction to the workbook environment
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Using a multiple-sheet workbook
\par Creating a chart
\par Outlining
\par Spreadsheet Solutions
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\f1\fs20\cf1 
\par }{\b\f1\fs20\cf1 Appendix A: Using Excel as a Web tool
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 Using Excel as a Web tool
\par }\pard \ql \li0\ri0\sl240\slmult0\widctlpar\tx2160\faauto\rin0\lin0\itap0 {\f1\fs20\cf1 
\par }\pard \ql \li360\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin360\itap0 {\b\f1\fs20\cf1 Appendix B: New Features in Excel 2003
\par }\pard \ql \li720\ri0\sl240\slmult0\widctlpar\faauto\rin0\lin720\itap0 {\f1\fs20\cf1 New Features
\par }}