{\rtf1\adeflang1025\ansi\ansicpg1252\uc1\adeff0\deff0\stshfdbch0\stshfloch0\stshfhich0\stshfbi0\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;}{\f10\fnil\fcharset2\fprq2{\*\panose 05000000000000000000}Wingdings;} {\f39\froman\fcharset238\fprq2 Times New Roman CE;}{\f40\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f42\froman\fcharset161\fprq2 Times New Roman Greek;}{\f43\froman\fcharset162\fprq2 Times New Roman Tur;} {\f44\fbidi \froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f45\fbidi \froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f46\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f47\froman\fcharset163\fprq2 Times New Roman (Vietnamese);} {\f49\fswiss\fcharset238\fprq2 Arial CE;}{\f50\fswiss\fcharset204\fprq2 Arial Cyr;}{\f52\fswiss\fcharset161\fprq2 Arial Greek;}{\f53\fswiss\fcharset162\fprq2 Arial Tur;}{\f54\fbidi \fswiss\fcharset177\fprq2 Arial (Hebrew);} {\f55\fbidi \fswiss\fcharset178\fprq2 Arial (Arabic);}{\f56\fswiss\fcharset186\fprq2 Arial Baltic;}{\f57\fswiss\fcharset163\fprq2 Arial (Vietnamese);}{\f59\fmodern\fcharset238\fprq1 Courier New CE;}{\f60\fmodern\fcharset204\fprq1 Courier New Cyr;} {\f62\fmodern\fcharset161\fprq1 Courier New Greek;}{\f63\fmodern\fcharset162\fprq1 Courier New Tur;}{\f64\fbidi \fmodern\fcharset177\fprq1 Courier New (Hebrew);}{\f65\fbidi \fmodern\fcharset178\fprq1 Courier New (Arabic);} {\f66\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f67\fmodern\fcharset163\fprq1 Courier New (Vietnamese);}}{\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 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \snext0 Normal;}{ \s2\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 \rtlch \ab\af0\afs36\alang1025 \ltrch \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext2 \styrsid7945759 heading 2;}{\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \rtlch \ab\af0\afs27\alang1025 \ltrch \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext3 \styrsid7945759 heading 3;}{\*\cs10 \additive \ssemihidden Default Paragraph Font;}{\* \ts11\tsrowd\trftsWidthB3\trpaddl108\trpaddr108\trpaddfl3\trpaddft3\trpaddfb3\trpaddfr3\trcbpat1\trcfpat1\tscellwidthfts0\tsvertalt\tsbrdrt\tsbrdrl\tsbrdrb\tsbrdrr\tsbrdrdgl\tsbrdrdgr\tsbrdrh\tsbrdrv \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \rtlch \af0\afs20 \ltrch \fs20\lang1024\langfe1024\cgrid\langnp1024\langfenp1024 \snext11 \ssemihidden Normal Table;}{ \s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext15 \styrsid7945759 Normal (Web);}} {\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable{\list\listtemplateid1964398794{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fs20\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel \levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0 \levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid340276185} {\list\listtemplateid-1569792038{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23 \levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fs20\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1 \levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0 \leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid451247384}{\list\listtemplateid-244947872{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1 \levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01o;}{\levelnumbers;}\f2\fs20\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0 \leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid1210459558}{\list\listtemplateid1465705444{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3913 ?;}{\levelnumbers;} \f3\fs20\fbias0 \fi-360\li720\jclisttab\tx720\lin720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01o;}{\levelnumbers;}\f2\fs20\fbias0 \fi-360\li1440\jclisttab\tx1440\lin1440 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2160\jclisttab\tx2160\lin2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0 \leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li2880\jclisttab\tx2880\lin2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0 \levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li3600\jclisttab\tx3600\lin3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext \'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li4320\jclisttab\tx4320\lin4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5040\jclisttab\tx5040\lin5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li5760\jclisttab\tx5760\lin5760 } {\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'01\u-3929 ?;}{\levelnumbers;}\f10\fs20\fbias0 \fi-360\li6480\jclisttab\tx6480\lin6480 }{\listname ;}\listid1894610110}} {\*\listoverridetable{\listoverride\listid1894610110\listoverridecount0\ls1}{\listoverride\listid451247384\listoverridecount0\ls2}{\listoverride\listid340276185\listoverridecount0\ls3}{\listoverride\listid1210459558\listoverridecount0\ls4}}{\*\pgptbl {\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}}{\*\rsidtbl \rsid934649\rsid6455235\rsid7945759}{\*\generator Microsoft Word 11.0.5604;}{\info{\title Microsoft\'ae Office Excel\'ae 2010: Level 1 (Second Edition)}{\author kalpanak}{\operator kalpanak} {\creatim\yr2011\mo9\dy9\hr15\min8}{\revtim\yr2011\mo9\dy9\hr15\min9}{\version1}{\edmins1}{\nofpages3}{\nofwords573}{\nofchars3269}{\*\company EK}{\nofcharsws3835}{\vern24689}}\ltrsect \widowctrl\ftnbj\aenddoc\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\formshade\horzdoc\dgmargin\dghspace180\dgvspace180\dghorigin1800\dgvorigin1440\dghshow1\dgvshow1 \jexpand\viewkind1\viewscale100\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule\nobrkwrptbl\snaptogridincell\allowfieldendsel\wrppunct \asianbrkrule\rsidroot7945759\newtblstyruls\nogrowautofit \fet0\ltrpar \sectd \ltrsect\linex0\endnhere\sectlinegrid360\sectdefaultcl\sftnbj {\*\pnseclvl1\pnucrm\pnqc\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl2 \pnucltr\pnqc\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl3\pndec\pnqc\pnstart1\pnindent720\pnhang {\pntxta .}}{\*\pnseclvl4\pnlcltr\pnqc\pnstart1\pnindent720\pnhang {\pntxta )}}{\*\pnseclvl5\pndec\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (} {\pntxta )}}{\*\pnseclvl6\pnlcltr\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}{\*\pnseclvl8\pnlcltr\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}} {\*\pnseclvl9\pnlcrm\pnqc\pnstart1\pnindent720\pnhang {\pntxtb (}{\pntxta )}}\pard\plain \ltrpar\s2\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \ab\af0\afs36\alang1025 \ltrch \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \af1 \ltrch \f1\insrsid7945759 Microsoft\'ae Office Excel\'ae 2010: Level 1 (Second Edition) \par }\pard\plain \ltrpar\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \ab\af0\afs27\alang1025 \ltrch \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 { \rtlch \af1 \ltrch \f1\insrsid7945759 Course Specifications \par }\pard\plain \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Course number: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 084676\line }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Course length: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 1.0 day(s)\line }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Certification: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 MOS: Microsoft Office Excel 2010 Exam 77\endash 882, MOS: Microsoft Office Excel 2010 Expert Exam 77\endash 888 \par }\pard\plain \ltrpar\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \ab\af0\afs27\alang1025 \ltrch \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 { \rtlch \af1 \ltrch \f1\insrsid7945759 Course Description \par }\pard\plain \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Course Objective: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.\line \line }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Target Student: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.\line \line }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Prerequisites: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Spec i fically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. To ensure your success, we recommend you first take one of Element K's introductory Windows courses, such as either of the following, or have equivalent skills and knowledge: \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ltrpar\ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar \jclisttab\tx720\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Windows XP Professional: Level 1 \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Windows XP: Introduction \par }\pard\plain \ltrpar\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \ab\af0\afs27\alang1025 \ltrch \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 { \rtlch \af1 \ltrch \f1\insrsid7945759 Certification \par }\pard\plain \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (MOS) certification skill sets. The MOS and certification program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft produ cts. \par }\pard\plain \ltrpar\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \ab\af0\afs27\alang1025 \ltrch \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 { \rtlch \af1 \ltrch \f1\insrsid7945759 Hardware Requirements \par }\pard\plain \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components: \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ltrpar\ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar \jclisttab\tx720\aspalpha\aspnum\faauto\ls2\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 1 GHz Pentium-class processor or faster. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A minimum of 1 GB of RAM is recommended. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}20 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for Office 2010 installation. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A DVD-ROM drive. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A keyboard and mouse or other pointing device. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A 1024 x 768 resolution SVGA monitor is recommended. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Network cards and cabling for local network access. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Internet access (contact your local network administrator). \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A printer (optional) or an installed printer driver. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A projection system to display the instructor\rquote s computer screen. \par }\pard\plain \ltrpar\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \ab\af0\afs27\alang1025 \ltrch \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 { \rtlch \af1 \ltrch \f1\insrsid7945759 Software Requirements \par }\pard\plain \ltrpar\s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Each computer requires the following software: \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard\plain \ltrpar\ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar \jclisttab\tx720\aspalpha\aspnum\faauto\ls3\adjustright\rin0\lin720\itap0\pararsid7945759 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Microsoft\'ae Office Professional Plus 2010 Edition \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Microsoft\'ae Windows\'ae XP Professional with Service Pack 3 \par }\pard\plain \ltrpar\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \ab\af0\afs27\alang1025 \ltrch \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 { \rtlch \af1 \ltrch \f1\insrsid7945759 Course Objectives \par }\pard\plain \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Upon successful completion of this course, students will be able to: \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ltrpar\ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar \jclisttab\tx720\aspalpha\aspnum\faauto\ls4\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 create a basic worksheet by using Microsoft Excel 2010. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}perform calculations in an Excel worksheet. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}modify an Excel worksheet. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}modify the appearance of data within a worksheet. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}manage Excel workbooks. \par {\listtext\pard\plain\ltrpar \rtlch \af1\afs20 \ltrch \f3\fs20\insrsid7945759 \loch\af3\dbch\af0\hich\f3 \'b7\tab}print the content of an Excel worksheet. \par }\pard\plain \ltrpar\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \ab\af0\afs27\alang1025 \ltrch \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 { \rtlch \af1 \ltrch \f1\insrsid7945759 Course Content \par }\pard\plain \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 \rtlch \af0\afs24\alang1025 \ltrch \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Lesson 1: Getting Started with Excel \par }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 \par }\pard \ltrpar\ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 1A: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Identify the Elements of the Excel Interface \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 1B: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Navigate and Select Cells in Worksheets \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 1C: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Customize the Excel Interface \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 1D: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Create a Basic Worksheet \par }\pard \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Lesson 2: Performing Calculations in an Excel Worksheet \par }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 \par }\pard \ltrpar\ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 2A: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Create Formulas in a Worksheet \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 2B: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Insert Functions in a Worksheet \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 2C: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Reuse Formulas \par }\pard \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Lesson 3: Modifying an Excel Worksheet \par }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 \par }\pard \ltrpar\ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 3A: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Edit Worksheet Data \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 3B: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Find and Replace Data \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 3C: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Manipulate Worksheet Elements \par }\pard \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Lesson 4: Modifying the Appearance of a Worksheet \par }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 \par }\pard \ltrpar\ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 4A: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Apply Font Properties \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 4B: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Add Borders and Colors to Cells \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 4C: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Align Content in a Cell \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 4D: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Apply Number Formatting \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 4E: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Apply Cell Styles \par }\pard \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Lesson 5: Managing an Excel Workbook \par }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 \par }\pard \ltrpar\ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 5A: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Manage Worksheets \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 5B: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 View Worksheets and Workbooks \par }\pard \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Lesson 6: Printing Excel Workbooks \par }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 \par }\pard \ltrpar\ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 6A: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Define the Page Layout \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Topic 6B: }{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 Print a Workbook \par }\pard \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7945759 {\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Appendix A: Microsoft Office Excel 2010 Exam 77\endash 882}{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 \par }{\rtlch \ab\af1\afs20 \ltrch \b\f1\fs20\insrsid7945759 Appendix B: Microsoft Office Excel 2010 Expert Exam 77\endash 888}{\rtlch \af1\afs20 \ltrch \f1\fs20\insrsid7945759 \par }\pard \ltrpar\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\rtlch \af0 \ltrch \insrsid934649 \par }}