Chapter 1 - Outlining and Grouping Data
Chapter 2 - Consolidating Data
Chapter 3 - Working with Lists
Chapter 4 - Importing/Exporting Data
ViaLab Exercises
Chapter 1 - Outlining and Grouping Data
 Opening Excel
Use Grouping and Outlines
Outlining an Entire Worksheet
Expanding/Collapsing an Outline
Print Previewing a Worksheet
Change Page Orientation
Set Print Titles and Options
Using Page Break Preview
Insert and Remove a Page Break
Removing an Outline
Chapter 2 - Consolidating Data
Opening Multiple Workbooks
Arranging Workbook Windows
Creating/Saving a Workspace
Using a Workspace
Consolidating Data
Creating a Link to Source Data
Using 3D References
Chapter 3 - Working with Lists
Example of a Database Record
Setting up a List in Excel
Opening/Viewing List Data
Use Data Forms
Adding a New Record to a List
Finding Records Using a Data Form
Wildcard Characters
Performing Sorts
Apply Data Filters
Filtering Data Criteria
Using Top 10 Auto Filter
Using Advanced Filtering
Using Subtotaling
Chapter 4 - Importing/Exporting Data
Export to Other Applications
Import from Text Files (Insert)
Import from Text Files (D&D)
Adjust the Decimal Place
Query a Database
Importing a Table
ViaLab Exercises
Adding an Outline to the entire Worksheet
Arrange Workbook Windows
Change the Page Orientation
Open the Data List File
|
|
