Lesson 1 - Using Mail Merge
Working with Mail Merge
Starting the Mail Merge Wizard
Identifying the Main Document
Creating a Data Source
Adding Fields to a Data Source
Removing Fields from a Data Source
Rearranging Fields in a Data Source
Saving a Data Source
Entering Records into a Data Source
Setting View Options for Merging
Inserting Merge Fields into a Document
Previewing Merged Data
Merging to a New Document
Sorting Records to be Merged
Merging to the Printer
Lesson 2 - Merging Mailing Labels and Directories
Using Mailing Labels
Creating Mailing Labels
Selecting Label Options
Attaching a Data Source
Inserting Label Merge Fields
Merging Labels to a New Document
Creating a Directory
Merging with an Outlook Data Source
Workshop Information Page |
Lesson 3 - Sorting Table Data
Designing a Table to be Sorted
Sorting a Table Alphabetically
Sorting a Table Numerically
Sorting a Table by Date
Sorting a Table by Multiple Columns
Lesson 4 - Using Formulas in Tables
Creating a Formula in a Table Cell
Using a Function in a Table Cell
Formatting the Result of a Formula
Displaying Field Codes
Recalculating Formulas in a Table
Lesson 5 - Importing Excel Worksheets
Importing an Excel Worksheet
Linking an Excel Worksheet
Creating an Excel Worksheet Object
Editing an Excel Worksheet Object
Inserting an Excel Worksheet Object
Lesson 6 - Working With Lists
Customizing Numbered/Bulleted Lists
Resetting Bullet/Number Styles
Bulleting/Numbering a Multilevel List
Using List Styles
Sorting a List Alphabetically |
