Office Articles

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 […]

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 […]

I’ve previously written articles on Microsoft Office like how to fix the Word has stopped working error and how to fix the Outlook has encountered an problem error. There are […]

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 […]

There is a little known feature in word that allows you to gather groups of text and/or graphics from different locations in a Word document and then paste all of […]

If you never use desktop publishing programs such as Microsoft Publisher, Corel Draw, or Adobe InDesign, you may not be familiar with using objects and layers to create documents for […]

By default, Microsoft Word uses inches as its unit of measurement in dialog boxes and on the ruler. You can change measurement units to centimeters, picas, points, or millimeters. This […]

If you have created a small worksheet in Excel, you may want to center it on the page when you print it. By default, it will print in the upper, […]

Ever need to add some random or meaningless text into Microsoft Word to test a document, temporarily fill some space, or to see how some formatting looks? Luckily, Word provides […]

If you work extensively with Excel at home, at work, or in a home office, you have the luxury of setting up your worksheets exactly as you want them. However, […]

One often overlooked feature of Excel is the What-If Analysis tool that allows you to explore different scenarios without changing the values in your spreadsheet. This function is particularly useful […]

Sure Excel is used for spreadsheets, but did you know you can connect Excel to external data sources? In this article we’re going to discuss how to connect an Excel […]

I recently upgraded the version of Microsoft Office on my computer and learned that my spell checker was no longer working! Usually, it would automatically show me misspelled words immediately […]

Recently, I had a user in my office get the following errors when trying to open a Word document: Word cannot start the converter mswrd632.wpc. or Word cannot start the […]

I am a big fan of text-to-speech technology, mostly because it doesn’t work all that well.  However, sometimes it ends up being useful for certain situations. Excel is packed with […]

Just about every corporate email account is using Outlook and Exchange server to handle user email and there is an awful lot of data stored in those PST files. My […]

Working in a corporate environment as an IT support technician always means you’ll end up dealing with weird problems that would never occur on a normal consumer PC. Why? Well, […]