A hands-on course in Excel 2000 for spreadsheet users who know the concepts covered in Modules 1 & 2 and wish to learn more. Explains how to use multiple sheets to more efficiently organize complex data. Shows how to work with database records, including data validation, sorting and filtering records, creating subtotals, using the Database function, consolidating data, creating and using Pivot Tables, importing CSV files, using the Text Import Wizard, importing Lotus and dBase files, using the File Conversion Wizard, exporting Access data via e-mail, exporting Access data via the Save As/Export and Office Links commands, and importing Access data via MS Query. Data disk included.

Concepts you will master:

• 3-D spreadsheeting
• Sheet tabs
• Templates
• Paste Special
• Fields & Records
• Database
• Data validation
• Sorting & Filtering
• Criteria range
• Logical operators
• Data form
• Database functions
• Consolidation by position
• Consolidation by category
• Links
• Outlining
• Pivot table
• Page filter
• Data cache
• Structured selection
• Base field
• Delimiters
• CSV
• Tables
• Query
  

• Setting the default number of worksheets
• Moving among multiple sheets
• Inserting and deleting sheets
• Moving sheets from one location to another in a workbook
• Renaming sheets
• Writing 3-D formulas
• Simultaneously deleting the contents of cells in more than one sheet
• Protecting cells from unauthorized changes
• Saving a workbook as a template
• Opening a workbook based on a template
• Deleting a template
• Using the Paste Special command to combine values from several worksheets
• Simultaneously filling multiple worksheets with the same data
• Creating a set of validation rules and responses for entering database records
• Entering and sorting a set of database records in Excel
• Using AutoFilter to filter a set of records
• Copying filtered records to a new location
• Creating a Criteria Range for more complex filters
• Using logical operators to filter numeric fields
• Displaying records using the Data Form
• Creating subtotals
  Using database functions to filter records
• Consolidating data from multiple worksheets to a summary worksheet
• Creating a template
• Working with the Outline function
• Creating a Pivot Table based on an existing Excel worksheet
• Changing the orientation of fields in a Pivot Table
• Creating a Page filter to view field data one item at a time
• Modifying the source data and updating a Pivot Table
• Changing the style of a Pivot Table
• Creating charts based on Pivot Table data
• Creating a second Pivot Table based on the first
• Importing CSV text files into Excel
• Using the Text Import Wizard to import text files
• Importing Lotus and dBase files into Excel
• Exporting Access data to Excel via e-mail
• Exporting Access data to Excel via the Save As/Export command
• Exporting Access data to Excel via the Office Links command
• Using MS Query to select records from Access tables