Go into the exams confident-and come out MOUS-certified!

Earning your Microsoft Office User Specialist (MOUS) certification shows your current or future employer that you have the skills they need. This book helps you get those skills--by reinforcing what you know, teaching you what you don't, and preparing you for all the questions you'll face on the exam. Affordable and comprehensive, the Microsoft Office 2000 User Specialist Study Guide is the clear choice, and the only study resource you need to ready yourself to pass all the MOUS exams.

Meet every exam's objectives:
Word 2000
* Format characters and paragraphs
* Use styles, templates, and macros
* Publish documents on the Web
* Create tables and forms
* Generate a mail merge

Excel 2000
* Create, modify, and print workbooks
* Format worksheets
* Create charts
* Audit worksheets
* Create and use templates

Access 2000
* Create and modify a database
* Integrate information from other applications
* Publish Access data to the Web
* Build forms for other users
* Produce reports

PowerPoint 2000
* Create and modify presentations
* Add textual and visual information
* Deliver and distribute presentations

Outlook 2000
* Manage a contact list and calendar
* Send, receive, and organize e-mail
* Identify and filter spam and other unwanted e-mail
* Make Outlook work with other Office applications

FrontPage 2000
* Build and manage Web sites
* Publish Web documents from Word, Excel, and Access
* Create hyperlinks to link your site to others
* Craft your site's navigational structure using Navigation bars

PhotoDraw
* Learn the PhotoDraw interface and expansive tool set
* Import artwork or create your own graphics
* Touch up and enhance photos with designer effects
* Design your own professional images for the Web

You may not have known this, but there are professional certifications for computer users as well as programmers and administrators. The Microsoft Office User Specialist (MOUS) rating tells potential employers that your skills as a user of the Microsoft Office 2000 programs (Word, Excel, Access, Outlook, PowerPoint, FrontPage, and PhotoDraw) have been tested and proven. With proof of your skills in hand, you don't have to expect employers to hire you as just another drone computer user. Microsoft Office 2000 User Specialist Study Guide shows you what you need to know to pass the application exams. Though it was written before the exams became final, the material here correlates closely with Microsoft's published exam objectives.

The emphasis in this book, as in the exam objectives, is on procedures. You have to know what steps to follow in order to protect an Excel spreadsheet with a password, say, or print an envelope under Word. The authors typically present an objective and then quickly list the relevant steps (choose this, click that) with a supporting screen shot, where appropriate. They then follow the how-to material with a brief commentary on more exotic variations of the procedure. Each section concludes with a testing protocol similar to those that appear on the exams. In one test, you're asked to create a new PowerPoint presentation, then add various graphical and multimedia elements to it. The authors present a comprehensive statement of the skills expert users have. --David Wall

Topics covered: All concepts, facts, and skills that appear in Microsoft's published exam objectives for the seven Office 2000 Microsoft Office User Specialist (MOUS) exams.