Here's the book you need to prepare for the seven MOUS exams employers are demanding the most--Word 2002 Core, Word 2002 Expert, Excel 2002 Core, Excel 2002 Expert, PowerPoint 2002 Core, Outlook 2002 Core, and Access 2002 Core. * In-depth coverage of official exam objectives * Clear explanations of complex Office tasks * Practical examples and detailed instructions Authoritative coverage of all exam objectives, including: Word Core and Expert Inserting and Modifying Text Creating and Modifying Paragraphs and Tables Formatting and Managing Documents Creating and Modifying Graphics Using Mail Merge Excel Core and Expert Working with Cells and Cell Data Managing and Modifying Workbooks Creating and Revising Formulas Importing and Exporting Data Analyzing and Summarizing Data PowerPoint Core Creating and Modifying a Presentation Inserting and Modifying Text and Visual Elements Working with Data from Other Sources Managing and Delivering Presentations Workgroup Collaboration Access Core Creating and Using Databases and Tables Creating and Modifying Queries Creating and Modifying Forms Defining Relationships Producing Reports Outlook Core Creating and Viewing Messages Scheduling Managing Messages Creating and Managing Contacts, Tasks, and Notes
This practical guide presents all the features of the Microsoft® Outlook 2007 e-mail application. After becoming familiar with the application's working environment, you will then learn how to send and receive all types of messages and personalise your mail box (message format, signatures, junk e-mail filters, etc). The third section teaches you how to use the Calendar for managing your appointments, meetings and events. You will then learn about all the other folders in Outlook: contacts, tasks, notes, and the journal. The last section teaches you how to use the all the features you will need for managing the different items that can be created with Outlook.
This practical guide teaches you how to get the most out of Microsoft® Excel 2007. After a description of the new environment, which has been improved from the previous versions, and learning how to manage files, templates and datasheets, you will quickly become familiar with entering and editing data (numbers, dates, calculation formulas, data series). You will then learn how to use the tools for formatting data (fonts, colours, borders, AutoFormats, styles, etc), create outlines, use worksheet auditing, and print your tables replete with various graphics and charts. The guide also explains the different ways you can use Excel to create tables and pivot charts by using datasheets. As a portion of this guide focuses on working with multiple users, it includes all you need to know about sharing and protecting your data. The latter chapters discuss techniques for improving data entry (creating custom data series or drop-down lists), and how to insert hyperlinks, import and export data, use macro commands, and create Web pages.
This practical guide to Microsoft Office Access 2007 was designed so that you can easily find all the functions needed for working with this relational database management program. It includes a description of the Access environment, and teaches you how to create a database and manage its objects, create and link tables, create forms and reports and manage their controls, manage records by using datasheets and forms (entering, editing, sorting and filtering data), select and delete records using queries, create pivot tables, create charts using data or pivot charts, and create macros, among others.
This book is made up of five parts, each dealing with a specific topic: managing Word documents, getting help on Word and using its Research tools, working with text (entering, editing, copying and moving text), document presentation (formatting text and paragraphs, tables, charts, drawing objects, outlines), setting up and printing documents, and other features such as group work and creating and previewing web pages. Each chapter is independent of the others, so that you can choose what to study, and in what order. At the end of the book, you will find the official list of topics tested in the MOS Word 2003 Core exam, including the number of the corresponding lesson and exercise in the book.
This practical guide to Microsoft® Word 2007 will enable you to make full use of the new version of this popular word processing programme. After becoming familiar with the new environment of the 2007 version, you will learn how to create and save your documents, how to enter and edit text, and how to format and print your documents. The following sections teach you how to format text (character, paragraph and page formatting). To be able to take full advantage of Word's formatting possibilities, you will then learn how to apply a theme to a document and create styles and templates. You will then go to the next step of text management by learning how to use the Find and Replace feature, the automatic spell check, the synonym dictionary, and the translation feature. Section 8 discusses working with lengthy documents and teaches you how to create a note or a bookmark, an outline, a table of contents, an index, a bibliography, or a master document. As a Word document can contain much more than just text, you will also learn how to work with tables, graphic objects, and pictures. The last part teaches you how to create forms, mail-merges, macro commands, and how multiple users can work on a single document by using the Track Changes feature.
This practical guide to Microsoft® PowerPoint 2007 was designed so that you can easily find all the functions needed for making the most out of this Computer Assisted Presentation software. After becoming familiar the working environment and the various views, you will learn how to create and manage documents (opening and saving presentations and templates, creating photo albums); print, format and manage presentation elements (slides, masks, themes, backgrounds); manage text (entering slide and outline text); create, edit and format objects (automatic layouts, tables, pictures, multimedia objects, diagrams and charts); and, create dynamic slide shows (animations, timing and annotating slides during a show). The last part of the book discusses PowerPoint 2007's advanced features, such as managing hyperlinks, revising a slide show, working with other Office applications, and creating Web pages.
This book is made up of four parts, each dealing with a specific topic: document contents and presentation (text, tables, charts, objects, styles and templates), long documents (sections, notes, bookmarks, outlines, tables of contents, indexes, master documents), bulk mail tools (forms, mail merge) and various advanced functions (macros, customising the interface, group work and document protection, Web and frames pages, and using XML in Word). Each chapter is independent of the others, so that you can choose what to study, and in what order. At the end of the book, you will find the official list of topics tested in the Microsoft Office Specialist Word 2003 Expert exam. The number of the corresponding lesson and exercise is given next to each topic in the list.