We’re pleased to announce that Microsoft Office Professional 2010 Step by Step has shipped to the printer and will be available for purchase later this month.

Until then, let us share with you the table of contents as well as an excerpt from the book’s Introduction.

Contents

Part 1 Microsoft Office Professional 2010
1 Explore Office 2010 
2 Work with Files 

Part 2 Microsoft Word 2010
3 Edit and Proofread Text
4 Change the Look of Text
5 Organize Information in Columns and Tables
6 Add Simple Graphic Elements
7 Preview, Print, and Distribute Documents

 
Part 3 Microsoft Excel 2010
8 Set Up a Workbook
9 Work with Data and Excel Tables 10 Perform Calculations on Data
11 Change Workbook Appearance
12 Focus on Specific Data by Using Filters

 
Part 4 Microsoft PowerPoint 2010
13 Work with Slides
14 Work with Slide Text
15 Format Slides
16 Add Simple Visual Enhancements
17 Review and Deliver Presentations

 
Part 5 Microsoft OneNote 2010
18 Explore OneNote 2010
19 Create and Configure Notebooks
20 Create and Organize Notes

Part 6 Microsoft Outlook 2010
21 Send and Receive E-Mail Messages
22 Store and Access Contact Information
23 Manage Scheduling
24 Track Tasks

Part 7 Microsoft Access 2010
25 Explore an Access 2010 Database
26 Create Databases and Simple Tables
27 Create Simple Forms
28 Display Data

Part 8 Microsoft Publisher 2010
29 Get Started with Publisher 2010
30 Create Visual Interest
31 Create Colorful Cards and Calendars

Introducing Microsoft Office Professional 2010

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 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.

Certification
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.

For More Information
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.

Microsoft Word 2010 Step by Step
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

Microsoft Excel 2010 Step by Step
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

Microsoft PowerPoint 2010 Step by Step
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

Microsoft Outlook 2010 Step by Step
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

Microsoft Access 2010 Step by Step
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

Let’s Get Started!
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, “Explore Office 2010,” skip Chapter 2, “Work with Files,”
and jump right into the program-specific chapters.