Synopses & Reviews
Microsoft anticipates that Office 2007 will break records in its first year of release. The new bells and whistles will rush some to upgrade faster than they did with the previous version, which took a while to catch on. The previous version of Office 2003 Student and Teacher Edition was the #1 best-selling software program in the Business category. The low price point and included applications are just what most students and home users need to accomplish most of their work. A large audience base will help propel this new version to the top of the charts as well. Written in the traditional Special Edition Using style, this comprehensive text will be your companion for the entire life of the software. Filled with specific examples for this audience, you will find thorough coverage of each application in the home and student version of Office.
FM Front Matter
I: Common Tasks and Features
1 Getting Started with Office 2007
2 Making Office2007 Work Your Way
3 Keeping Track of Your Files and Settings
4 Entering, Editing, and Formatting Text
5 Using Pictures and Graphics in Office
6 Using Office Programs Together
II: Using Word
7 Getting Started with Word
8 Creating Great-Looking Documents
9 Organizing Complex Documents with Advanced Formatting Options
10 Mastering Styles, Templates, and Themes
11 Letters, Mail Merge, and “Smart” Documents
III: Using Excel
12 Getting Started with Excel
13 Making Great-Looking Worksheets
14 Using Formulas and Functions
15 Working with Tables and PivotTables
16 Turning Data into Charts
IV: Using PowerPoint
17 Getting Started with PowerPoint
18 Building Your Presentation
19 Adding Sizzle to a Presentation
20 Delivering a Presentation with Style
V: Using OneNote
21 Getting Started with OneNote
22 Organizing and Arranging Notes
23 OneNote for Experts
VI: Advanced Tasks and Features
24 Extending Office with Templates, Macros, and Add-ins
25 Using Office on a Tablet PC
26 Using Macros to Automate Routine Tasks
Special Edition Using Microsoft Office Home and Student 2007
THE ONLY OFFICE BOOK YOU NEED
We crafted this book to grow with you, providing the reference material you need as you move toward Office 2007 proficiency and use of more advanced features. If you buy only one book on Office Home and Student 2007, Special Edition Using Microsoft Office Home and Student 2007 is the book you need.
Office Home and Student 2007 is available to ANYONE, regardless of whether you are a student, a teacher, or neither. The only condition Microsoft attaches is the requirement that the software not be used for commercial purposes. For use in the home or classroom, Office Home and Student 2007 is an exceptional deal at a fraction of the cost of the business versions!
• No other authoring team in the business is as well recognized and respected as the Office Dream Team; when they speak, even the Office development team at Microsoft listens!
• This book is a category killer–one that sets the pace for others to follow!
• Tired of Office books that read as though Microsoft employees wrote them? Tired of learning the Microsoft way? Tired of books containing little more than you can pull from the Help system? If you answered yes to any of these questions, then you owe it to yourself to get a copy of this book!
• If you own a copy of Office Home and Student 2007, you deserve a copy of this book! Here, you’ll find a bevy of previously undocumented tips and tricks that will show you how to harness the power of Office 2007!
• Written in clear, plain English, readers will feel as though they are learning from real humans and not Microsoft clones. Sprinkled with a wry sense of humor and an amazing depth of field, this book most certainly isn’t your run-of-the-mill computer book
“Another Special Edition Winner! Clear, concise and right on-target. Everything a student or a home user will need to know in order to master Office 2007.”
–Alan & Sandra Ashendorf, Hosts of Let’s Talk Computers Radio Talk Show
Ed Bott is a best-selling author of more than 25 computer books and an award-winning computer journalist with two decades of experience in the personal computer industry. He is a three-time winner of the Computer Press Award, and he and Woody Leonhard won the prestigious Jesse H. Neal Award, sometimes referred to as “the Pulitzer Prize of the business press,” in back-to-back years for their work on PC Computing’s “Windows SuperGuide.” You can read more of Ed’s writing at http://www.edbott.com/weblog.
Curmudgeon, critic, and perennial “Office Victim,” Woody Leonhard runs a fiercely independent website with up-to-the-nanosecond news, observations, tips, and help for both Office and Windows. AskWoody.com has become the premier source of unbiased information for people who need to really use Windows and Office, and for people concerned about juggling the neverending stream of Microsoft patches. In the past 15 years, Woody has written more than three dozen books, drawing an unprecedented six Computer Press Association awards and two American Business Press awards. Woody was one of the first Microsoft Consulting Partners and is a charter member of the Microsoft Solutions Provider organization.
Category: Integrated Suites
Covers: Microsoft Office Home and Student 2007
User Level: Beginner–Intermediate
About the Author
Ed Bott is a best-selling author and award-winning technology journalist who has been covering the personal computer industry since the days when an 8MHz 80286 was a smokin’ machine. Ed’s feature stories and columns about Microsoft and its products have appeared regularly in print and on the web for more than 15 years, and he has written books on nearly every version of Microsoft Windows and Microsoft Office–so many, in fact, that he’s lost count of the exact number. He is a three-time winner of the Computer Press Award and earned the Award of Merit from the Society for Technical Communication in 2003. Ed and Woody Leonhard won the prestigious Jesse H. Neal Award, sometimes referred to as “the Pulitzer Prize of the business press,” in back-to-back years for their work on PC Computing’s “Windows SuperGuide.” He lives in an extremely civilized corner of the American Southwest with his wife, Judy, and a growing menagerie of affectionate pets who are sometimes smarter than he is. You can read Ed’s latest writings at Ed Bott’s Windows Expertise (http://www.edbott.com/weblog) and Ed Bott’s Microsoft Report (http://blogs.zdnet.com/bott).
Woody Leonhard describes himself as a “Certified Office Victim.” With more than 40 computer books under his belt, he’s seen parts of Office that would curl your hair. Woody’s best known for his fiercely independent website, AskWoody.com, which mercilessly holds Microsoft’s feet to the fire, and specializes in keeping consumers informed about problems with Microsoft patches. He’s also a Contributing Editor with Windows Secrets Newsletter, windowssecrets.com. Woody has won eight Computer Press Awards and, with Ed, two American Business Press Association awards. He moved to Phuket, Thailand, seven years ago, where he now basks in the sun with his wife, Duangkhae, 82-year-old father, George, and all-American beagle, Chronos.
Table of Contents
Part I Common Tasks and Features
1 Getting Started with Office 2007 9
2 Making Office 2007 Work Your Way 27
3 Keeping Track of Your Files and Settings 55
4 Entering, Editing, and Formatting Text 81
5 Using Pictures and Drawings in Office 107
6 Using Office Programs Together 139
Part II Using Word
7 Getting Started with Word 161
8 Creating Great-Looking Documents 203
9 Organizing Complex Documents with Advanced Formatting Options 241
10 Mastering Styles, Templates, and Themes 287
11 Letters, Mail Merge, and “Smart” Documents 311
Part III Using Excel
12 Getting Started with Excel 353
13 Making Great-Looking Worksheets 401
14 Using Formulas and Functions 439
15 Working with Tables and PivotTables 473
16 Turning Data into Charts 513
Part IV Using PowerPoint
17 Getting Started with PowerPoint 541
18 Building Your Presentation 563
19 Adding Sizzle to a Presentation 595
20 Delivering a Presentation with Style 615
Part V Using OneNote
21 OneNote Essentials 633
22 Organizing and Arranging Information in OneNote 653
23 OneNote for Experts 669
Part VI Advanced Tasks and Features
24 Extending Office with Templates, Macros, and Add-ins 687
25 Using Office on a Tablet PC 711
26 Using Macros to Automate Routine Tasks 721