Microsoft Office Professional 2010 Step by Step eBook

PUBLISHED BY

Microsoft Press

A Division of Microsoft Corporation

One Microsoft Way

Redmond, Washington 98052-6399

Copyright ? 2011 by Online Training Solutions, Inc. and Curtis Frye

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any

means without the written permission of the publisher.

Library of Congress Control Number: 2010932312

ISBN: 978-0-7356-2696-6

Printed and bound in the United States of America.

5 6 7 8 9 10 11 12 13 QG 7 6 5 4 3 2

Microsoft Press books are available through booksellers and distributors worldwide. For further infor?mation about

international editions, contact your local Microsoft Corporation office or contact Microsoft Press International

directly at fax (425) 936-7329. Visit our Web site at mspress. Send comments to mspinput@

.

Microsoft and the trademarks listed at about/legal/en/us/IntellectualProperty/Trademarks/

EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of their respective

owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and

events depicted herein are fictitious. No association with any real company, organization, product, domain name,

e-mail address, logo, person, place, or event is intended or should be inferred.

This book expresses the author¡¯s views and opinions. The information contained in this book is provided without

any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or

distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by

this book.

Acquisitions Editor: Juliana Atkinson

Developmental Editor: Devon Musgrave

Project Editor: Joel Panchot

Editorial Production: Online Training Solutions, Inc.

Cover: Girvin

Body Part No. X17-08755

[2012-11-09]

Contents

Introducing Microsoft Office Professional 2010 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv

Modifying the Display of the Ribbon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxi

Features and Conventions of This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxvii

Using the Practice Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxix

Getting Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxiii

Your Companion eBook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxiii

Part 1

1

Microsoft Office Professional 2010

Explore Office 2010

3

Working in the Program Environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

Changing Program Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

Customizing the Ribbon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26

Customizing the Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31

Key Points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35

2

Work with Files

37

Creating and Saving Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Sidebar: File Compatibility with Earlier Versions of Office Programs . . . . . . . .

Opening, Moving Around in, and Closing Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Viewing Files in Different Ways . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Key Points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

38

44

46

52

60

What do you think of this book? We want to hear from you!

Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources

for you. To participate in a brief online survey, please visit:

learning/booksurvey

?? iii

iv

Contents

Part 2

3

Microsoft Word 2010

Edit and Proofread Text

63

Making Text Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64

Sidebar: About the Clipboard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72

Finding and Replacing Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73

Fine-Tuning Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79

Correcting Spelling and Grammatical Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87

Sidebar: Viewing Document Statistics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93

Inserting Saved Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93

Sidebar: Inserting One Document into Another . . . . . . . . . . . . . . . . . . . . . . . . . 97

Key Points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97

4

Change the Look of Text

99

Quickly Formatting Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100

Changing a Document¡¯s Theme . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106

Manually Changing the Look of Characters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111

Sidebar: Character Formatting and Case Considerations . . . . . . . . . . . . . . . . 119

Manually Changing the Look of Paragraphs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119

Sidebar: Finding and Replacing Formatting . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130

Creating and Modifying Lists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130

Sidebar: Formatting Text as You Type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136

Key Points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137

5

Organize Information in Columns and Tables

139

Presenting Information in Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140

Creating Tabbed Lists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 147

Presenting Information in Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149

Sidebar: Performing Calculations in Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158

Sidebar: Other Layout Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159

Formatting Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160

Sidebar: Quick Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164

Key Points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165

Contents?? v

6

Add Simple Graphic Elements

167

Inserting and Modifying Pictures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168

Sidebar: About Clip Art . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174

Changing a Document¡¯s Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176

Inserting Building Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183

Sidebar: Drawing Text Boxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196

Adding WordArt Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197

Sidebar: Formatting the First Letter of a Paragraph . . . . . . . . . . . . . . . . . . . . . 202

Key Points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 203

7

Preview, Print, and Distribute Documents

205

Previewing and Adjusting Page Layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 206

Controlling What Appears on Each Page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 212

Printing Documents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 217

Preparing Documents for Electronic Distribution . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219

Key Points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 224

Part 3

8

Microsoft Excel 2010

Set Up a Workbook

227

Creating Workbooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 228

Modifying Workbooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233

Modifying Worksheets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237

Customizing the Excel 2010 Program Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241

Zooming In on a Worksheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 242

Arranging Multiple Workbook Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243

Adding Buttons to the Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . .244

Customizing the Ribbon . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246

Maximizing Usable Space in the Program Window . . . . . . . . . . . . . . . . . . . . . 249

Key Points . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 253

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download