Excel 97 Module 3

For Excel 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

Skills you will learn:

Setting the default number of worksheets which should appear in a new workbook
Moving among multiple sheets in a workbook
Inserting and deleting sheets in a workbook
Moving sheets from one location to another in a workbook
Renaming sheets
Writing 3-D formulas that reference cells in other sheets
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
Using the File Conversion Wizard to convert batches of files to an Excel format
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