Office 2013 allows you to add useful apps directly to Word, Excel, etc.. By apps, generally we mean research resources such as dictionaries for defining terms or accessing sites such as Wikipedia directly within Office programs to confirm facts.
If you use Outlook for your email and calendar, but also use Google Calendar (say one for business and one for personal), you can easily add your Google Calendar to Outlook so you can view all your calendars in one place.
When sending email, you might want to know that your message has been delivered (delivery receipt) and you might want to know whether the message was opened (read receipt). You can request one or both types of receipts easily in Outlook 2013.
If you write a lot of legal documents or other types of documents in which you need to reference specific sections, adding line numbers can be useful. We will show you how to add unobtrusive line numbers in the left margin of a Word document.
There may be times when you want to change the direction of text in Word. This is easily done using text boxes or shapes or using cells in a table. We will show you both methods for changing the direction of text.
If you’re working on a long document in Word, you’ll probably be opening it often until it’s completed. Rather than opening Word to the general start screen, and then opening the file, you can automatically open the last document you were working on.
In Word 2013, you can select one of several units of measurement for the ruler. You may be working on a document for someone who measures their margins, tabs, etc. in a different set of units than you usually use. It’s easy to change.
By default, Word automatically saves your document at certain intervals. If you’re concerned about losing data, you can decrease the interval. If you’re distracted by the hard drive crunching too often, you can increase the interval. Either way, changing this interval is easy.
When you open an Office 2013 program, a start screen automatically displays showing you the various templates available and a list of recent documents opened in the left column. If you find this screen annoying and would rather pass it by, it’s easy to disable.
There may be times you want to remove a row or column from a spreadsheet, but you don’t want to permanently delete it from the worksheet file. Excel has a feature that allows you to temporarily hide a row or column from view.
If you’ve copied text from another document and it’s not formatted the way you want, or it has some strange or mixed up formatting, you can easily remove all the formatting from the text and return the text to the default style.
Have you entered some text in columns separated by tabs and you want to convert it to a table? Word provides a useful feature that allows you to quickly convert text to a table and a table to text.
Jumping to a specific page in Word is a common task and easy to do using the Find and Replace dialog box. You can also use this same tab to jump from one table directly to the next table in your document.
The Auto-Complete feature in Outlook 2013 automatically fills in names and email addresses for you when entering them in the To or Cc fields. Based on the characters you start to enter, Outlook displays a list of possible choices that match what you’ve entered.
If you are working on a large spreadsheet where all the rows and columns of data don’t fit on the screen, it would be helpful to be able to keep the heading rows and columns stationary so you can scroll through the data.
If you’re writing a long Word document containing a lot of images, you may want to add captions to those images. You can then reference the images by their number in the text as well as generate a Table of Figures.
If you’re working in Word and you need to total values in a table, you can do so without having to enter the data into Excel and then copy and paste it into Word. Word can do simple calculations such as summing, multiplying, and averaging.
You may find you need to change multiple cells from one case to another in Excel. Maybe you imported data that came in all upper case, or maybe you convert headings on columns to upper case. Changing case is easy using some special functions.
RSS stands for “Really Simple Syndication” or “Rich Site Summary.” It’s a document specification that allows you to easily collect and organize web-based news and information from websites in a standardized format commonly called a feed, which is like a bookmark that actively updates itself.
The Common Feed List is a list of subscribed RSS Feeds that is saved with your Windows user profile. RSS clients, including Windows Internet Explorer and Outlook, use this list allowing you to configure your RSS subscriptions in one location for multiple readers.
Have you switched to Microsoft Word from WordPerfect? Do you remember the Reveal Codes feature in WordPerfect that made it so easy to see exactly how your document was formatted? Well, you can get that feature now in Word using a free tool called CrossEyes.
When you open an Excel worksheet or change any entries or formulas in the worksheet, Excel automatically recalculates all the formulas in that worksheet by default. This can take a while if your worksheet is large and contains many formulas.
We’ve previously shown you how to add keyboard shortcuts to symbols in Word 2013 to make it easier to insert them into your documents. Keyboard shortcuts can be added to symbols in Excel as well, but there’s no direct method.