Screenshots offer step-by-step instructions for tackling over two hundred Microsoft Office 2013 tasks, including creating presentations, databases, spreadsheets, and text files.

Includes index.

pt. I. Office features. 1. Office basics : Start and exit office applications ; Navigate the program windows ; Work with backstage view ; Work with the ribbon ; Customize the quick access toolbar ; Using an Office program on a tablet PC -- 2. Working with files : Create a new file ; Save a file ; Open a file ; Print a file ; Check your file for hidden or personal data ; E-mail a file ; Select data ; Cut, copy, and paste data ; Arrange windows -- 3. Office graphics tools : Insert a picture ; Insert an online picture ; Resize and move graphic objects ; Understanding graphic object modification techniques -- 4. Working with Office files online : Office and the cloud ; Sign in to Office online ; Share a document from Office ; Download apps from the Office store ; Sign in to SkyDrive ; Using a web app in SkyDrive ; Using an Office program from SkyDrive ; Upload a document to SkyDrive ; Share a document using SkyDrive -- pt. II. Word. 5. Adding text : Change Word's views ; Type and edit text ; Insert quick parts ; Insert symbols ; Creat a blog post -- 6. Formatting text : Change the font, size, and color ; Align text ; Set line spacing ; Indent text ; Set tabs ; Set margins ; Create lists ; Copy formatting ; Clear formatting ; Format with style ; Apply a template -- 7. Adding extra touches : Insert an online video ; Assign a theme ; Add borders ; Create columns ; Insert a table ; Apply table styles ; Insert an Excel spreadsheet ; Adding headers and footers ; Insert footnotes and endnotes ; Insert page numbers and page breaks ; Mark index entries ; Generate an index ; Generate a table of contents ; Create a bibliography -- 8. Reviewing documents : Work in read mode view ; Find and replace text ; Scan document content ; Check spelling and grammar ; Work with AutoCorrect ; Using Word's thesaurus and dictionary ; Translate text ; Track and review document changes ; Lock and unlock tracking ; Combine reviewers' comments ; Work with comments -- pt. III. Excel. 9. Building spreadsheets : Enter cell data ; Select cells ; Faster data entry with AutoFill ; Turn on text wrapping ; Center data across columns ; Adjust cell alignment ; Change the font and size ; Change number formats ; Increase or decrease decimals ; Add cell borders and shading ; Format data with styles ; Apply conditional formatting ; Add columns and rows ; Resize columns and rows ; Freeze column and row titles on-screen ; Name a range ; Clear or delete cells ; Split and format a column of data -- 10. Worksheet basics : Add a worksheet ; Name a worksheet ; Change page setup options ; Move and copy worksheets ; Delete a worksheet ; Find and replace data ; Creat a table ; Filter or sort table information ; Analyze data quickly ; Understanding data analysis choices ; Track and review worksheet changes ; Insert a comment -- 11. Working with formulas and functions : Understanding formulas ; Create a formula ; Apply absolute and relative cell references ; Understanding functions ; Apply a function ; Total cells with AutoSum ; Audit a worksheet for errors ; Add a watch window -- 12. Working with charts : Creat a chart ; Move and resize charts ; Change the chart type ; Change the chart style ; change the chart layout ; Add chart elements ; Format chart objects ; Change the chart data ; Using Sparklines to view data trends -- pt. IV. PowerPoint. 13. Creating a presentation : Build a blank presentation ; Create a presentation using a template ; Create a photo album presentation ; Change PowerPoint views ; Insert slides ; Change the slide layout ; Change the slide size -- 14. Populating presentation slides : Add and edit slide text ; Change the font, size, and color ; Apply a theme ; Set line spacing ; Align text ; Add a text box to a slide ; Add a table to a slide ; Add a chart to a slide ; Add a video clip to a slide ; Move a slide object ; Resize a slide object -- 15. Assembling and presenting a slide show : Reorganize slides ; Reuse a slide ; Organize slides into sections ; Define slide transitions ; Add animation effects ; Create a custom animation ; Record narration ; Insert a background song ; Create speaker notes ; Rehearse a slide show ; Run a slide show ; Review a presentation ; Package your presentation on a CD ; Present online -- pt. V. Access. 16. Database basics : Understanding database basics ; Create a database based on a template ; Create a blank database ; Create a new table ; Change table views ; Add a field to a table ; Delete a field from a table ; Hide a field in a table ; Move a field in a table ; Create a form ; Change form views ; Move a field in a form ; Delete a field in a form ; Apply a database theme ; Format form fields ; Add a background image -- 17. Adding, finding, and querying data : Add a record to a table ; Add a record to a form ; Navigate records in a form ; Search for a record in a form ; Delete a record from a table ; Delete a record from a form ; Sort records ; Filter records ; Apply conditional formatting ; Perform a simple query ; Create a report -- pt. VI. Outlook. 18. Organizing with Outlook : Navigate in Outlook ; Schedule an appointment ; Create a new contact ; Create a new task ; Add a note ; Customize the navigation bar ; Peek at appointments and tasks ; Search for Outlook items ; Work with the to-do bar ; Link contacts -- 19. E-mailing with Outlook : Compose and send a message ; Send a file attachment ; Read an incoming message ; Reply to or forward a message ; Add a sender to your Outlook contacts ; Delete a message ; Work with conversations ; Screen junk e-mail ; Create a message rule -- pt. VII. Publisher. 20. Publisher basics : Create a publication ; Zoom in and out ; Add text ; Add a new text box ; Swap pictures ; Save a publication for photo center printing -- 21. Fine-tuning a publication : Change the font, size, and color ; Apply a text effect ; Change text alignment ; Add a border ; Control text wrap ; Link text boxes ; Move and resize publication objects ; Edit the background ; Add a building block object ; Create a building block object -- pt. VIII. OneNote. 22. Taking notes with OneNote : Navigate OneNote ; Type and draw notes ; Insert and format a table ; Attach files to notes ; Send information to OneNote ; Insert a screen clipping ; Create a quick note ; Record an audio note -- 23. Organizing and sharing notes : Create a new notebook ; Create a new section ; Create a new page ; Rename a section or page ; Group sections ; Search notes ; Search for recent edits ; Set synchronization options ; Share notes with people who do not have OneNote.