Office Articles
How to Write an IF Formula/Statement in Excel
May 22nd, 2012 by Aseem Kishore
Essential if you are dealing with numbers
Outlook Autocomplete Not Working or Resetting?
May 13th, 2012 by Aseem Kishore
We found 5 methods to fix this
Fix MS Office “Cannot Verify License” Error Message
Apr 20th, 2012 by Aseem Kishore
This solution works with any version
Fix “Cannot Start Microsoft Office Outlook” Error
Without pulling all of your hair out
I recently ran into a problem when using Microsoft Outlook on my laptop. It’s got Windows 7 and I am using Office 2010 at the moment. I went to open […]
Show/Hide Field Codes in Word and Convert Fields to Text
Helpful tools when working with data
If you have a lot of field codes in your Word document that you are not going to be updating, you may want to convert them to plain text. To […]
Check All Hyperlinks in a MS Word Document in Seconds
Dead links can be very embarrassing
When writing a long term paper, company manual, or other long document in Word, it is almost impossible to avoid inserting hyperlinks. Hyperlinks to relevant Web pages can make a […]
How to Customize Word’s Paste Function
Especially handy if you are importing or exporting text
One of the most common things computer user’s do is cut, copy and paste stuff. When you’re cutting or copying from one place in a document to another, there’s not […]
Make OpenOffice Writer Look and Function More Like Microsoft Word
Enjoy using this free tool that much more
Microsoft Word not only rules the roost when it comes to word processing, the software giant has pushed most of its competitors out of the market. OpenOffice Writer, however, is […]
Using Excel’s What-If Analysis Goal Seek Tool
Lets you work backwards to get the desired cell output
Although Excel’s long list of functions is one of the most enticing features of Microsoft’s spreadsheet application, there a few underutilized gems that enhance these functions. One often-overlooked tool is […]
Viewing and Inserting the Date a Document was Last Modified in a Word Document
Especially helpful when working with others
Each document you create in Word contains information about the document or Properties, such as the date the file was created, the author of the document, and the number of […]
Insert a Bullet in the Middle of a Sentence in Word
You may want to use it for design or emphasis
There may be times when you want to insert a bullet in the middle of a sentence or a line of text. For example, you might want to put bullets […]
Group Rows and Columns in an Excel Worksheet
Makes working with them so much easier
Excel is one of the applications in the Office suite that is equally useful in the workplace and in a home or home office. Excel is capable of storing great […]
Quickly Spell Out Numbers in Word and Excel
It's less stress on the brain
If you use a lot of numbers in Word documents and want to be able to quickly spell them out, there is an add-in for Word that allows you to […]
How to Create PDF Documents in Microsoft Office
Different methods, depending on your version
Do you need to distribute your Microsoft Office files as PDF documents often? Depending on which version of Office you have, there are different ways to save your document as […]
Change the Default Margins Used in New Word Documents
Give them your own special look
If you use the same margins in most of your Word documents, you can set default margins once to be used for every new Word document you create. This post […]
Hide Confidential Data in a Word 2007/2010 Document
Prevents redacted text from being revealed
When sharing a Word 2007 document, you may need to delete or hide confidential information. You can search for the data and remove it manually, but this can be error […]
Sum a Table Column in Word
Plus insert more complex formulas
Word allows you to calculate the sum of a column in a table, just like you would in a spreadsheet program like Excel. This post will show you how to […]
Preserve Cell References when Copying a Formula in Excel
Handy if you want to display a total elsewhere
When you copy a cell containing a formula, you will notice that the cell references in the formula also move a corresponding number of cells across and down. This type […]
How to Repair Any Version of Microsoft Office
Fixes most Office problems in a jiffy
All versions of Office can be repaired in the same way using the Programs and Features tool in the Control Panel. To do this, click Control Panel on the Start […]
Paste Text into Word Without Formatting
Easier than reformatting or pasting into Notepad first
By default, Microsoft Word tries to preserve the styles of text copied from a source outside of Word. If you don’t want to have to manually remove the style information […]