Chapter 20
If you haven’t noticed by now, there are plenty of features buried in Office 2016 that you probably don’t need most of the time. However, if you’re a die-hard Office 2016 power user, you may want to peek at some of the more advanced features buried inside the operating system.
Although these advanced features may take time to learn and master, you may find the effort worth it to make Office 2016 behave exactly the way you want it to. Best of all, you can learn these new features by playing with them at work — so that way, you can learn something new and get paid for doing it at the same time.
If you’re like most people, you probably just want to use a program, make it do what you need it to do, and then go home afterwards. However, if you find yourself wishing Office 2016 could do something more, then you may want to take some time to develop your own apps for Office 2016.
To create apps for Office 2016, you just need to use industry-standard programming languages like HTML5, JavaScript, CSS3 (Cascading Style Sheets), and XML. By creating your own Office 2016 apps, you can extend Office 2016’s capabilities. If you create a particularly useful app, you can even sell or give it away to others. To learn more about creating your own Office 2016 apps, visit the Microsoft site (http://msdn.microsoft.com/en-us/office/apps
) that provides a brief tutorial on how to create your first Office 2016 app.
If you don’t want to create your own Office apps, click the Insert tab and click the Store icon. Now you can browse through Office add-ins that other people have created for use (for free or for a price). By downloading and installing Office add-ins, you can boost the capabilities of Office.
If you’re the only person who needs to edit, view, and use your Office 2016 documents, you can safely skip over this section. However, if you’re like many people, you need to collaborate with others.
The old-fashioned way of collaborating meant printing paper copies, sending them to others, and writing directly on them, but with Office, you can highlight, mark up, and edit documents electronically so that you can distribute files by email or through a network. Each time someone makes a change to a document, Office 2016 tracks these changes with a different color and even identifies the contributor by name. Now you can see who wrote what, and you can selectively keep those comments that are most valuable and ignore the ones you don’t like.
Some of the more useful commands hidden on the Review tab include
By using the features stored on the Review tab, you can send multiple copies of a file to others, let everyone make comments, mark up the text, move data around, and then merge everyone’s comments and changes into a single, final version.
Most people use Word just to write letters or short reports. If you need to create longer documents, then you may be interested in using the features buried on Word’s References tab, such as
Most people type data directly into an Excel worksheet and then manipulate that data through formulas or other commands. However, you can also design a worksheet and then import data from another location (such as stock quotes that you retrieve from a website), from a text file, from an Access database, or even from a database file created by another program (such as an ancient dBASE database).
Some of the features available from the Get External Data icon on Excel’s Data tab include:
The traditional way to send a file to someone is to save your file, load your email program (such as Outlook), create a new message, attach your file (if you can remember where you stored it), and send it over the Internet.
Here’s a faster way to send a file:
Click Share.
The Share window appears.
After creating a file, you may want to show it to others, but not let anyone else modify it. You could trust that nobody will mess up your file, but a better option is to password-protect it so nobody can modify it without your permission.
To password-protect a file, follow these steps:
Click Info and then click the Protect button (such as Protect Document or Protect Presentation).
A menu appears.
Click Encrypt with Password.
An Encrypt Document dialog box appears.
In the old days, everyone saved files directly on their computer’s hard disk. While this worked, it had problems. If you took a laptop but forgot to copy a crucial file off your desktop, your laptop would be essentially useless.
That’s why Microsoft offers OneDrive, their cloud-based service that lets you save files over the Internet to your OneDrive account. Once you save a file on OneDrive, you can access that file from any computer that has access to the Internet.
That means you can store crucial files on OneDrive from your desktop PC, then take a laptop and access that same file on OneDrive. Now, instead of having two copies of a file (one on your desktop and one on your laptop), you just have one file on OneDrive. This eliminates the need to keep track of multiple copies of the same file.
Storing files on OneDrive has another advantage in that it allows multiple collaboration on the same file. That means you might be in Berlin while your co-worker is in Tokyo and you can both access and edit the same file on OneDrive. By saving files to OneDrive, you can access them at any time and share them with others as well.
To save a file on OneDrive, follow these steps:
Click Save As.
A menu appears.
Although the Office Ribbon represents a more visual way to use Microsoft Office, some people still prefer the classic pull-down menu interface of previous versions of Microsoft Office. Those who don’t want to give up their familiarity with pull-down menus can buy an add-on program dubbed Classic Menu for Office (which is available at www.addintools.com
).
This program essentially gives back your pull-down menus so you can choose between the Office Ribbon and traditional pull-down menus. Now you can have the best of both worlds without giving up either one.
The main drawback with this add-on program is that if you have to use someone else’s copy of Office 2016 that doesn’t have this add-on installed, you may feel lost trying to use the Ribbon alone. For this reason, it’s a good idea to become familiar with the Office Ribbon and use this Classic Menu for Office add-on program to help you make the transition from an older version of Office to Office 2016.
3.135.183.149