|
Published:
June 20, 2016

Office 2016 For Dummies

Overview

Office 2016 For Dummies (9781119293477) was previously published as Office 2016 For Dummies (9781119077374). While this version features a new Dummies cover and design, the content is the same as the prior release and should not be considered a new or updated product.

The bestselling Microsoft Office book of all time

Packed with straightforward, friendly instruction, this updated edition of the bestselling Microsoft Office book gets you thoroughly up to speed on the latest version of the industry standard for office productivity suites. In no time, Office 2016 For Dummies will help you become a whiz at Word, take your Excel skills to new heights, add pizzazz to your PowerPoint presentations, and make every part of your work day more organized and productive.

Following alongside approachable, plain-English explanations, you'll quickly discover how to type, format text, and design documents in Word; navigate and edit spreadsheets,

create formulas, and analyze data in Excel; configure email, store contacts, organize tasks, and schedule your time with Outlook; create and edit well-designed and crowd-pleasing PowerPoint presentations; and design, edit, and modify an Access database. Even if the mere thought of working with Microsoft Office makes you nervous, this fun and friendly guide makes it easy.

  • Helps you make sense of word processing, email, presentations, data management and analysis, and much more
  • Covers the five main Office applications: Word, Excel, PowerPoint, Outlook, and Access
  • Walks you through the new features of Microsoft Office 2016
  • Written by a veteran author who has written more than 20 For Dummies books, which account for more than three million books in print

If you're an uninitiated user looking to make the most of this powerful suite of applications, this hands-on, friendly guide is the key to your brand new Office!

Read More

About The Author

Wallace Wang specializes in making complex topics understandable. His assorted For Dummies tech books have sold nearly half a million copies. He has a master’s degree in computer science along with side hustles in stand-up comedy and screenwriting because life is too short to focus on just one thing.

Sample Chapters

office 2016 for dummies

CHEAT SHEET

Microsoft Office 2016 comes jam-packed with features. See shortcuts and tips for using the keyboard, mouse, and ribbon to get fast access to the most commonly used commands. You’ll master Office 2016 in no time!

HAVE THIS BOOK?

Articles from
the book

One common theme of Office 2016 is that all programs look and work alike. After you learn how to use Word, you'll find it isn't much harder to learn Excel or PowerPoint because the Ribbon tabs all work in similar ways. Even better, the same keystroke commands work alike in all Office 2016 programs. By memorizing keystroke shortcuts, you'll be able to work faster and more efficiently with Office 2016, no matter which particular program you may be using at the time.
Some people love the Ribbon interface of Office 2016, while others only tolerate it. No matter what your feelings toward the Ribbon interface may be, you can customize which icons appear on it so it only displays those features you need (and use) most often. To customize the Ribbon interface, follow these steps: Load an Office 2016 program, such as Word or Excel.
When you display a PowerPoint presentation, your slides typically appear in the order that you arranged them, starting with the first slide. If you want to display your slides in a different order in the middle of a presentation, follow these steps: Load your presentation in PowerPoint and press F5. The first slide of your presentation appears.
Office 2016 programs come with two ways of getting help: the help window and the Tell Me What You Want to Do text box. This video discusses how to learn about a command with the Help window and how to see a command in action with the The Tell Me What You Want to Do text box.
One problem with creating large spreadsheets in Excel is that your identifying row and column headings may scroll out of sight if you scroll down or to the right of your worksheet. To prevent this from happening, you can "freeze" a row or column that contains identifying labels. That way, when you scroll through your worksheet, your frozen row or column always remains visible.
To keep your files as safe as possible from malicious viruses, you'll want to check out the Trust Center. This video explains how to get to the Trust Center and the level of protections you can enable.
Macro viruses are malicious programs designed to attach themselves to Word, Excel, and PowerPoint files. When an unsuspecting victim opens an infected file, the virus can spread and do something nasty, such as deleting your files or the entire contents of your hard drive. To stop these pests from wrecking your files, get an antivirus program, avoid downloading or accepting any files from unknown people, and turn on Office 2016's built-in macro-protection feature, which can disable macros or restrict what macro viruses and worms can do even if they infect your computer.
Microsoft Office 2016 runs on Windows 10, Windows 8, or Windows 7. The process to start an Office 2016 application depends on your Windows version. The following discussion shows how to use each compatible Windows version. If you're using an older version of Windows (such as Vista or XP), you can't install, let alone run and use, Microsoft Office 2016.
Every Office 2016 application can retrieve images from the Internet (if your computer has Internet access). To retrieve an image from the Internet, follow these steps: Click the Insert tab. Click the Online Pictures icon. An Insert Pictures dialog box appears, as shown here. The Insert Pictures dialog box lets you search for images using Bing.
For a fast way to find the commands you need, Office 2016 displays a "Tell me what you want to do. . ." text box in the middle top of the window, as shown here. The "Tell me what you want to do…" text box. The Office 2016 Help window can show you what steps to take, but you still need to find the right commands to use, which is where "Tell me.
Microsoft Office 2016 comes jam-packed with features. See shortcuts and tips for using the keyboard, mouse, and ribbon to get fast access to the most commonly used commands. You’ll master Office 2016 in no time!
Microsoft Office 2016 provides hundreds of commands, but you’ll likely only use a handful of those commands on a regular basis. To save time, use these Office 2016 keyboard shortcuts. With little effort, you can open files, find content, edit that content, and more! Function Keystroke Copy Ctrl+C Cut Ctrl+X F
You can control Microsoft Office 2016 with your mouse or your keyboard. The mouse actions in this table work whether you’re using Word, Excel, Access, PowerPoint, or Outlook. Mouse Button Used Action Purpose Left mouse button Click Moves the cursor, highlights an object, pulls down a menu, or chooses a menu c
Microsoft Office 2016 displays commands in a series of icons stored on different tabs. This combination of icons and tabs is known as the Ribbon interface, which appears in Word, PowerPoint, Excel, Outlook, and Access. The following tables show the commands grouped under each ribbon tab for each of the five programs.
To prevent prying eyes from peeking at your Word, Excel, or PowerPoint files, you can password-protect them. That way, if someone wants to open, view, or edit your files, they must use your password. If they don't know your password, they won't be able to view your files. To password-protect a file, follow these steps: Load Word, Excel, or PowerPoint.
If you have an email account, you will get spam — that unwanted email that clogs millions of inboxes every day with obnoxious offers for mortgage refinancing, low-cost prescription drugs, or celebrity pornography. Unless you actually enjoy deleting these messages manually, you can use Outlook to filter your email for you.
Most people dump their documents inside a folder in the Documents folder. Store too many documents in this folder, however, and you'll find it's nearly impossible to find anything. To make retrieving files easier, it's a good idea to store different data in different folders, such as storing tax-related information in a special Tax Returns folder or invoices in a special 2017 Invoices folder.
If you find something useful (or useless) in Office 2016, you can send feedback directly to Microsoft. If enough people like (or complain about) the same item, Microsoft may modify future versions of Office to make the program easier to use. To send a compliment or a complaint to Microsoft, follow these steps: Load an Office 2016 program, such as Word or Excel.
You'll want to be confident when saving files; you don't want to wonder later where your file is or even if it saved correctly. This video discusses how to designate a default location for your files, define a default format for Office 2016 programs, and set an autorecovery time.
https://cdn.prod.website-files.com/6630d85d73068bc09c7c436c/69195ee32d5c606051d9f433_4.%20All%20For%20You.mp3

Frequently Asked Questions

No items found.