The O'Leary Series emphasizes the "learning by doing" approach by combining conceptual coverage with detailed, software-specific instructions. Each lab manual provides a new running case study based on realistic business scenarios that leads the student step-by-step from problem to solution. The Advanced Office text is a Core Level MOUS Certified book that includes all of the Introductory level O'Leary Office content.

This new text from the Shelly Cashman Series goes well beyond the fundamentals by covering more advanced Microsoft Office 2000 functionality for skilled users

Shows how to use each component of Microsoft Office, and offers advice on creating documents, spreadsheets, databases, graphics, and presentations

Learn how to get the maximum performance out of software through optimization, customization, and a thorough understanding of the advanced functions. This title is unique in that it offers the most advanced treatment of Office aimed at the power user/super user, with highly prized third-party utilities on the CD-ROM.

Explains how to create functional spreadsheets and offers advice on entering data, working with formulas, and importing and converting files

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