MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_01C9904A.6200A980" This document is a Single File Web Page, also known as a Web Archive file. If you are seeing this message, your browser or editor doesn't support Web Archive files. Please download a browser that supports Web Archive, such as Microsoft Internet Explorer. ------=_NextPart_01C9904A.6200A980 Content-Location: file:///C:/E31C90F6/Exc2007Adv.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" EXCEL 2003

EXCEL 2007

ADVANCED

 

Course Length= :        &= nbsp;            1 day or two half-day sessions

 

Who should at= tend:        &= nbsp;      The Excel user who is proficient with basic formulas and functions, and is read= y to use more advanced analysis tools.

 

Suggested Background:      &nbs= p; Excel Introduction and Intermediate courses or
extensive experience working with Excel.

 

If you are re= ady to apply extensive analysis tools to your workbook, this course is for you!  You will learn to use complex anal= ysis tools.  You will learn how to = eliminate tedious and time-consuming tasks by automating these tasks with your own cu= stom macros.  You will also learn h= ow to use a spreadsheet to build a database that stores information for selective retrieval.

 

Upon completion of this course, you will be able to:=

            = Use Functions

        &= nbsp;           &nbs= p;   Use the Function wizard

        &= nbsp;           &nbs= p;   Use the ROUND and PMT functions

        &= nbsp;           &nbs= p;   Use the IF and SUMIF functions

        &= nbsp;           &nbs= p;   Create a Table Lookup

            = Work with Templates

        &= nbsp;           &nbs= p;   Create, save and edit a template

        &= nbsp;           &nbs= p;   Use data validation

            = Create Macros

   &n= bsp;            = ;        Create, edit = and run a macro

        &= nbsp;           &nbs= p;   Assign a macro to a button

        &= nbsp;           &nbs= p;   Copy macros between workbooks

            = Get Started with a Database / Table

        &= nbsp;           &nbs= p;   Plan and create a table

        &= nbsp;           &nbs= p;   Add and delete records

            = Organize and Find Information

        &= nbsp;           &nbs= p;   Sort your records

        &= nbsp;           &nbs= p;   Find and edit records

        &= nbsp;           &nbs= p;   Work with criteria

        &= nbsp;           &nbs= p;   Use AutoFilter

        &= nbsp;           &nbs= p;   Use advanced filters

        &= nbsp;           &nbs= p;   Use PivotTables

            = Import and Export Data from Other Applications

            = Use Workgroup Functions

------=_NextPart_01C9904A.6200A980 Content-Location: file:///C:/E31C90F6/Exc2007Adv_files/header.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"

