Managing Lists and Working with Data
- Introduction to Excel 2000 Volume III
- Introduction to Segment 1
- Launching Excel 2000 and Retrieving a File
- How a List is Organized
- Applying Conditional Formatting
- Working with Named Ranges
- Using a Named Ranged in a Formula
- Interactive Exercise #1
- Interactive Exercise #1 Result
- Examing Named Ranges
- Applying a Fraction Format to a Named Range
- Deleting a Range Name
- Sorting Data
- Creating a Multi-Level Sort
- Examining a Custom View
- Interactive Exercise #2
- Interactive Exercise #2 Result
- Saving a Custom View
- Using a Data Form to Manage a List
- Viewing and Adding Records with a Data Form
- Finding Records Using a Data Form
- Using Filters
- Creating an Advanced Filter and Extracting Data
- Interactive Exercise #3
- Interactive Exercise #3 Result
- Summarizing Information in a List
- Using Grouping and Outlining
- Saving Changes and Exiting the Program
- Additional Exercise
Working with External Data
- Introduction to Segment 2
- Retrieving a Workbook
- Opening a Text File
- Moving a Named Range
- Inserting a Row in a Named Range
- Using "Vlookup" to look up a Range of Values
- Entering "Vlookup" Arguments
- "Querying" an External Database
- Using the Query Wizard to Define a Query
- Filtering the Query Data
- Sorting the Query Data
- Saving a Query
- Viewing the ResultsManaging Lists and Working with Data
- Introduction to Excel 2000 Volume III
- Introduction to Segment 1
- Launching Excel 2000 and Retri...all »Managing Lists and Working with Data
- Introduction to Excel 2000 Volume III
- Introduction to Segment 1
- Launching Excel 2000 and Retrieving a File
- How a List is Organized
- Applying Conditional Formatting
- Working with Named Ranges
- Using a Named Ranged in a Formula
- Interactive Exercise #1
- Interactive Exercise #1 Result
- Examing Named Ranges
- Applying a Fraction Format to a Named Range
- Deleting a Range Name
- Sorting Data
- Creating a Multi-Level Sort
- Examining a Custom View
- Interactive Exercise #2
- Interactive Exercise #2 Result
- Saving a Custom View
- Using a Data Form to Manage a List
- Viewing and Adding Records with a Data Form
- Finding Records Using a Data Form
- Using Filters
- Creating an Advanced Filter and Extracting Data
- Interactive Exercise #3
- Interactive Exercise #3 Result
- Summarizing Information in a List
- Using Grouping and Outlining
- Saving Changes and Exiting the Program
- Additional Exercise
Working with External Data
- Introduction to Segment 2
- Retrieving a Workbook
- Opening a Text File
- Moving a Named Range
- Inserting a Row in a Named Range
- Using "Vlookup" to look up a Range of Values
- Entering "Vlookup" Arguments
- "Querying" an External Database
- Using the Query Wizard to Define a Query
- Filtering the Query Data
- Sorting the Query Data
- Saving a Query
- Viewing the Results«
Download is starting. Save file to your computer. If the download does not start automatically, right-click this link and choose "Save As". How to get videos onto the iPod or PSP.
