{\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;} {\f178\froman\fcharset238\fprq2 Times New Roman CE;}{\f179\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f181\froman\fcharset161\fprq2 Times New Roman Greek;}{\f182\froman\fcharset162\fprq2 Times New Roman Tur;} {\f183\froman\fcharset177\fprq2 Times New Roman (Hebrew);}{\f184\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f185\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f186\froman\fcharset163\fprq2 Times New Roman (Vietnamese);} {\f188\fswiss\fcharset238\fprq2 Arial CE;}{\f189\fswiss\fcharset204\fprq2 Arial Cyr;}{\f191\fswiss\fcharset161\fprq2 Arial Greek;}{\f192\fswiss\fcharset162\fprq2 Arial Tur;}{\f193\fswiss\fcharset177\fprq2 Arial (Hebrew);} {\f194\fswiss\fcharset178\fprq2 Arial (Arabic);}{\f195\fswiss\fcharset186\fprq2 Arial Baltic;}{\f196\fswiss\fcharset163\fprq2 Arial (Vietnamese);}{\f198\fmodern\fcharset238\fprq1 Courier New CE;}{\f199\fmodern\fcharset204\fprq1 Courier New Cyr;} {\f201\fmodern\fcharset161\fprq1 Courier New Greek;}{\f202\fmodern\fcharset162\fprq1 Courier New Tur;}{\f203\fmodern\fcharset177\fprq1 Courier New (Hebrew);}{\f204\fmodern\fcharset178\fprq1 Courier New (Arabic);} {\f205\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f206\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 \styrsid4018572 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 \styrsid4018572 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 \styrsid4018572 Normal (Web);}} {\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable{\list\listtemplateid2050268916{\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 ;}\listid643121754} {\list\listtemplateid702450510{\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 ;}\listid1111970344}{\list\listtemplateid1244844690{\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 ;}\listid1596210987}}{\*\listoverridetable{\listoverride\listid643121754\listoverridecount0\ls1}{\listoverride\listid1111970344\listoverridecount0\ls2}{\listoverride\listid1596210987 \listoverridecount0\ls3}}{\*\pgptbl {\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}}{\*\rsidtbl \rsid4018572\rsid10493117\rsid10501973}{\*\generator Microsoft Word 11.0.5604;}{\info{\title Microsoft\'ae Excel\'ae 2010: PivotTables}{\author indumathid} {\operator indumathid}{\creatim\yr2011\mo4\dy26\hr14\min52}{\revtim\yr2011\mo4\dy26\hr14\min53}{\version1}{\edmins1}{\nofpages2}{\nofwords339}{\nofchars1933}{\*\company Element K India}{\nofcharsws2268}{\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\rsidroot4018572\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\pararsid4018572 \b\fs36\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid4018572 Microsoft\'ae Excel\'ae 2010: PivotTables \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid4018572 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid4018572 Course Specifications \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid4018572 Course number: }{\f1\fs20\insrsid4018572 084580\line }{ \b\f1\fs20\insrsid4018572 Course length: }{\f1\fs20\insrsid4018572 0.5 day(s) \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid4018572 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid4018572 Course Description \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid4018572 Course Objective: }{\f1\fs20\insrsid4018572 You will create and analyze PivotTable data.\line \line }{\b\f1\fs20\insrsid4018572 Target Student: }{\f1\fs20\insrsid4018572 This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.\line \line }{ \b\f1\fs20\insrsid4018572 Prerequisites: }{\f1\fs20\insrsid4018572 Before starting this course, students are recommended to take the following Element K courses or have equivalent knowledge: Microsoft\'ae Office Excel\'ae 2010: Level 1 and 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\pararsid4018572 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid4018572 Hardware Requirements \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid4018572 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\f3\fs20\insrsid4018572 \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\pararsid4018572 { \f1\fs20\insrsid4018572 1 GHz Pentium-class processor or faster. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Minimum 256 MB of RAM. 512 MB of RAM is recommended. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}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\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}CD-ROM drive. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Keyboard and mouse or other pointing device. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}1024 x 768 resolution monitor is recommended. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Network cards and cabling for local network access. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Internet access (contact your local network administrator). \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Printer (optional) or an installed printer driver. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}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\pararsid4018572 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid4018572 Software Requirements \par }\pard\plain \s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid4018572 Each computer requires the following software: \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \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\ls2\adjustright\rin0\lin720\itap0\pararsid4018572 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid4018572 Microsoft\'ae Office Professional Plus 2010 Edition \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Microsoft\'ae Office Suite Service Pack 1 \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}Microsoft\'ae Windows\'ae XP Professional with Service Pack 2 \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid4018572 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid4018572 Course Objectives \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\fs20\insrsid4018572 Upon successful completion of this course, students will be able to: \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls3\adjustright\rin0\lin720\itap0\pararsid4018572 { \f1\fs20\insrsid4018572 build a PivotTable. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}analyze data using PivotTables. \par {\listtext\pard\plain\f3\fs20\insrsid4018572 \loch\af3\dbch\af0\hich\f3 \'b7\tab}present PivotTable data visually. \par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid4018572 \b\fs27\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f1\insrsid4018572 Course Content \par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\b\f1\fs20\insrsid4018572 Lesson 1: Building a PivotTable}{\b\f1\fs20\insrsid4018572 \par }{\f1\fs20\insrsid4018572 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid4018572 {\b\f1\fs20\insrsid4018572 Topic 1A: }{\f1\fs20\insrsid4018572 Insert a PivotTable \par }{\b\f1\fs20\insrsid4018572 Topic 1B: }{\f1\fs20\insrsid4018572 Create a PivotTable Based on External Data \par }{\b\f1\fs20\insrsid4018572 Topic 1C: }{\f1\fs20\insrsid4018572 Categorize PivotTable Data \par }{\b\f1\fs20\insrsid4018572 Topic 1D: }{\f1\fs20\insrsid4018572 Customize a PivotTable }{\f1\fs20\insrsid4018572 \par }{\f1\fs20\insrsid4018572 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 {\b\f1\fs20\insrsid4018572 Lesson 2: Analyzing Data Using PivotTables}{\b\f1\fs20\insrsid4018572 \par }{\f1\fs20\insrsid4018572 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid4018572 {\b\f1\fs20\insrsid4018572 Topic 2A: }{\f1\fs20\insrsid4018572 Create Custom Calculations in a PivotTable \par }{\b\f1\fs20\insrsid4018572 Topic 2B: }{\f1\fs20\insrsid4018572 Restructure a PivotTable }{\f1\fs20\insrsid4018572 \par }{\f1\fs20\insrsid4018572 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 {\b\f1\fs20\insrsid4018572 Lesson 3: Presenting PivotTable Data Visually}{\b\f1\fs20\insrsid4018572 \par }{\f1\fs20\insrsid4018572 \par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0\pararsid4018572 {\b\f1\fs20\insrsid4018572 Topic 3A: }{\f1\fs20\insrsid4018572 Format a PivotTable \par }{\b\f1\fs20\insrsid4018572 Topic 3B: }{\f1\fs20\insrsid4018572 Present a PivotTable in a PivotChart \par }{\b\f1\fs20\insrsid4018572 Topic 3C: }{\f1\fs20\insrsid4018572 Print PivotTables and PivotCharts }{\f1\fs20\insrsid4018572 \par }{\f1\fs20\insrsid4018572 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid4018572 {\b\f1\fs20\insrsid4018572 Appendix A: Solvers}{\f1\fs20\insrsid4018572 }{\f1\fs20\insrsid4018572 \par }{\f1\fs20\insrsid4018572 \par }{\b\f1\fs20\insrsid4018572 Appendix B: Goal Seek}{\f1\fs20\insrsid4018572 }{\f1\fs20\insrsid4018572 \par }{\f1\fs20\insrsid4018572 \par }{\b\f1\fs20\insrsid4018572 Appendix C: Troubleshooting PivotTables}{\insrsid4018572 \par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\insrsid10493117 \par }}