Advanced Excel 2000 2002 (XP) 2003 Training Manual Start Price USD 9.95 Current Price USD 9.95 Time Left - Bid Count 1 Buy It Now Price USD 9.95 Reserve Price - Start Time Sunday, September 07, 2008 End Time Friday, September 12, 2008 Location East Lansing, MI See more about 'Advanced Excel 2000 2002 (XP) 2003 Training Manual' Description This is the training manual that where everyone can learn.  You can easily learn Excel with step by step instructions.  This is copyrighted material and can only be used for personal use and cannot be copied or modified or sold.   Excel Advanced Spreadsheet Analysis and Management   Excel has many powerful and useful features that can help you get the most out of the information you create and store with your spreadsheets. The Macro feature automates your workbooks.  Pivot Table Reports and Charts summarize or cross-tabulate large amounts of data in interactive tables or charts.  They can be changed quickly so you can summarize different sets of data. Databases allow you to sort find and filter spreadsheets designed as lists, work with data from external databases, and write formulas with database criteria.  Lookup functions are formulas used to locate values in tables. Data Validation builds checks and restrictions into spreadsheets to reduce errors in data entry and track errors more easily when they occur.    Part I Macros §         Understanding Macros §         Creating Macros §         Playing the Macro §         Relative Cell References in Macros §         Viewing Macro Code §         Creating Macro Tools   Part III  Database Features §         Understanding Databases §         Creating Databases §         Using the Data Form §         Sorting §         Filtering Databases §         Creating Advanced Filters §         Database Functions §         Using Data from External Sources §         Opening Database Files §         Importing External Data   Part II Pivot Tables §         Understanding PivotTable Reports §         Creating PivotTables §         Creating a PivotTable from Multiple Worksheets §         Changing the Summary Function §         Extracting Source Data with Drilldown §         Formatting Pivot Tables §         PivotChart Reports)   Part IV Lookups §         Lookup and Reference Functions §         HLOOKUP and VLOOKUP Functions §         The LOOKUP Function   Part V Data Validation §         Restricting data entry with validation §         Setting validation criteria §         Setting input messages and error alerts §         Tracking errors with data validation Place a Bid!