Chapter 20
If you haven’t noticed by now, plenty of features are buried in Office 2019 that you probably don’t need most of the time. However, if you’re a die-hard Office 2019 power user, you may want to peek at some of the more advanced features available to make your life easier.
Although these advanced features may take time to learn and master, you may find the effort worth it to make Office 2019 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. However, if you find yourself wishing Office 2019 could do something more, you may want to take some time to develop your own apps for Office 2019.
To create apps for Office 2019, you need to use industry-standard programming languages such as HTML5, JavaScript, CSS3 (Cascading Style Sheets), and XML. By creating your own Office 2019 apps, you can extend Office 2019’s capabilities. If you create a particularly useful app, you can even sell it or give it away. To learn more about creating your own Office 2019 apps, view the brief tutorial on how to create your first Office 2019 app: http://msdn.microsoft.com/en-us/office/apps
).
If you don't want to create your own Office apps, click the Insert tab and then 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 2019 documents, you can safely skip 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. 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 2019 tracks the changes with a different color and identifies the contributor by name. Now you can see who wrote what, and you can selectively keep the comments that are most valuable and ignore the ones you don’t like.
Some of the more useful commands hidden on the Review tab are
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, you may be interested in using some of the following the features buried on Word’s References tab:
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), a text file, an Access database, or even a database file created by another program (such as an ancient dBASE database).
Following are some of the features available from the Get External Data icon on Excel’s Data tab:
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. Although this method 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. After you save a file on OneDrive, you can access that file from any computer that has access to the Internet. So, for example, you can store crucial files on OneDrive from your desktop PC, and then take a laptop and access the same files 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. If you are in Berlin and your co-worker is in Tokyo, 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, 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 2019 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 2019.
Templates help you create well-designed and professionally formatted documents quickly and easily. Programs such as Word, Excel, PowerPoint, and Access offer plenty of templates to choose from, but those aren’t the only templates you can find and use.
Microsoft offers an online list of templates (https://templates.office.com
), and many companies offer unique templates as well. Avery, a popular mailing label company, provides templates designed for printing mailing labels, business cards, and other specialized documents (www.avery.com/templates
).
If you search for Microsoft Office templates in your favorite search engine, you’ll likely find many companies offering Microsoft Office templates that you can download and use free.
When you use OneDrive, you can access your files from any computer. For greater versatility, consider using Office 365, Office for Android, or Office for iOS.
Office 365 runs entirely within your browser, which means you can use any computer that can connect to the Internet, such as a Linux PC or a Chromebook, to create and edit Microsoft Office documents. If you want to use different types of computers and still use Microsoft Office, you’ll want Office 365.
Office for Android lets you run Word, Excel, PowerPoint, and Outlook on any Android smartphone or tablet. Office for iOS lets you run Word, Excel, PowerPoint, and Outlook on an iPhone or iPad.
With either Office for Android or Office for iOS, you can create and edit Microsoft Office documents on your favorite mobile computer. Now you’ll be able to use Microsoft Office wherever you go.