Synopses & Reviews
The smart way to learn Microsoft Officeone step at a time! The second edition of this popular book features new and expanded content. In addition to covering familiar Microsoft Office applications such as Microsoft Office Access™ 2007, Excel® 2007, Outlook® 2007, PowerPoint® 2007, and Word 2007you now also get coverage of Microsoft Office Publisher 2007, SharePoint® Server 2007, Groove® 2007, OneNote® 2007, and InfoPath® 2007. Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to learn the fundamentals of working with the 2007 Microsoft Office system, including how to navigate the new user interface. Learn how to create professional-quality documents, powerful spreadsheets, and compelling slide presentations. And discover how to get your Web site up and running, take notes electronically, and manage your e-mail communications and workday. The companion CD includes skill-building practice files, eBooks, and more. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instructionbuilding and practicing the skills you need, just when you need them!
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].
Synopsis
The smart way to learn Microsoft Officeone step at a time! The second edition of this popular book features new and expanded content. In addition to covering familiar Microsoft Office applications such as Microsoft Office Access™ 2007, Excel® 2007, Outlook® 2007, PowerPoint® 2007, and Word 2007you now also get coverage of Microsoft Office Publisher 2007, SharePoint® Server 2007, Groove® 2007, OneNote® 2007, and InfoPath® 2007. Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to learn the fundamentals of working with the 2007 Microsoft Office system, including how to navigate the new user interface. Learn how to create professional-quality documents, powerful spreadsheets, and compelling slide presentations. And discover how to get your Web site up and running, take notes electronically, and manage your e-mail communications and workday. The companion CD includes skill-building practice files, eBooks, and more. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instructionbuilding and practicing the skills you need, just when you need them!
Synopsis
Teach yourself exactly what you need to know about using Office Professional 2010-one step at a time! With STEP BY STEP, you build and practice new skills hands-on, at your own pace. Covering Microsoft Word, PowerPoint, Outlook, Excel, Access, Publisher, and OneNote, this book will help you learn the core features and capabilities needed to:
- Create attractive documents, publications, and spreadsheets
- Manage your e-mail, calendar, meetings, and communications
- Put your business data to work
- Develop and deliver great presentations
- Organize your ideas and notes in one place
- Connect, share, and accomplish more when working together"
About the Author
Joan Lambert has worked in the training and certification industry since 1997. As president of Online Training Solutions, Inc. (OTSI), Joan is responsible for guiding the translation of technical information and requirements into useful, relevant, and measurable training, learning, and certification deliverables. An MCTS, MOM, MCAS, and MCT, Joan is the author or coauthor of more than two dozen books about Windows and Microsoft Office (for Windows and for Mac).
Joyce Cox has more than 30 years' experience in the development of training materials about technical subjects for non-technical audiences and is the author of dozens of books about Office and Windows technologies. Joyce is vice president of Online Training Solutions, Inc. (OTSI). Previously, she was president of and principal author for Online Press, where she developed the Quick Course series of computer training books for beginning and intermediate adult learners. She was also the first managing editor of Microsoft Press, an editor for Sybex, and an editor for the University of California.
Curtis D. Frye is a coauthor of Microsoft Office Excel 2003 Programming Inside Out and the author of Microsoft Office Excel 2007 Step by Step, Microsoft Excel Version 2007 Plain & Simple, Faster Smarter Home Networking, several books on Microsoft Access, and numerous online training courses.
Table of Contents
Introducing Microsoft Office Professional 2010; Certification; For More Information; Lets Get Started!; Modifying the Display of the Ribbon; Dynamic Ribbon Elements; Changing the Width of the Ribbon; Adapting Exercise Steps; Features and Conventions of This Book; Using the Practice Files; Getting Help; Getting Help with This Book; Getting Help with Office 2010; More Information; Part 1: Microsoft Office Professional 2010; Chapter 1: Explore Office 2010; 1.1 Working in the Program Environment; 1.2 Changing Program Settings; 1.3 Customizing the Ribbon; 1.4 Customizing the Quick Access Toolbar; 1.5 Key Points; Chapter 2: Work with Files; 2.1 Creating and Saving Files; 2.2 Opening, Moving Around in, and Closing Files; 2.3 Viewing Files in Different Ways; 2.4 Key Points; Part 2: Microsoft Word 2010; Chapter 3: Edit and Proofread Text; 3.1 Making Text Changes; 3.2 Finding and Replacing Text; 3.3 Fine-Tuning Text; 3.4 Correcting Spelling and Grammatical Errors; 3.5 Inserting Saved Text; 3.6 Key Points; Chapter 4: Change the Look of Text; 4.1 Quickly Formatting Text; 4.2 Changing a Documents Theme; 4.3 Manually Changing the Look of Characters; 4.4 Manually Changing the Look of Paragraphs; 4.5 Creating and Modifying Lists; 4.6 Key Points; Chapter 5: Organize Information in Columns and Tables; 5.1 Presenting Information in Columns; 5.2 Creating Tabbed Lists; 5.3 Presenting Information in Tables; 5.4 Formatting Tables; 5.5 Key Points; Chapter 6: Add Simple Graphic Elements; 6.1 Inserting and Modifying Pictures; 6.2 Changing a Documents Background; 6.3 Inserting Building Blocks; 6.4 Adding WordArt Text; 6.5 Key Points; Chapter 7: Preview, Print, and Distribute Documents; 7.1 Previewing and Adjusting Page Layout; 7.2 Controlling What Appears on Each Page; 7.3 Printing Documents; 7.4 Preparing Documents for Electronic Distribution; 7.5 Key Points; Part 3: Microsoft Excel 2010; Chapter 8: Set Up a Workbook; 8.1 Creating Workbooks; 8.2 Modifying Workbooks; 8.3 Modifying Worksheets; 8.4 Customizing the Excel 2010 Program Window; 8.5 Key Points; Chapter 9: Work with Data and Excel Tables; 9.1 Entering and Revising Data; 9.2 Moving Data Within a Workbook; 9.3 Finding and Replacing Data; 9.4 Correcting and Expanding Upon Worksheet Data; 9.5 Defining Excel Tables; 9.6 Key Points; Chapter 10: Perform Calculations on Data; 10.1 Naming Groups of Data; 10.2 Creating Formulas to Calculate Values; 10.3 Summarizing Data That Meets Specific Conditions; 10.4 Finding and Correcting Errors in Calculations; 10.5 Key Points; Chapter 11: Change Workbook Appearance; 11.1 Formatting Cells; 11.2 Defining Styles; 11.3 Applying Workbook Themes and Excel Table Styles; 11.4 Making Numbers Easier to Read; 11.5 Changing the Appearance of Data Based on Its Value; 11.6 Adding Images to Worksheets; 11.7 Key Points; Chapter 12: Focus on Specific Data by Using Filters; 12.1 Limiting Data That Appears on Your Screen; 12.2 Manipulating Worksheet Data; 12.3 Defining Valid Sets of Values for Ranges of Cells; 12.4 Key Points; Part 4: Microsoft PowerPoint 2010; Chapter 13: Work with Slides; 13.1 Adding and Deleting Slides; 13.2 Adding Slides with Ready-Made Content; 13.3 Dividing Presentations into Sections; 13.4 Rearranging Slides and Sections; 13.5 Key Points; Chapter 14: Work with Slide Text; 14.1 Entering Text in Placeholders; 14.2 Adding Text Boxes; 14.3 Editing Text; 14.4 Correcting and Sizing Text While Typing; 14.5 Checking Spelling and Choosing the Best Words; 14.6 Finding and Replacing Text and Fonts; 14.7 Key Points; Chapter 15: Format Slides; 15.1 Applying Themes; 15.2 Using Different Color and Font Schemes; 15.3 Changing the Slide Background; 15.4 Changing the Look of Placeholders; 15.5 Changing the Alignment, Spacing, Size, and Look of Text; 15.6 Key Points; Chapter 16: Add Simple Visual Enhancements; 16.1 Inserting Pictures and Clip Art Images; 16.2 Inserting Diagrams; 16.3 Inserting Charts; 16.4 Drawing Shapes; 16.5 Adding Transitions; 16.6 Key Points; Chapter 17: Review and Deliver Presentations; 17.1 Setting Up Presentations for Delivery; 17.2 Previewing and Printing Presentations; 17.3 Preparing Speaker Notes and Handouts; 17.4 Finalizing Presentations; 17.5 Delivering Presentations; 17.6 Key Points; Part 5: Microsoft OneNote 2010; Chapter 18: Explore OneNote 2010; 18.1 Navigating in the OneNote Program Window; 18.2 Working in the OneNote Program Window; 18.3 Exploring OneNote in the Default Notebook; 18.4 Customizing OneNote; 18.5 Key Points; Chapter 19: Create and Configure Notebooks; 19.1 Creaaaaaating a Notebook for Use by One Person; 19.2 Creating a Notebook for Use by Multiple People; 19.3 Creating Sections and Pages; 19.4 Key Points; Chapter 20: Create and Organize Notes; 20.1 Working with Note Containers; 20.2 Entering Content Directly onto a Page; 20.3 Sending Content to OneNote; 20.4 Capturing Audio and Video Notes; 20.5 Taking Notes on the Side; 20.6 Key Points; Part 6: Microsoft Outlook 2010; Chapter 21: Send and Receive E-Mail Messages; 21.1 Creating and Sending Messages; 21.2 Attaching Files to Messages; 21.3 Viewing Messages and Message Attachments; 21.4 Configuring Reading Pane Behavior; 21.5 Viewing Message Participant Information; 21.6 Responding to Messages; 21.7 Key Points; Chapter 22: Store and Access Contact Information; 22.1 Saving and Updating Contact Information; 22.2 Communicating with Contacts; 22.3 Displaying Different Views of Contact Records; 22.4 Printing Contact Records; 22.5 Key Points; Chapter 23: Manage Scheduling; 23.1 Scheduling and Changing Appointments; 23.2 Scheduling and Changing Events; 23.3 Scheduling Meetings; 23.4 Responding to Meeting Requests; 23.5 Displaying Different Views of a Calendar; 23.6 Key Points; Chapter 24: Track Tasks; 24.1 Creating Tasks; 24.2 Updating Tasks; 24.3 Removing Tasks and Items from Task Lists; 24.4 Managing Task Assignments; 24.5 Displaying Different Views of Tasks; 24.6 Key Points; Part 7: Microsoft Access 2010; Chapter 25: Explore an Access 2010 Database; 25.1 Working in Access 2010; 25.2 Understanding Database Concepts; 25.3 Exploring Tables; 25.4 Exploring Forms; 25.5 Exploring Queries; 25.6 Exploring Reports; 25.7 Previewing and Printing Access Objects; 25.8 Key Points; Chapter 26: Create Databases and Simple Tables; 26.1 Creating Databases from Templates; 26.2 Creating Databases and Tables Manually; 26.3 Manipulating Table Columns and Rows; 26.4 Refining Table Structure; 26.5 Creating Relationships Between Tables; 26.6 Key Points; Chapter 27: Create Simple Forms; 27.1 Creating Forms by Using the Form Tool; 27.2 Changing the Look of Forms; 27.3 Changing the Arrangement of Forms; 27.4 Key Points; Chapter 28: Display Data; 28.1 Sorting Information in Tables; 28.2 Filtering Information in Tables; 28.3 Filtering Information by Using Forms; 28.4 Locating Information That Matches Multiple Criteria; 28.5 Key Points; Part 8: Microsoft Publisher 2010; Chapter 29: Get Started with Publisher 2010; 29.1 Starting New Publications; 29.2 Storing Personal and Company Information; 29.3 Previewing and Printing Publications; 29.4 Key Points; Chapter 30: Create Visual Interest; 30.1 Working with Text Boxes; 30.2 Working with WordArt; 30.3 Working with Graphics; 30.4 Working with Shapes; 30.5 Working with Ready-Made Visual Elements; 30.6 Key Points; Chapter 31: Create Colorful Cards and Calendars; 31.1 Creating Folded Cards; 31.2 Creating Postcards; 31.3 Creating Calendars; 31.4 Key Points;