------=_NextPart_01C9904A.6200A980 Content-Location: file:///C:/E31C90F6/Exc2007Adv_files/image001.png Content-Transfer-Encoding: base64 Content-Type: image/png iVBORw0KGgoAAAANSUhEUgAAAZEAAAC+CAMAAADDcsIyAAADAFBMVEUAAAAQEBAhISEpAGsxMTFC QkJSUlJjY2Nzc3OEhISUlJSlpaW1tbXGxsbW1tbn5+f///////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////////////////// //////////////8lDxiNAAAAAWJLR0QAiAUdSAAAAAxjbVBQSkNtcDA3MTIAAAADSABzvAAAFpVJ REFUeF7tXdli3CoMbXqbpNnz/197EVqQWIzAOHGmzlM7I0DocCQQy/z6vP7OZYFf51JHtPmv8RcF Wl8Wnx/SOW/rk41fiAwb7h9DpNfdMY5IbcNmLwr0FCu/n2zzTBzxdHoSEah60kJDblJ3YbK970Tk l/rzoCFm9QqvGbezrV2IeCw3YyVPvTWZmbZCmS/niCaG/Nvf6R1eixoZNJRftVxysCEW/zpEalCg FiOdHi6wy3ONaLZq6v0liBgwsqEz2OkFiPiD/KBumfhJOaLBqKk42uk1iLhAGVXth3itC5FRqhzp tRIaLa3Gh+EyjvSXJ+PK2RKjUJD8UYgIGqLX+1uh4kSf1yHSg2RCufMiwnAwBO/vH5+fb+85IjN9 XojI9ip+Rrmfg8jbR0Cj5MhMpy9Exp1hRpDnl5fXt7f39xyRGTh4ijRZdmBpsqKFcdPFEqvjCOJB yjz+/fv0hIh8fILnSn+zXV7KkabfmtXOlDsBIpodv//c3z8QIi+RI+C5+G++x4sRaWAyr58qeWpE 3t8sR+Z7fCHiBloT5NfdHXHk8SnEEeZImv6eCJHaJHhePV3SbToruCqOmPjxKYjEOPLyhhwRRHb0 eDlHan5rh34n8VrEj4R1DZGwItkfRnBEr7EY11KO5TX1fydHuohAZL8Q8UG0wmvpCS+2mscR8FoJ kT1D8ACOlH5rj4KprA+AQmo3IgU/sAk7+yVEXva7nEMQyaP7D0akAUeBCHqt99cLkT5x9nHEiwhx 5EKkD8i+LEoZQFKLv//8CYv2xzD9DSuStzcIJJEjOz3CMV7LuK2dGkpxh/VrIvMc4RWIzo6oFn4W Ijq6/1REmB8fNoOYMEGOhEX7E6QagSMfr0/Pe7t7EEduABEEJMSHd4YkR6bitd5OjEhyXHsHTXvl 6fJjs14LEQlzKIAktpR7rxoiz097u3sYR344IhRD3sO+h3AkHwAlIh9ve/Eg57K/mkoNov+q2l2M KIWmOIL8gF0P8FpCDrMlFZrK48jeeRaY6niOrAKkd7KiBdg4IsSPAEhI6WIgocrzow357PfciLAF fy4isFcbWKK8Vo0jej1yIeJxZMMcoVkvUAS8VkAkcSQnSbZCXDH6jvNaP5UjCMjr6xusMTKv9RE+ MKMgW4/MIlKMrNmKeuVG4fYM+WGZMY7QOZPX8IckwckWtfoRfJhV4CEcfngK24gg3jPH1vQn65an qlHryrTB61uHTe0sMIlIyFRFkuBkiyN7IEkDkSDvMWMm0+qDp6p/AxGhSMyLvL3mXisAlLkt4gjI e8yoZLZGlKeqmeUFlvHUzvNw57gfERvhCAISTsRFr0WBJPNaFhLwWn8h+TuMyGYfPDZLFXikUeaH IUIECUdLAJIYRrIlYjhtkpPkcyqO9IaUx8a6Do98gsQr3dNy8ns/RwSR59dXCNXEERXaQ2QPrswq gogMcqTXF4/Nbh+RCEjIrMe/SBJcIurEVuTIq8FEOOKxIsn0AHF5elOJt/GROHJUKPFyBNchzyEk PL8ARdBvZYkt4EiGyGeMI68v/sDexcMXe201TkgGEZlNXW12cQSRQBE4MxooEhcYyBGd2AoceX8L 3+kWeT3itImrk5668l57ygwv2x2jZ1jEhwjGkADIc6BIhAS2zjGNoidb6LVen7UacYXo54inBx7r fgkiR3iuIUSQIzCZtWkUWSLG0B7snyMSIrvHimkGuo2Lp67bRiRSJIz1Z4nsMHmKV6dwF5G6T5G9 wpFXjxG9gIxHdtDPowHD6JFlGQ+pR2Q8HEGfFRGJkd1wxCR/Yf4bPNrL81PSAZeI3j66dPdUVlQ0 UsgjKzIulf1CfURoHRIACcdKMLJLHClSjR8xu/ISsFMqwILE10en3p7KphCReYWnhSTjVNsnNoYI eK3EEXRbJo3yEThyIeIzfUOqi4iiCHgtXCKG6E1pFBNHQkiBFQlIKLf16fZa3p54RnBZ10gpj6yS 8SrukfMg8gnLvKcQDtBtyVwrcUQOCAWvFTgCQgYSp9fyKDwapFOdHiuPSR/it3qIIEUAEYzszBEi Cc21eLaFHIHY/qQR8Ub2MyHimpsdQRM3IoBJXCJSXgtXJBBH1AGhkP2FJeItcOSkiFAQ+UscwQUJ eK2YRsFtXZ1rFI4EQc2SU3gtz5JEsdTj5IyMl+EduW2ORJcVfBbGEVqQ4HpEOKJnW3GHJHwVYIMS 0vZPRGSUJK6MnAO1TUQSRTiQUGQPkFBii/0WNqXiSCCJQsR3Jt6hbxTxDN9aXf1ytlRf3kp49d+U 8yISI7tKo3Biyx6iw11EWECC1/rhHPEhrzE5HBGkSLgnZb0WLhHxNAqk41VmizgSQjsEkr8Jkulh Xe2kZ+zOcSS7t+tpaDUkWxyJQSRcygmAxK1AnUbhyG53SOISMcaRMC8Lxdgsvp65h5inuiWIuAbS YkjaiGBUD4A8BjxoichzrcgRfYiOsr9hIgwzsJhrBI48PqJhPCYceNjdU90aRLyqL1wruhBBt1Vw RG3s0sk5TKMEuGAteSHiJr0WbCJC86zIkfhHkR13EXGupY6jYJ3EEVwigrN7fPjXOLJ7EryFyOdn OAEX/h4SRySNgnMtldmKlsc4QmmUQJLHB0TER373kPpKr+X0uOvcVguRSJEHRCSG9jzVqFbt5p4V xREIJMARIomvX15IvhQRn+rrMlxtRIAhgAhcAlFplHQaBWM751HImrixGzxbDO03gYiP4MtmXH1E KJDELIpOx/MBIX2DOvgtmA7HDZILES/lrVwdEZz5Ikdo+msX7ZBqlDxKdmQrHhCCyA5x5PHh/t4b R9xB8Wu9ljMKriJJG5HwFim7rXLRHlONnI+H7G86IAS5xpfXMAUImIDXuo+QeIx4MCIuFRo6+Mou Ce9VRCJFBBGa/toFCcyAOR9f50gM7YElN4GIc0gJJHMOK5ZyIkJZFNkgUQeE7JGtcPEND9GB6IXI BDIeROJ6JESFtEGCm1aca9RHtuAuIhz9pUX7X3B893+8Q8zZAY8PKauaK5Xq8ZRf4LdqiMSwHpxN DCSyaE9eC4/+Nm+Hxo3dxJGbQcQ7rBAV5+AqxbyIgNsKp1EgYMuKRN8OlXcf9A5J9FqAyJ8/3gHm 6oinsqIiT6GeHV11HI8I3CVUqUbeaqc9K7tBwruIuEMSE1sXIq5RJkIlR3AtAk5LvFaCRHOEco32 nlXaaQ+zX4DkphDxTeL3kcSJSPyVBDqxxdnftLFrE1txspV2SJAjv72E9wwoT115PZ4yfe/vq2VX ICkQQYp8hh+rEI6g28I0imy1x6tv+oAQmYBuLOC+btjserwPK5IBRHquHJrx2OUYRHxt7yKJBxGd apQbCzjXytPxKrHFu4iBIxciHuaTTB2R4GZsHIleK+Ua6S6icEQ/e4bJX9hGhDgSEltnQMTDKueU 1VlV3wM2UOoiEvPxabKVjjUqjmR3EfHwA0X2YUQchvEYxfbXU8LRsNdl7gkkOSIxigSKCEdkiQjZ dXWssZX8xXR8XLRTGgU54g7tjuWVx74GEU8BR7tY59LKSqJ4EcHjKGqHBBftlbuIcBwlcYSnv2OI dIarxya6qx5597BeWlnFc7kQwcSWrNrp5ls6jJ3ds+I4opeIFyLe4L6JiE1s0XEUffSXQ7t5ZAvv kOAGSVoiDnmtjgfxDFMxgEeYZTxWc9fnqazLEVyMhCffMY4oRJLXkocfaPZb3kXEVCOsEUMpXrT/ vrtz90UJVrvlqWjI5XsR8TTcU74HlOVIHREI7uK11GQrbuvKs2fp5ls8IBTykbjVTmmUSURyG7gN 7Y/AqQl35U5kesavfu9BJB0QwjV7Sv5qr0U33+h2KOVRdnPkQiT4rN+l18Kzv5LZkptv6rHG9Hx8 vB0KTksOCMXE1t2c28ogcQ/j2+BIdFqEiE1spcwWbpDETcT4XE3yWnIaGyN7PGjKx1HufwAi5EOc Hskjtt9rtRCROGJSjeq5GrwfigrgrZ54Y4GPbIU5Qlgi/r775enGtsyBHFmNyBQe2cmHTURwFzE9 jpJuh9p7VnQ8Hvas+KDphcgAOiayx6lv7rXCVrs9aMqRXRbtdhuROMI7JHRk6/wcYaPt5zHVMICC FtWI4GKEIeH1SHH4IT2Oom+HytPY9BIH3rPC7C9zJFS/t7+HeS0xyl4NpfwiRO5aiMg9Kz76kJ49 izffijiS9qxiPj7UCyru7e+FiD5oqjYRu7dDYYJs9qwuRJycyb2W5Uh2ZIvuWfEjW/wOs82jpFs9 dodkzVTmII4oa+1l8VKvFfRqIyJLRPg9PXxACG6QpMfK7e1QXJDgYWzwWov89L+ECOa0wq9G60U7 5xrV4QfYijKPbKU1YjQX3Q6NbgsmzIhIGoT7xuAxiGiHsk+/LEnm9FT1udYmIurwA2TZ7SNb9p4V 3w6VNAqkGi9E3NikONJDhA4/AEWYI3IX0f5SJd4OlTSK3EUEpeB+455R+K9xJGQDxWvp4yi0ROTD KMIR3tiN7zCn3+rB5zNTGkXGB17JPh0iZvzu0U6XdZMiE7QcaSGSJbb07dD0fLw8+ysP0XEahduk O/J7IDmEI6dFBOJ6jSN0HEUSW+mxxuYvjMXjKLho55c40GO5LdoYqu7yfipmY3QRR2Ypou5YgbWa iNBcqzhnKi8I6aex4wGheDsUDghdiIyBI14rjl9GJG1a0e1QmmulJSLf6pEH/SvHGvHwQ+6yYOdr fhz+EI6MgWCkRxDJn3SSF4QaP3qBB02pOXZZccrmfCWwAtx6RHLjzY+WvWceUBODyK+SI7JEzE5s JY7ERbtONeKeFfzoBXBEUQT+GX9qDFY0kx1fjkgxmicVM8V2UMSNiL1nBetxeUEoPcVBiuCeFR3G riPyfCHSQs3LEXqIDjcR1bO/mNmyz8cLR8BtidPCfwhH5n6z0v9r4L65VsUsCziyhyKKI+DCwGtl ma1aOh4OCNU4QtdD+bVG2LNKFIF/hVwyJizDT1sFak10fq3XqpluQqm8yFcgwu+e0Vlsfqxcbeyq 33zjF01hz0oQgX+E8y0BkfAwVEQkZCjHe78UkarlxnXKSuzCQ0f2TY7o52rIa2E+np7iwN/X3eJI QoQ4As5uvPf/NiKNu4jxUjvn4+nGAj1WzqGd5lrye1bpcmNcarLXCjCOYrIQkcZYHtVoqcsCWmi3 EgxnVu3FDWp80im7Z0WzX/V7VrRof1GIQDO/o9cKfzD7hQ1It3mzXQeP0XqRvelbPJVvyOz0WQmR mHFqIZIltvB2qNxFxIeYzeMoeBdRECGKMCLIkfBH2o/YwA3iNiIbdhvRZjU/QC3mSA8RndgyL9FJ GsX+LiKmGqnjNUTgjOqFSGVktBCR09gmsQVBGV9H4XtW8lijvmfFqUbxiJgzixwBvsVdyOC2+PuB YbmEI5ueZUCZIyjS5EgDkfIuYvt3EV/k11wj7AmR6LUCJMkwfissQKTj6f26WMndAYQdijgWG0eK Gwt0F5EfYk4c4Zfo7G++xduhum5CBEI7JrY0IiDos8RORBxm8+mxdg2i1ep6LX0X0d4hoWfPVBpF Hmuk09gbiDybX3r1u68diDjQ8I+MZYnFQqshROQlOp3Y0r+eRNXzcZQGIhBHLkRaAyQhAhsY19+3 W0BF9m/X5VIg7updHDnZQLgQORkg6zmCZ4C2/zwyvTpu9vu1HOHpw5a5PDI3a25HxyqI7DCZp6hH xqH4zYpciJwN2rWI0MStF0WAJmczxGn0WYwI5Hj7ffPI9Gu5UYk+Isrvm7GtkgBimyxG2DwBSXlk MtE2yJKmwSPerIhuWANnFFJfyOeVz+JHWmmTGlKDq1JJXY+qWZINyxViw2SkV2F97YE81vbIXIgY v55BaP8bh2H2USptrJ1L1TjSkKm1UXVSHuVqxBFClV3hUV/tS6X35Ud1E1UJbAyPim54LVQpN3+j OWyvQm7TZa9MBfN67CkQqVmYul1FfwUilYpH1dDekjufPutxRH/fQGELNoVaVe+8bNaEpUqOSMMS MF6KrzoNuTlSq7ipR/lFzv0JjlyIWN5/HSKZ32c/KArk/nmDL5qINY5ol5d7Nj288/GkBj45Yao9 Y4RxqSDi6FufI1kl2vNU1bAqKjVMt/yz37wXUk3FxMqqRo3M2qbTCjX7+ZbbyiRrzqLljrUn6/VF AHYOlxE9BrxWYwgMcmQGEWOAihFKIxd8zW2SkwJ5sgV9lyNFmxW1ah5Nk75ClO04UrWGVrUfU74J kTySV1xKAUnqjO63MWrNIAWsGurykb8cSPY98rl28cZ6DN+mC7kQqRBtOSJqeG1ypOIYKvSZ4oi4 k6yN3Oe23U5ZsPTtufuY5IhRtuIdVcO1xbWDI1bRstPVaku/TIrMIdJoo49IvWDVC8XKSpzKiZhF qm+QrXqr48J0q7GHqJSouclqV7JIuRORthG1/lXl6sSqULoyoGuVZ410DVLnSRESYj3FGGvts1+I VAZdZunMmBmTCvrtRKSE7js/aYzKbZVGN2Eqw1WMuKfzzXobla49+bBH8+aQKwbfwlZOWNUPQuSE 1jtCpQuRI6y6p84LkT3WO6LsaRHRK4UjOn7aOs+LyGlNdrBiFyIHG3i4+guRYZMdXOBC5GADD1df nDWppd6uz77SAtXs51cqcLWVZ0Yvi5zMAhdHdgESrrX3yndFMoELkZ5FN7+nhwa2ZKJIVyCJXIis QGTL5vw6RLOdTOBC5EJklwXOVjh7HK+mnpsj5LiO4Ui2AWoUhe/qhpVvmhKjgEQ9RgvB7qO3zAAi zViS1SFtTypfNTYvVKv9QiPVOj2OyKa99XLZa2GUm0Gkb/CWDuoZotg4y12IJIudCBEcc1qhxF8H /3mQy+isDYsv5UjsjUNzq+gxiLTmwFscAe0NIroz/X5pQNASZBDqL2ORvFaq3zg6aSr7XuyL0nKa Wrs7Q3puuFEQLV8iJopTZW1M9cNnDa+UGbyUyurIO0D9NDph95OB2dC1stxFZTMpnv6BPEwo8L9o cBIi5ff2yA8jkrVl8KdGsrNC0pnW/V51G5G0qNt7MSLRetwSjYMLEXISDDOPm+9HhMewaEQ8Yb4o Jusxajmixn76Z2SA5oj+KnY844hmkK1G6aQ4h6PMVEK+SViHXxollMkNgWOZhkfSz31Oi2zGEU1u jomsj+699Ax7Ln+oFXfBIEU4pM9yR6Iceg0R1RIam/Sh1rheaTz9o+EiBRGlMVlVAp3uZ9Xi3SCh 3mh1QibokxmL8Sv6knZsGeoQ21EskiPCEHUQ0UiixUustdUNIiKruJFDY6cT2EIJIw8pmnCmPjfM efQKUQ0bPewRrAuRCiqHI8K2zzxW/FgwUiMrjewtjgj3FcyMcaqWhqWQI3P92RCpc4QGPo/0xLQ8 ZujOcGeTwbXX0t6vhGQAkZbTUrEoihivFfVUhI3uQylv/s0WFHuHb8UUhddJBs3aMGiz1igjzZnR gJ/XEEHjYVFVmutqVciDSQrGjrAC2LYKcsay3TRiiiNdREggRwS7QsprRIp/pzGdutRCRMUENFtq Q7qbDCIOHismc9B/SLcmIliAe8cV2AY12qnaBiIICSmSmxURaRobvnAJqDqS9pvVTn6pO9meQk5W Xi9mEOnWrKTHClLN/U3dT8e2r1HzQoQtcCHSHb/jAm3v0qrLcmS8xQNK3BRHWt6+bbcpYhwAg6ry phCBIDxmrguRMXsNS1+IDJvsKtC1wP82VUyYcyqRHQAAAABJRU5ErkJggk== ------=_NextPart_01C9904A.6200A980 Content-Location: file:///C:/E31C90F6/Exc2007Adv_files/filelist.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C9904A.6200A980--