Microsoft Office Professional 2013 Step by Step [NOOK Book]


The smart way to learn Microsoft Office Professional 2013—one step at a time!

Experience learning made easy—and quickly teach yourself how to get more done with Microsoft Word, PowerPoint, Excel, Outlook, OneNote, Access, and Publisher. With Step by Step, you set the pace—building and practicing the skills you need, just when you need them!

See more details below
Microsoft Office Professional 2013 Step by Step

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$19.99 price
(Save 44%)$35.99 List Price


The smart way to learn Microsoft Office Professional 2013—one step at a time!

Experience learning made easy—and quickly teach yourself how to get more done with Microsoft Word, PowerPoint, Excel, Outlook, OneNote, Access, and Publisher. With Step by Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Determine the best Office tool for specific tasks
  • Use Office efficiently on touch-enabled devices
  • Create attractive documents, publications, and presentations
  • Manage your e-mail, calendar, meetings, and communications
  • Put your business data to work with Excel and Access
  • Organize and share your notes and ideas with OneNote
Read More Show Less

Product Details

  • ISBN-13: 9780735671805
  • Publisher: Pearson Education
  • Publication date: 5/29/2013
  • Series: Step by Step
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 1216
  • Sales rank: 302,968
  • File size: 62 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Beth Melton is a Microsoft MVP for Office and a Microsoft Office Specialist Master Instructor. She is a coauthor of Microsoft Office Word 2007 Inside Out. Mark Dodge has coauthored several popular books on Excel, including Microsoft Excel 2010 Inside Out. Echo Swinford is a Microsoft MVP for PowerPoint and the author of two books on PowerPoint. Andrew Couch is a Microsoft MVP for Access and an experienced instructor who has taught Introductory and Advanced Access courses as well as VBA programming courses. He is the author of Microsoft Access 2010 VBA Programming Inside Out.Eric Legault is a Microsoft MVP for Outlook focused on delivering document, content, and knowledge management solutions.Ben M. Schorr is a Microsoft MVP for OneNote MVP and the author of four books on Microsoft Office.Ciprian Rusen is a technology aficionado who creates tutorials on his blog for Windows users and helps them get the best possible computing experience. He is the coauthor of Windows 8 Step by Step and Network Your Computers and Devices Step by Step, which covered Windows 7.

Read More Show Less

Table of Contents

