Office Specialist Beg Word Expert Word Beg Excel Expert Excel PowerPoint Outlook Access Vista Using Advanced Features: Use advanced text alignment Create and modify styles Use Style for a TOC Use Find and Replace Format first page differently than subsequent pages Use advanced text alignment features with graphics Advanced Layout Create a Drop Down Box Form Field Options Format -> Picture -> Layout Use the Show/Hide option Using Advanced Features Developers Toolbar Create watermarks Format -> Picture -> Picture -> Washout Expert Microsoft Word Microsoft Office Specialist (MOS) and Microsoft Certified Application Specialist (MCAS) reference topics Using Mail Merge: Merge main document and data source Set up a main document Create a data source Select Recipients Adding merge fields to a document Merge to a new document Create an envelope Use a spreadsheet for the data Edit Recipients Add Merge Fields Merge Excel data into an envelope Managing Files: Save as Web Page File -> Save As Web Page Workgroup Collaboration Protect documents
Using Advanced Features:
Use advanced text alignment
Create and modify styles
Use Style for a TOC
Use Find and Replace
Format first page differently than subsequent pages
Use advanced text alignment features with graphics
Advanced Layout
Create a Drop Down Box
Form Field Options
Format -> Picture -> Layout
Use the Show/Hide option
Using Advanced Features
Developers Toolbar
Create watermarks
Format -> Picture -> Picture -> Washout
Microsoft Office Specialist (MOS) and Microsoft Certified Application Specialist (MCAS) reference topics
Using Mail Merge: Merge main document and data source
Set up a main document
Create a data source
Select Recipients
Adding merge fields to a document
Merge to a new document
Create an envelope
Use a spreadsheet for the data
Edit Recipients
Add Merge Fields
Merge Excel data into an envelope
Managing Files: Save as Web Page
File -> Save As Web Page
Workgroup Collaboration
Protect documents