Microsoft Excel 2003
Introduction Introduction to Excel Navigating Worksheets Selecting Ranges Creating Workbooks Entering and Editing Data Saving and Closing Workbooks Modifying Worksheets Opening Existing Workbooks Copying and Moving Data Deleting Worksheet Data Saving Existing Workbooks Formatting Worksheets Inserting and Deleting Cells Inserting and Deleting Rows and Columns Adjusting Column Widths and Row Heights Hiding and Unhiding Rows and Columns Printing Worksheets Checking Spelling Previewing Worksheets Previewing Page Breaks Working with Formulas Creating Formulas Editing Formulas Working with Basic Functions Using the AutoSum Feature Using the AVERAGE Function Using the MAX and MIN Functions Using the Function Wizard Enhancing Worksheets Changing Fonts and Text Merging and Splitting Cells Rotating and IndentingText Adding and Modifying Borders Adding Background Shading Working with Graphics and Diagrams Using Templates, Styles, and AutoFormats Creating Workbooks from Templates Using Styles Adding Worksheet Backgrounds Applying AutoFormats Finding and Replacing Data Finding Existing Workbooks Finding and Replacing Text Finding and Replacing Data Finding and Replacing Cell Formats Using the Research Tool	Intermediate         Working with Multiple Worksheets         Renaming and Coloring Worksheet Tabs         Consolidating Data from Multiple          Worksheets         Adjusting the Screen Display         Working with Multiple Workbooks         Splitting and Freezing Worksheet Panes         Displaying and Hiding Toolbars         Working with Advanced Functions         The Function Wizard         Using the NOWand DATE Functions         Using the HLOOKUP and VLOOKUP          Functions         Using the IF Function         Using the PMT Function         Using Advanced Print Options         Controlling Page Appearance         Adjusting Page Scaling and Orientation         Changing Margin Widths         Creating Headers and Footers         Inserting Page Breaks         Setting Print Areas         Printing Repeating Rows and Columns         Printing Multiple Worksheets         Printing Entire Workbooks         Filtering Data and Using Comments         Filtering Data         Working with Comments         Naming Worksheet Ranges and Formulas         Changing Chart Types         Editing Chart Data         Printing Charts Protecting Data Protecting Workbooks and Worksheets Protecting Cells and Ranges Hiding Data Assigning Passwords to Workbooks Using Basic Integration and Web Features Importing Data from Text Files Creating and Modifying Hyperlinks Exporting Excel Data to Microsoft Word Publishing Worksheets and Workbooks to the Web	Advanced Working with Databases Validating Data Modifying and Finding Records Creating and Modifying List Ranges Sorting Database Data Sorting Records up to Three Fields Rearranging Fields Sorting Records by Four or More Fields Applying Custom Sort Orders Sorting Text as Numbers Using Database Functions Using the DAVERAGE Function Using the DCOUNT Function Using the DSUM Function Using the DMIN Function Using the DMAX Function Using the DGET Function Using Advanced Filters and Automatic Subtotals Filtering, Extracting and Subtotaling Data Using the Advanced Filter Feature Extracting Data Using the Automatic Subtotals Feature Creating PivotTables and PivotCharts Creating PivotTables Modifying PivotTables Changing PivotTable Field Names and Functions Extracting Data from PivotTables Creating PivotCharts Formatting and Adjusting PivotTable Formatting Numbers in PivotTables Displaying and Hiding PivotTable Data Refreshing PivotTable Data Sorting PivotTable Data Using the PivotTable AutoFormat Feature Auditing Worksheets and Performing What-If Analyses Auditing and What-If Analyses Auditing Worksheets Using the Goal Seek Feature Using the Solver Feature Projecting Values Working with Scenarios Creating and Showing Scenarios Merging Scenarios Summarizing Scenarios Editing and Deleting Scenarios Protecting Scenarios
Computer Training of America Telephone: 413.283.7740 Toll Free: 877.283.7740 Fax: 413.283.7730 www.computertrainingofamerica.com