Who this book is for;
How this book is organized;
Download the practice files;
Your companion ebook;
Getting support and giving feedback;
Office Professional 2013 Fundamentals;
Chapter 1: Getting comfortable in Office Professional 2013;
1.1 Exploring the Office environment;
1.2 Working with Office files;
1.3 Recovering unsaved files and versions;
1.4 Customizing the user interface;
1.5 Customizing the ribbon;
1.6 Choosing the right application for the task at hand;
1.7 Key points;
Chapter 2: Using shared Office features;
2.1 Identifying new shared features in Office Professional 2013;
2.2 Applying Office themes;
2.3 Inserting graphics, videos, charts, and diagrams;
2.4 Searching for online templates;
2.5 Presenting Office documents online;
2.6 Key points;
Chapter 3: Sharing and collaborating;
3.1 Defining the term cloud service;
3.2 Signing in and managing your Office account;
3.3 Connecting cloud services to your Office account;
3.4 Syncing files with SkyDrive for offline use;
3.5 Getting started with co-authoring;
3.6 Key points;
Chapter 4: Using touch in Office;
4.1 Getting comfortable with Office on a tablet;
4.2 Using touch mode;
4.3 Selecting content with touch;
4.4 Working with ink in Office;
4.5 Key points;
Word 2013;
Chapter 5: Getting comfortable in Word 2013;
5.1 Exploring the Word 2013 user interface;
5.2 Modifying your document view;
5.3 Changing other view options;
5.4 Discovering what’s new in Word 2013;
5.5 Key points;
Chapter 6: Navigating and reading documents;
6.1 Navigating a document by scrolling and using keyboard shortcuts;
6.2 Searching and navigating a document by using the Navigation pane;
6.3 Collapsing and expanding document content;
6.4 Working with documents in the new Read Mode;
6.5 Exploring research tools in Read Mode;
6.6 Key points;
Chapter 7: Editing and composing documents;
7.1 Moving the cursor by using keyboard shortcuts;
7.2 Selecting text by using the keyboard and mouse;
7.3 Using formatting marks during document composition;
7.4 Inserting symbols, international characters, and other special characters;
7.5 Using AutoCorrect;
7.6 Composing documents faster by using building blocks;
7.7 Key points;
Chapter 8: Formatting documents;
8.1 Formatting documents more efficiently;
8.2 Setting default document formatting for your documents;
8.3 Setting section formatting;
8.4 Using styles for paragraph and character formats;
8.5 Exploring other paragraph formats;
8.6 Exploring other character formats;
8.7 Managing pagination through formatting;
8.8 Key points;
Chapter 9: Presenting information;
9.1 Formatting simple lists by using bullets and numbering;
9.2 Creating tabbed lists;
9.3 Inserting tables;
9.4 Enhancing tables;
9.5 Key points;
Chapter 10: Finalizing documents;
10.1 Correcting proofing errors;
10.2 Inspecting documents before publishing;
10.3 Marking documents as final;
10.4 Creating PDF files in Word;
10.5 Printing documents;
10.6 Key points;
PowerPoint 2013;
Chapter 11: Getting comfortable in PowerPoint 2013;
11.1 Getting started working with PowerPoint 2013;
11.2 Exploring the PowerPoint 2013 tools;
11.3 Discovering the new features in PowerPoint 2013;
11.4 Key points;
Chapter 12: Designing and creating presentations;
12.1 Creating a new presentation based on a theme or template;
12.2 Applying a theme to an existing presentation;
12.3 Customizing your file with colors, fonts, and effects;
12.4 Applying theme effects to your presentation;
12.5 Adding graphics to the slide master and layouts;
12.6 Creating a custom slide layout;
12.7 Changing your presentation from a 16:9 to a 4:3 format;
12.8 Key points;
Chapter 13: Creating on-slide content;
13.1 Choosing a slide layout and adding text in placeholders;
13.2 Adding manual text boxes;
13.3 Adding and formatting a table;
13.4 Inserting and formatting charts;
13.5 Creating and formatting SmartArt diagrams;
13.6 Reusing slides and keeping their source formatting;
13.7 Key points;
Chapter 14: Creating Office graphics;
14.1 Adding and formatting shapes;
14.2 Applying enhanced fills and effects;
14.3 Creating your own shapes;
14.4 Inserting, cropping, and formatting pictures;
14.5 Key points;
Chapter 15: Adding animation and multimedia;
15.1 Adding animation to text and shapes;
15.2 Editing video and applying transitions;
15.3 Inserting and playing online video;
15.4 Saving your presentation as a video;
15.5 Key points;
Chapter 16: Finalizing and presenting;
16.1 Adding and renaming sections;
16.2 Inserting comments;
16.3 Printing slides and notes;
16.4 Finalizing your presentation;
16.5 Delivering a presentation;
16.6 Practicing with Presenter view;
16.7 Key points;
Excel 2013;
Chapter 17: Getting comfortable in Excel 2013;
17.1 Starting Excel 2013;
17.2 Identifying what’s new in Excel 2013;
17.3 Key points;
Chapter 18: Creating and editing worksheets;
18.1 Entering and organizing data;
18.2 Changing column widths;
18.3 Using formatting to alter the appearance of data;
18.4 Extending a series with AutoFill;
18.5 Selecting and naming cell ranges;
18.6 Using column headers to define names;
18.7 Moving around in the worksheet;
18.8 Moving and adjusting cells;
18.9 Moving and copying rows and columns;
18.10 Copying one or more cells to many;
18.11 Key points;
Chapter 19: Manipulating numbers and text;
19.1 Creating, editing, and copying formulas;
19.2 Using functions;
19.3 Working with text in Excel;
19.4 Restricting cell entries;
19.5 Key points;
Chapter 20: Analyzing data;
20.1 Exploring a built-in template;
20.2 Performing what-if analyses;
20.3 Using the Quick Analysis tools;
20.4 Formatting conditionally;
20.5 Analyzing data from another source;
20.6 Filtering data with tables;
20.7 Adding data to tables;
20.8 Sorting data;
20.9 Creating a custom sort list;
20.10 Creating a PivotTable;
20.11 Key points;
Chapter 21: Formatting worksheets;
21.1 Applying number formatting;
21.2 Formatting with styles;
21.3 Creating custom themes;
21.4 Formatting in cells;
21.5 Working with custom number formats;
21.6 Working with percentage formats;
21.7 Working with fraction formats;
21.8 Working with date formats;
21.9 Protecting worksheets;
21.10 Setting view options;
21.11 Storing formats in templates;
21.12 Key points;
Chapter 22: Manipulating workbooks and worksheets;
22.1 Inserting rows and columns;
22.2 Inserting and deleting cells;
22.3 Working with panes and page layout options;
22.4 Printing row and column labels on every page;
22.5 Adjusting page breaks;
22.6 Creating a multisheet workbook;
22.7 Manipulating sheets;
22.8 Summarizing a multisheet workbook;
22.9 Working with sheet references;
22.10 Managing multiple workbooks;
22.11 Key points;
Chapter 23: Creating charts and graphics;
23.1 Creating and modifying a chart;
23.2 Adding a slicer to a PivotChart;
23.3 Adding a timeline to a chart;
23.4 Manipulating objects;
23.5 Creating and sharing graphics;
23.6 Key points;
Outlook 2013;
Chapter 24: Getting comfortable in Outlook 2013;
24.1 Setting up an email account in Outlook;
24.2 Navigating the Outlook interface;
24.3 Discovering what’s new in Outlook 2013;
24.4 Key points;
Chapter 25: Using mail;
25.1 Creating and sending messages;
25.2 Attaching files to messages;
25.3 Viewing messages and message attachments;
25.4 Configuring Reading pane behavior;
25.5 Responding to messages;
25.6 Key points;
Chapter 26: Staying on schedule;
26.1 Scheduling and changing appointments;
26.2 Scheduling and changing meetings;
26.3 Responding to meeting requests;
26.4 Displaying different views of a calendar;
26.5 Using the Date Navigator;
26.6 Key points;
Chapter 27: Working with tasks;
27.1 Creating tasks from scratch;
27.2 Setting task options;
27.3 Creating tasks from Outlook items;
27.4 Updating tasks;
27.5 Removing tasks and items from task lists;
27.6 Managing task assignments;
27.7 Reclaiming an assigned task;
27.8 Dealing with tasks other people assign to you;
27.9 Key points;
Chapter 28: Managing contacts and people;
28.1 Viewing contacts;
28.2 Using inline editing;
28.3 Managing linked contacts;
28.4 Configuring a social network account;
28.5 Viewing social network updates;
28.6 Key points;
Chapter 29: Saving time with Outlook;
29.1 Flagging and reviewing important messages;
29.2 Using the Calendar peek to plan your schedule;
29.3 Planning ahead with the Weather bar;
29.4 Organizing your mail with Folder Favorites;
29.5 Searching for related messages;
29.6 Finding messages from a specific sender;
29.7 Conducting quick searches;
29.8 Using Search Folders to view today’s mail;
29.9 Creating items quickly;
29.10 Creating contextual appointments, contacts, and tasks from email messages;
29.11 Key points;
OneNote 2013;
Chapter 30: Getting comfortable in OneNote 2013;
30.1 Getting started with OneNote 2013;
30.2 Exploring the OneNote interface;
30.3 Identifying new and improved features in OneNote 2013;
30.4 Key points;
Chapter 31: Working with notebooks, sections, and pages;
31.1 Creating a notebook;
31.2 Creating and organizing sections;
31.3 Creating and organizing pages;
31.4 Working with ink and shapes;
31.5 Recovering deleted sections or pages;
31.6 Key points;
Chapter 32: Using organizational tools;
32.1 Using tags;
32.2 Creating and customizing tags;
32.3 formattingin OneNote using stylesMicrosoft OneNoteusing styles to format notesOneNoteusing styles to format notesstylesin OneNoteUsing styles to format your notes;
32.4 Connecting OneNote to Outlook;
32.5 Connecting OneNote tasks to Outlook;
32.6 Using hyperlinks to tie your notes together;
32.7 Creating custom hyperlinks to other pages;
32.8 Creating and organizing tables;
32.9 Using the Insert Table feature;
32.10 Searching your notes to find information quickly;
32.11 Changing your search scope;
32.12 Key points;
Chapter 33: Sharing notes with others;
33.1 Creating a new notebook on SkyDrive;
33.2 Moving a notebook to SkyDrive;
33.3 Using a file server to share notes;
33.4 Sharing notes via SharePoint;
33.5 Sharing notes with others during a meeting;
33.6 Sending notes via email;
33.7 exportingOneNote to other formatsMicrosoft OneNoteexporting to other formatsOneNoteexporting to other formatsExporting to other formats;
33.8 Key points;
Chapter 34: Using OneNote everywhere;
34.1 Syncing your notes by using SkyDrive;
34.2 Accessing your notes in a web browser;
34.3 Using OneNote on your phone or tablet;
34.4 Using OneNote on an iPhone or iPad;
34.5 Using OneNote Mobile for Android;
34.6 Using OneNote Mobile on a Windows Phone;
34.7 Using OneNote with a Windows 8 tablet;
34.8 Key points;
Chapter 35: Saving time with OneNote;
35.1 Finding tags;
35.2 Recording audio;
35.3 Using Quick Notes;
35.4 Using screen clipping;
35.5 Using linked notes;
35.6 Searching your images;
35.7 Inserting a spreadsheet;
35.8 Using the Napkin Math feature;
35.9 Formatting with templates;
35.10 Key points;
Access 2013;
Chapter 36: Getting comfortable in Access 2013;
36.1 Starting Access 2013;
36.2 Looking at the desktop database window;
36.3 Exploring the Web App window;
36.4 Displaying results in a browser;
36.5 Discovering what’s new in Access 2013;
36.6 Key points;
Chapter 37: Understanding Access 2013 databases;
37.1 Creating a desktop database;
37.2 Importing and exporting data;
37.3 Navigating the user interface;
37.4 Working with data in a datasheet;
37.5 Copying and pasting from a datasheet;
37.6 Configuring Access options;
37.7 Linking Access to external data;
37.8 Compacting, repairing, and encrypting a database;
37.9 Key points;
Chapter 38: Creating basic tables and queries;
38.1 Creating tables for your data;
38.2 Adding validation and calculated fields to your tables;
38.3 Linking tables together with relationships;
38.4 Creating a select query;
38.5 Working with query criteria;
38.6 Adding parameters to queries;
38.7 Working with totals and crosstab queries;
38.8 Key points;
Chapter 39: Designing forms and reports;
39.1 Creating a continuous form;
39.2 Creating a single record form;
39.3 Creating a parent/child form;
39.4 Tying your forms together with a navigation form;
39.5 Creating a single record report;
39.6 Creating a tabular report with grouping;
39.7 Creating a parent/child report;
39.8 Key points;
Chapter 40: Creating and sharing a Web App;
40.1 Signing in to Office 365;
40.2 Creating a blank Web App;
40.3 Opening an existing Web App;
40.4 Importing data from a spreadsheet;
40.5 Importing data from an Access desktop database;
40.6 Navigating a Web App with the table selector;
40.7 Navigating a Web App with the Navigation pane;
40.8 Launching a Web App;
40.9 Opening a database in Access from Team Site;
40.10 Working with views;
40.11 Working with a Datasheet view;
40.12 Working with a List Details view;
40.13 Adding a new blank table;
40.14 Creating a lookup;
40.15 Creating a summary view;
40.16 Creating a Web App from a template;
40.17 Key points;
Publisher 2013;
Chapter 41: Getting comfortable in Publisher 2013;
41.1 Exploring the Publisher 2013 user interface;
41.2 Discovering what’s new in Publisher 2013;
41.3 Key points;
Chapter 42: Creating publications;
42.1 Using templates to create publications;
42.2 Adding elements into your publications;
42.3 Adding business information to publications;
42.4 Customizing the page design of a publication;
42.5 Customizing text font, color, and style;
42.6 Working with WordArt, text effects, and stylistic sets;
42.7 Using picture placeholders and captions;
42.8 Importing, swapping, and formatting pictures;
42.9 Working with rulers, guides, baselines, and other tools;
42.10 Importing Word documents into Publisher;
42.11 Key points;
Chapter 43: Saving, sharing, and exporting publications;
43.1 Saving your publications;
43.2 Sharing publications via email;
43.3 Printing your publications;
43.4 Saving for photo printing or commercial printing;
43.5 Exporting publications to PDF or XPS format;
43.6 Key points;
About the authors;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)