One of the more powerful, but seldom used functions of Excel is the ability to very easily create automated tasks and custom logic within macros. Macros provide an ideal way to save time on predictable, repetitive tasks as well as standardize document formats – many times without having to write a single line of code.
So you want to buy a tablet — you have a choice between the iPad, Android tablets, and now Windows 8 or Windows RT tablets. Windows tablets are often the most expensive. Software availability is crucial when using a tablet.
There may be times when you want to create a new Excel worksheet based on an existing worksheet. You can easily copy an entire worksheet in Excel to a new worksheet in the same file or even to a new, separate workbook file.
When entering formulas in Excel, you may want to remind yourself, or someone else, what it was for in the future. Or you may want to add instructions to let users of your spreadsheet know what to do in certain cells.
By default, Excel recalculates all the formulas in your worksheet automatically when you open your worksheet or change any entries, formulas, or names on which your formulas depend. If you worksheet is large, with many formulas, this can take several seconds or minutes.
Microsoft recently launched Office 2013 as well as Office 365, a subscription service. Office 365 will cost you $9.99 per month or $99 a year, while Office 2013 will cost you $219.99 for the Home and Business edition, which can only be used on one PC at a time.
Microsoft attempted to make typing appear smoother in Office 2013 by adding a typing animation feature. If you’re a slow typist, you probably won’t notice it. However, if you type upwards of 80+ words per minute, this feature can be distracting and annoying.
Previous versions of Excel have had an option for viewing two spreadsheets side-by-side. However, Excel 2013 now makes it easier by allowing you to snap each spreadsheet (opened in separate windows) to each side of the screen.
You can’t normally “undo” an email sent by mistake. Some email clients have undo-like features, such as the “Recall” feature in Microsoft Outlook, but these won’t work most of the time.
There are times, when working on an Office document, that you might forget where you saved the file. If you need to find out where the currently open document is located, you can use Save As to find out. However, there is a quicker way.
By default, when you use the save as… option to save e-mail messages and attachments in Outlook the items are saved in your My Documents folder. Here’s how to change that.
Recently, we showed you how to add a watermark to a document in Word 2013. You can also add a watermark to worksheets in Excel 2013; however, you must add them manually using the header and footer tools. We will show you how.
By default, when you paste text copied from elsewhere into Word 2013, you automatically get all the formatting with it. This formatting most likely does not match the rest of the content of your document and may not come in neatly.
In recent years it has become common for Microsoft to release trial or preview versions of its big-name products. This has been the case with Windows 8 as well as Office 2013 giving consumer the chance to try before they buy. If you downloaded the trial version of the suite, you can gain some extra try-out time with this handy hack.
A watermark is a faded, background image that displays behind the text in a document. It can be used to indicate a document’s status (confidential, draft, etc.) or to add a company logo. We’ll show you how to add watermarks to documents in Word 2013.
Office 2007 saw the addition of the Ribbon feature, which some users found confusing. However, you can use it to your advantage by adding your own custom tabs containing commands you use often. This allows for quicker and easier document creation.
The Mini Toolbar and Live Preview are features in Word introduced in Word 2007 and continued in Word 2010 and 2013. They can be useful for quick formatting and to preview possible formats. However, if these features annoy you, they are easy to disable.
If you have the option on for checking spelling as you type in Word 2013, you can easily add words to the custom dictionary, using the context menu. However, what if you want to add or delete many custom words, or even add specialized dictionaries?
When you open Word 2013, a list of recently opened documents displays on the left side of the screen. This list also displays when you select the Open option from within the program. If you would rather not see this list, it’s easy to disable.
There are plenty of articles about Google Reader alternatives, but did you know you can use your favorite email client to read your RSS feeds as well?
Word 2013 offers a new feature, called PDF Reflow, that allows you to import PDF files into Word and edit the text as a Word document. You can then resave or export the text as a PDF file.
When you install any recent version of Microsoft Office, Microsoft assumes that you want to sign up for the Customer Experience Improvement Program (CEIP). There’s a check box during installation that’s selected by default and automatically signs you up for the program.
Do you sometimes wish that you could use Microsoft Word’s more useful features, such as auto-complete, automatic spelling correction, and Autotext, in other programs in Windows? PhraseExpress is a free program that allows you to do just that.
We recently looked at how you can make it easier to manage multiple inboxes in Gmail using the Multiple Inboxes Lab feature. This is a non-standard feature and it’s far from being the only one available to you. In fact there are numerous hidden features that can help you to get more from Gmail.
If you have upgraded to Office 2013, or Office 365, you may have run into problems opening files that have been emailed to you. Try to open a Word file you have received as an email attachment and you are likely to find that Word not only refuses to open the files, but fails to provide much in the way of help.