|
Published:
March 4, 2013

Office 2013 All-in-One For Dummies

Overview

Home and business users around the globe turn to Microsoft Office and its core applications every day. Whether you're a newcomer or a veteran Office user, this friendly-but-informative guide provides in-depth coverage on all the newest updates and enhancements to the Office 2013 suite. With an overview of tools common to all Office applications and self-contained minibooks devoted to each Office application, Office 2013 All-in-One For Dummies gets you up to speed and answers the questions you'll have down the road.

  • Explores the

new Office interface and explains how it works across the applications

  • Features eight minibooks that cover Word, Excel, PowerPoint, Outlook, Access, Publisher, OneNote, common Office tools, and ways to expand Office productivity
  • Highlights the new online versions of Word, Excel, and PowerPoint as well as changes to the interface and new tools and techniques
  • Office 2013 All-in-One For Dummies makes it easy to learn to use Office and gets you up and running on all the changes and enhancements in Office 2013.

    Read More

    About The Author

    Peter Weverka is a veteran For Dummies author who has written about a wide variety of applications. Along with two bestselling editions of Office All-in-One For Dummies, Peter has written PowerPoint All-in-One For Dummies and Microsoft Money For Dummies.

    Sample Chapters

    office 2013 all-in-one for dummies

    CHEAT SHEET

    The programs in the Office 2013 suite — Word 2013, Excel 2013, PowerPoint 2013, OneNote 2013, Outlook 2013, Access 2013, and Publisher 2013 — have much in common. Master the commands in one Office 2013 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2013 program you are working in.

    HAVE THIS BOOK?

    Articles from
    the book

    Word 2013 documents, Excel 2013 worksheets, PowerPoint 2013 slides, OneNote 2013 notebooks, Outlook 2013 messages, and Publisher 2013 publications are much more attractive and communicate more when you include visual elements. Office 2013 offers commands for creating these visual elements: Charts: A chart is an excellent way to present data for comparison purposes.
    Office 2013 has made customizing programs easier than ever. Whether you’re working in Word 2013, Excel 2013, PowerPoint 2013, OneNote 2013, Outlook 2013, Access 2013, or Publisher 2013, you can take advantage of these customization techniques: Quick Access toolbar: Located in the upper-left corner of the screen, the Quick Access toolbar is always there.
    Word 2013 offers a command for comparing the original document to a revised edition and another for comparing two different revised editions of the same document. After you make the comparison, Word creates a third document showing the changes and who made them.On the Review tab, click the Compare button.You see a drop-down list.
    Outlook 2013 lets you earmark messages and even move messages as they arrive automatically to folders apart from the Inbox folder. You create a rule to move e-mail from a particular person automatically to a folder or be alerted when e-mail arrives from a certain person or the Subject line of a message includes a certain word.
    It’s easier to enter data in a form than in an Access data sheet. Therefore, you probably will need to create a form within Access 2013. Here's how.Go to the Create tab and click the Form Wizard button.You see the first of several Form Wizard dialog boxes. Answer these questions and keep clicking the Next button until the time comes to click Finish: Tables/Queries: From the drop-down list, choose the name of the database table you need to enter data in.
    By establishing data-validation rules in Excel 2013, you can greatly decrease the chances of errors being entered, and the rules aren’t particularly hard to set up.Select the cell or cells that need a rule and then click Data Validation on the Data tab of the Ribbon.Select the cell or cells that need a rule. You see the Settings tab of the Data Validation dialog box.
    In Excel 2013, you can insert and delete individual cells or even ranges that don’t neatly correspond to entire rows or columns. When you do so, the surrounding cells shift. In the case of an insertion, cells move down or to the right of the area where the new cells are being inserted. In the case of a deletion, cells move up or to the left to fill in the voided space.
    You can play a PowerPoint 2013 presentation on your computer for people to watch on their web browsers. Presenting online is made possible by the Office Presentation Service, a free service for everyone who has Office software and a Microsoft Account, which is also free. The Office Presentation service creates a temporary web address for you to show your presentation.
    If your computer can record sound, you can make a voice recording of a note in OneNote 2013. The note is stored as a Windows media audio file (.wma).On the Insert tab or (Audio & Video) Playback tab, click the Record Audio button.You go immediately to the (Audio & Video) Playback tab (if you weren’t there already), and OneNote begins recording.
    Pictures can be messy. You may have a picture that you’d like to use in an Office 2013 document, but the picture has a distracting background (or even someone you’d like to forget). Fortunately, Office 2013 provides simple tools that can help you remove a background you don’t want.On the (Picture Tools) Format tab, click the Remove Background button.
    PDF files are designed to be viewed and printed in a program called Adobe Reader. Nearly every computer has Adobe Reader, which is why it is sometimes convenient to save your Office 2013 files as PDFs. If someone to whom you sent a PDF file doesn’t have the program, they can download it for free at.Go to the File tab and choose Export.
    You can collaborate with others by sharing your Office 2013 files and folders. Sharing enables them to view or edit your work and provide valuable feedback (or just enjoy your vacation memories).In SkyDrive, select the file or folder you want to share.You can also start by opening the Office file you want to share.
    The programs in the Office 2013 suite — Word 2013, Excel 2013, PowerPoint 2013, OneNote 2013, Outlook 2013, Access 2013, and Publisher 2013 — have these indispensable commands in common: Undo: Don’t despair if you give a command and then realize that you shouldn’t have done that. You can undo your mistake by clicking the Undo button (or pressing Ctrl+Z).
    The programs in the Office 2013 suite — Word 2013, Excel 2013, PowerPoint 2013, OneNote 2013, Outlook 2013, Access 2013, and Publisher 2013 — have much in common. Master the commands in one Office 2013 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2013 program you are working in.
    https://cdn.prod.website-files.com/6630d85d73068bc09c7c436c/69195ee32d5c606051d9f433_4.%20All%20For%20You.mp3

    Frequently Asked Questions

    No items found.