OPTIONS FOR PREPARING TO TEST

1. Self Assessments: Determine your individual understanding of the objectives covered in each respective exam. Use these assessments as a tool to focus your training and preparation on subject areas where you might need improvement. Self Assessments include: Go to Sample Page

Click on Picture to view the textbook site.

Going over exercises in a text book. I recommend the "Shelly Cashman Series" text books. They are primarily for a visual learner, but I recommend them for everyone because you will learn various tasks using a step-by-step process. When preparing concentrate on the following objectives. After passing the following tests, you will be considered a Microsoft Master! «Get College Credit Through Certification

Word Insert, modify, and move text and symbols Apply and modify text formats Correct spelling and grammar usage Apply font and text effects Enter and format Date and Time Apply character styles Creating and Modifying Paragraphs Set and modify tabs Apply bullet, outline, and numbering format to paragraphs Create and modify a header and footer Apply and modify column settings Modify document layout and Page Setup options Create and modify tables Preview and Print documents, envelopes, and labels Manage files and folders for documents Create documents using templates Save documents using different names and file formats Insert images and graphics Create and modify diagrams and charts Workgroup Collaboration Compare and Merge documents Insert, view and edit comments Convert documents into Web pages	Excel Working with Cells and Cell Data Insert, delete and move cells Enter and edit cell data including text, numbers, and formulas Check spelling Find and replace cell data and formats Work with a subset of data by filtering lists Manage workbook files and folders Create workbooks using templates Save workbooks using different names and file formats Formatting and Printing Worksheets Apply and modify cell formats Modify row and column formats Apply styles Use automated tools to format worksheets Modify Page Setup options for worksheets Preview and print worksheets and workbooks Modifying Workbooks Insert and delete worksheets Modify worksheet names and positions Use 3-D references Creating and Revising Formulas Create and revise formulas Use statistical, date and time, financial, and logical functions in formulas Creating and Modifying Graphics Create, modify, position, and print charts Create, modify, and position graphics Workgroup Collaboration Convert worksheets into Web pages Create hyperlinks View and edit comments
PowerPoint Create presentations (manually and using automated tools) Add slides to and delete slides from presentations Modify headers and footers in the Slide Master Inserting and Modifying Text Import text from Word Insert, format, and modify text Inserting and Modifying Visual Elements Add tables, charts, clip art, and bitmap images to slides Customize slide backgrounds Add OfficeArt elements to slides Apply custom formats to tables Modifying Presentation Formats Apply formats to presentations Apply animation schemes Apply slide transitions Customize slide formats Customize slide templates Manage a Slide Master Rehearse timing Rearrange slides Modify slide layout Add links to a presentation Printing Presentations Preview and print slides, outlines, handouts, and speaker notes Working with Data from Other Sources Import Excel charts into slides Add sound and video to slides Insert Word tables on slides Export a presentation as an outline Managing and Delivering Presentations Set up slide shows, Deliver presentations Manage files and folders for presentations Work with embedded fonts Publish presentations to the Web Use Pack and Go Workgroup Collaboration Review presentation comments Schedule and deliver presentation broadcasts	Access Creating and Using Databases Create Access databases Open database objects in multiple views Move among records Format datasheets Creating and Modifying Tables Add a predefined input mask to a field Create Lookup fields Modify field properties Creating and Modifying Queries Add calculated fields to select queries Creating and Modifying Forms Modify form properties Viewing and Organizing Information Enter, edit, and delete records Sort records Filter records Defining Relationships Create one-to-many relationships Enforce referential integrity Create and format reports Add calculated controls to reports Preview and print reports Integrating with Other Applications Import data to Access Export data from Access Create a simple data access page 71%of supervisors use Office Specialists in hiring, promotion, and advancement decisions!
Word Expert Customizing Paragraphs Control pagination Sort paragraphs in lists and tables Formatting Documents Create and format document sections Create and apply character and paragraph styles Create and update document indexes and tables of contents, figures, and authorities Create cross-references Add and revise endnotes and footnotes Create and manage master documents and subdocuments Create and modify forms using various form controls Perform calculations in Word tables Creating and Modifying Graphics,Align text and graphics Create, edit, and run macros Customize menus and toolbars Track, accept, and reject changes to documents Merge input from several reviewers Insert and modify hyperlinks Create and edit Web documents in Word Create document versions Help protect documents Using Mail Merge Merge letters with a Word, Excel, or Access data source Merge labels with a Word, Excel, or Access data source Use Outlook data as mail merge data source	Excel Expert Import data to Excel Export data from Excel Publish worksheets and workbooks to the Web Managing Workbooks Create, edit, and apply templates Use data consolidation Formatting Numbers, Create and apply custom number formats Use conditional formats Working with Ranges, Use named ranges in formulas Use Lookup and Reference functions Customize toolbars and menus Create, edit, and run macros Audit formulas, Locate and resolve errors Use subtotals with lists and ranges Define and apply filters Add group and outline criteria to ranges Use data validation Retrieve external data and create queries Web queries Analyzing Data, Create a Microsoft PivotTable®, Microsoft PivotChart®, and PivotTable/PivotChart Reports Forecast values with what-if analysis Create and display scenarios Workgroup Collaboration Modify passwords, protections, and properties Create a shared workbook Track, accept and reject changes to workbooks Merge workbooks
Outlook 2002 Creating and Viewing Messages Display and print messages Compose and send messages to corporate/workgroup and Internet addresses Insert signatures and attachments Customize views Scheduling Add appointments, meetings, and events to the Outlook calendar Apply conditional formats to the Outlook calendar Respond to meeting requests Use categories to manage appointments Print calendars Move messages between folders Search for messages Save messages in alternate file formats Use categories to manage messages Set message options Create and edit contacts, Organize and sort contacts Link contacts to activities and journal entries Creating and Managing Tasks and Notes Create and update tasks Modify task organization and Task view Accept, decline, or delegate tasks Create and modify notes Use categories to manage tasks and notes

Training: Explain the different options, basic computer training by authorized Certiport Centers or self-training with approved courseware.