{\rtf1\ansi\ansicpg1252\uc1\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;}
{\f36\froman\fcharset238\fprq2 Times New Roman CE;}{\f37\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f39\froman\fcharset161\fprq2 Times New Roman Greek;}{\f40\froman\fcharset162\fprq2 Times New Roman Tur;}
{\f41\froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f42\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f43\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f44\froman\fcharset163\fprq2 Times New Roman (Vietnamese);}
{\f46\fswiss\fcharset238\fprq2 Arial CE;}{\f47\fswiss\fcharset204\fprq2 Arial Cyr;}{\f49\fswiss\fcharset161\fprq2 Arial Greek;}{\f50\fswiss\fcharset162\fprq2 Arial Tur;}{\f51\fswiss\fcharset177\fprq2 Arial (Hebrew);}
{\f52\fswiss\fcharset178\fprq2 Arial (Arabic);}{\f53\fswiss\fcharset186\fprq2 Arial Baltic;}{\f54\fswiss\fcharset163\fprq2 Arial (Vietnamese);}{\f56\fmodern\fcharset238\fprq1 Courier New CE;}{\f57\fmodern\fcharset204\fprq1 Courier New Cyr;}
{\f59\fmodern\fcharset161\fprq1 Courier New Greek;}{\f60\fmodern\fcharset162\fprq1 Courier New Tur;}{\f61\fmodern\fcharset177\fprq1 Courier New (Hebrew);}{\f62\fmodern\fcharset178\fprq1 Courier New (Arabic);}
{\f63\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f64\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 \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 \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext2 \styrsid9924658 heading 2;}{
\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext3 \styrsid9924658 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 \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 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext15 \styrsid9924658 Normal (Web);}}
{\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable{\list\listtemplateid-218877818{\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 ;}\listid3825669}
{\list\listtemplateid1865811098{\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 ;}\listid584459607}{\list\listtemplateid-326965152{\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 ;}\listid898906034}{\list\listtemplateid1774999392{\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 ;}\listid1713651630}}
{\*\listoverridetable{\listoverride\listid1713651630\listoverridecount0\ls1}{\listoverride\listid898906034\listoverridecount0\ls2}{\listoverride\listid584459607\listoverridecount0\ls3}{\listoverride\listid3825669\listoverridecount0\ls4}}{\*\pgptbl {\pgp
\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}}{\*\rsidtbl \rsid9924658}{\*\generator Microsoft Word 11.0.5604;}{\info{\title Microsoft\'ae Office Excel\'ae 2010: Level 3}{\author IndumathiD}{\operator IndumathiD}
{\creatim\yr2010\mo10\dy5\hr10\min17}{\revtim\yr2010\mo10\dy5\hr10\min19}{\version1}{\edmins2}{\nofpages3}{\nofwords529}{\nofchars3019}{\*\company Element  K India}{\nofcharsws3541}{\vern24689}}
\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\rsidroot9924658\newtblstyruls\nogrowautofit \fet0\sectd \linex0\endnhere\sectlinegrid360\sectdefaultcl\sftnbj {\*\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 
\s2\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0\pararsid9924658 \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9924658 Microsoft\'ae Office Excel\'ae
 2010: Level 3
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9924658 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9924658 Course Specifications
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid9924658 Course number: }{\f1\fs20\insrsid9924658 084578\line }{
\b\f1\fs20\insrsid9924658 Course length: }{\f1\fs20\insrsid9924658 1.0 day(s)
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9924658 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9924658 Course Description
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid9924658 Course Objective: }{\f1\fs20\insrsid9924658 
You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.\line \line }{\b\f1\fs20\insrsid9924658 Target Student: }
{\f1\fs20\insrsid9924658 This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. \line \line }{
\b\f1\fs20\insrsid9924658 Prerequisites: }{\f1\fs20\insrsid9924658 To ensure your success, we recommend that you first take the following Element K courses or have equivalent knowledge: }{\i\f1\fs20\insrsid9924658 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0\pararsid9924658 {
\i\f1\fs20\insrsid9924658 Microsoft\'ae Office Excel\'ae 2010: Level 1 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Microsoft\'ae Office Excel\'ae 2010: Level 2 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9924658 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9924658 Hardware Requirements
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid9924658 
For this course, you will need one computer for each student and the instructor. Each computer should have the following minimum hardware configuration: 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls2\adjustright\rin0\lin720\itap0\pararsid9924658 {
\f1\fs20\insrsid9924658 A 1 GHz Pentium-class processor or faster. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A minimum of 256 MB of RAM. (512 MB of RAM is recommended.) 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A 10 GB hard disk or larger. You should have at least 1 GB of free hard disk space available for the Office installation. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A CD-ROM drive. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A keyboard and mouse or other pointing device. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A 1024 x 768 resolution monitor. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Network cards and cabling for local network access. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Internet access. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A printer (optional) or an installed printer driver. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}A projection system to display the instructor\rquote s computer screen. 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9924658 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9924658 Software Requirements
\par }\pard\plain \s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid9924658 Each computer 
requires the following software:
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard\plain \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls3\adjustright\rin0\lin720\itap0\pararsid9924658 
\fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid9924658 Microsoft\'ae Office Professional Plus 2010 Edition. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Microsoft\'ae Office Suite Service Pack 1. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Microsoft\'ae Windows\'ae XP Professional with Service Pack 2. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Windows Rights Management Services (RMS) Client. 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9924658 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9924658 
\par }{\f1\insrsid9924658 Course Objectives
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid9924658 Upon successful completion of this course, students will be able to: 

\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls4\adjustright\rin0\lin720\itap0\pararsid9924658 {
\f1\fs20\insrsid9924658 enhance productivity and efficiency by streamlining the workflow. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}collaborate with other workbook users. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}audit worksheets. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}analyze data. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}work with multiple workbooks. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}import and export data. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}integrate Excel data with the web. 
\par {\listtext\pard\plain\f3\fs20\insrsid9924658 \loch\af3\dbch\af0\hich\f3 \'b7\tab}structure workbooks with XML. 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid9924658 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid9924658 Course Content
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid9924658 Lesson 1: Streamlining Workflow}{\b\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Topic 1A: }{\f1\fs20\insrsid9924658 Update Workbook Properties 
\par }{\b\f1\fs20\insrsid9924658 Topic 1B: }{\f1\fs20\insrsid9924658 Create a Macro 
\par }{\b\f1\fs20\insrsid9924658 Topic 1C: }{\f1\fs20\insrsid9924658 Edit a Macro 
\par }{\b\f1\fs20\insrsid9924658 Topic 1D: }{\f1\fs20\insrsid9924658 Apply Conditional Formatting 
\par }{\b\f1\fs20\insrsid9924658 Topic 1E: }{\f1\fs20\insrsid9924658 Add Data Validation Criteria }{\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Lesson 2: Collaborating with Other Users}{\b\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Topic 2A: }{\f1\fs20\insrsid9924658 Protect Files 
\par }{\b\f1\fs20\insrsid9924658 Topic 2B: }{\f1\fs20\insrsid9924658 Share a Workbook 
\par }{\b\f1\fs20\insrsid9924658 Topic 2C: }{\f1\fs20\insrsid9924658 Set Revision Tracking 
\par }{\b\f1\fs20\insrsid9924658 Topic 2D: }{\f1\fs20\insrsid9924658 Review Tracked Revisions 
\par }{\b\f1\fs20\insrsid9924658 Topic 2E: }{\f1\fs20\insrsid9924658 Merge Workbooks 
\par }{\b\f1\fs20\insrsid9924658 Topic 2F: }{\f1\fs20\insrsid9924658 Administer Digital Signatures 
\par }{\b\f1\fs20\insrsid9924658 Topic 2G: }{\f1\fs20\insrsid9924658 Restrict Document Access }{\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Lesson 3: Auditing Worksheets}{\b\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Topic 3A: }{\f1\fs20\insrsid9924658 Trace Cells 
\par }{\b\f1\fs20\insrsid9924658 Topic 3B: }{\f1\fs20\insrsid9924658 Troubleshoot Invalid Data and Formula Errors 
\par }{\b\f1\fs20\insrsid9924658 Topic 3C: }{\f1\fs20\insrsid9924658 Watch and Evaluate Formulas 
\par }{\b\f1\fs20\insrsid9924658 Topic 3D: }{\f1\fs20\insrsid9924658 Create a Data List Outline }{\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Lesson 4: Analyzing Data}{\b\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Topic 4A: }{\f1\fs20\insrsid9924658 Create a Trendline 
\par }{\b\f1\fs20\insrsid9924658 Topic 4B: }{\f1\fs20\insrsid9924658 Create Sparklines 
\par }{\b\f1\fs20\insrsid9924658 Topic 4C: }{\f1\fs20\insrsid9924658 Create Scenarios 
\par }{\b\f1\fs20\insrsid9924658 Topic 4D: }{\f1\fs20\insrsid9924658 Perform a What-If Analysis 
\par }{\b\f1\fs20\insrsid9924658 Topic 4E: }{\f1\fs20\insrsid9924658 Perform a Statistical Analysis with the Analysis ToolPak }{\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Lesson 5: Working with Multiple Workbooks}{\b\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Topic 5A: }{\f1\fs20\insrsid9924658 Create a Workspace 
\par }{\b\f1\fs20\insrsid9924658 Topic 5B: }{\f1\fs20\insrsid9924658 Consolidate Data 
\par }{\b\f1\fs20\insrsid9924658 Topic 5C: }{\f1\fs20\insrsid9924658 Link Cells in Different Workbooks 
\par }{\b\f1\fs20\insrsid9924658 Topic 5D: }{\f1\fs20\insrsid9924658 Edit Links 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Lesson 6: Importing and Exporting Data}{\b\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Topic 6A: }{\f1\fs20\insrsid9924658 Export Excel Data 
\par }{\b\f1\fs20\insrsid9924658 Topic 6B: }{\f1\fs20\insrsid9924658 Import a Delimited Text File }{\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Lesson 7: Integrating Excel Data with the Web}{\b\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Topic 7A: }{\f1\fs20\insrsid9924658 Publish a Worksheet to the Web 
\par }{\b\f1\fs20\insrsid9924658 Topic 7B: }{\f1\fs20\insrsid9924658 Import Data from the Web 
\par }{\b\f1\fs20\insrsid9924658 Topic 7C: }{\f1\fs20\insrsid9924658 Create a Web Query }{\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Lesson 8: Structuring Workbooks with XML}{\b\f1\fs20\insrsid9924658 
\par }{\f1\fs20\insrsid9924658 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid9924658 {\b\f1\fs20\insrsid9924658 Topic 8A: }{\f1\fs20\insrsid9924658 Develop XML Maps 
\par }{\b\f1\fs20\insrsid9924658 Topic 8B: }{\f1\fs20\insrsid9924658 Import and Export XML Data 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\insrsid9924658 
\par }}