Microsoft Office 2010 is a comprehensive system of programs, servers, services, and solutions, including a dozen desktop productivity programs that you can install on your computer, and four new online program versions. To meet the varying needs of individuals and organizations, Microsoft offers five different Office 2010 software suites, each consisting of a different subset of programs. The following table identifies the programs available in each of the software suites.
|
Office Home and Student 2010 |
Office Home and Business 2010 |
Office Standard 2010 |
Office Professional 2010 |
Office Professional Plus 2010 | |
|---|---|---|---|---|---|
|
Access |
Yes |
Yes | |||
|
Communicator |
Yes | ||||
|
Excel |
Yes |
Yes |
Yes |
Yes |
Yes |
|
InfoPath |
Yes | ||||
|
OneNote |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Outlook |
Yes |
Yes |
Yes |
Outlook with Business Contact Manager | |
|
PowerPoint |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Publisher |
Yes |
Yes |
Yes | ||
|
SharePoint Workspace |
Yes | ||||
|
Word |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Office Web Apps |
Yes |
Yes |
Office Standard and Office Professional Plus are available only to volume licensing subscribers. The Office Web Apps, which are available with Office Standard and Office Professional Plus, and available to the general public through Windows Live, are online versions of Word, Excel, PowerPoint, and OneNote. You can store documents online and work with them from within any Web browser window by using the Office Web Apps.
This book provides instructional material for the following programs, which together form the Office Professional 2010 software suite:
Microsoft Word 2010 A word-processing program with which you can quickly and efficiently author and format documents.
Microsoft Excel 2010 A spreadsheet program with which you can analyze, communicate, and manage information.
Microsoft PowerPoint 2010 A program with which you can develop and present dynamic, professional-looking slide presentations.
Microsoft OneNote 2010 A digital notebook program with which you can collect, organize, and quickly locate many types of electronic information.
Microsoft Outlook 2010 A personal information management program with which you can manage e-mail, contacts, meetings, tasks, and other communications.
Microsoft Access 2010 A database program with which you can collect information and output information for reuse in a variety of formats.
Microsoft Publisher 2010 A desktop publishing program with which you can lay out newsletters, cards, calendars, and other publications.
The information in this book applies to these programs in all the software suites. If you have a software suite other than Office Professional, or if you installed one or more of these programs independently of a software suite, this is the right book for you.
Desktop computing proficiency is increasingly important in today’s business world. When screening, hiring, and training employees, more employers are relying on the objectivity and consistency of technology certification to ensure the competence of their workforce. As an employee or job seeker, you can use technology certification to prove that you already have the skills you need to succeed. A Microsoft Office Specialist (MOS) is an individual who has demonstrated worldwide skill standards through a certification exam in one or more of the Office 2010 programs, including Microsoft Access, Excel, Outlook, PowerPoint, or Word. To learn more about the MOS program, visit the Microsoft Office Specialist Certification page at go.microsoft.com/fwlink/?LinkId=193884.
The chapters of this book that cover Microsoft Word 2010, Excel 2010, PowerPoint 2010, Outlook 2010, and Access 2010 are excerpted from the full-length Step by Step books written about those programs. This book provides an overview of each program and information to get you started. To learn more, refer to the following books.
By Joyce Cox and Joan Lambert (Microsoft Press, 2010)
ISBN 978-0-7356-2693-5
Contents:
1 Explore Word 2010
2 Edit and Proofread Text
3 Change the Look of Text
4 Organize Information in Columns and Tables
5 Add Simple Graphic Elements
6 Preview, Print, and Distribute Documents
7 Insert and Modify Diagrams
8 Insert and Modify Charts
9 Use Other Visual Elements
10 Organize and Arrange Content
11 Create Documents for Use Outside of Word
12 Explore More Text Techniques
13 Use Reference Tools for Longer Documents
14 Work with Mail Merge
15 Collaborate on Documents
16 Work in Word More Efficiently
By Curtis Frye (Microsoft Press, 2010)
ISBN 978-0-7356-2694-2
Contents:
1 Setting Up a Workbook
2 Working with Data and Excel Tables
3 Performing Calculations on Data
4 Changing Workbook Appearance
5 Focusing on Specific Data by Using Filters
6 Reordering and Summarizing Data
7 Combining Data from Multiple Sources
8 Analyzing Alternative Data Sets
9 Creating Dynamic Worksheets by Using PivotTables
10 Creating Charts and Graphics
11 Printing
12 Automating Repetitive Tasks by Using Macros
13 Working with Other Microsoft Office Programs
14 Collaborating with Colleagues
By Joyce Cox and Joan Lambert (Microsoft Press, 2010)
ISBN 978-0-7356-2691-1
Contents:
1 Explore PowerPoint 2010
2 Work with Slides
3 Work with Slide Text
4 Format Slides
5 Add Simple Visual Enhancements
6 Review and Deliver Presentations
7 Add Tables
8 Fine-Tune Visual Elements
9 Add Other Enhancements
10 Add Animation
11 Add Sound and Movies
12 Share and Review Presentations
13 Create Custom Presentation Elements
14 Prepare for Delivery
15 Customize PowerPoint
By Joan Lambert and Joyce Cox (Microsoft Press, 2010)
ISBN 978-0-7356-2690-4
Contents:
1 Get Started with Outlook 2010
2 Explore the Outlook Windows
3 Send and Receive E-Mail Messages
4 Store and Access Contact Information
5 Manage Scheduling
6 Track Tasks
7 Organize Your Inbox
8 Manage Your Calendar
9 Work with Your Contact List
10 Enhance Message Content
11 Manage E-Mail Settings
12 Work Remotely
13 Customize Outlook
By Joyce Cox and Joan Lambert (Microsoft Press, 2010)
ISBN 978-0-7356-2692-8
Contents:
1 Explore an Access 2010 Database
2 Create Databases and Simple Tables
3 Create Simple Forms
4 Display Data
5 Create Simple Reports
6 Maintain Data Integrity
7 Create Custom Forms
8 Create Queries
9 Create Custom Reports
10 Import and Export Data
11 Make Databases User Friendly
12 Protect Databases
13 Customize Access
Office 2010 includes new features, new functionality, and an easy-to-use interface intended to streamline your computing experience and make it easier to learn new programs. We’re excited to bring you this glimpse into the inner workings of selected features in the core Office programs. We’ll start with the basics and work into the most interesting and necessary features of each program. If you are an experienced Office user, you can skim Chapter 1 skip Chapter 2 and jump right into the program-specific chapters.