Archive | Microsoft Office RSS feed for this section

Change AutoRecover Interval in Office 2010

AutoRecover is a cool feature built into Microsoft Office that will save your butt if your computer crashes and you did not save that important presentation or file.

Continue Reading

Add Background Color to Word 2007 and 2010 Documents

By default all Word 2007 and 2010 Word documents are blank, boring, and not interesting. Here is a quick way to add some life to your Word documents.

Continue Reading

Calculate Dates in Excel 2007 or 2010 Workbooks the Easy Way

Sometimes when using Excel you have a variety of dates that you need to compare and find out how many days, weeks, months or years between them. Here is how you do it.

Continue Reading

Move or Copy a Worksheet in Excel

Sometimes you need to copy or move a worksheet inside of a workbook to do extra work or just to have a copy. Here is how you do it.

Continue Reading

Convert Time to a Decimal in Excel

Why would you need to do this you say? Well some people need to convert it for formulas or other things I guess…

Continue Reading

Working with VBA Loops in Microsoft Excel

What is a loop? A loop is to repeatedly do something until a specific event occurs. In VBA it is to repeat a line, or lines, of code until a certain criteria is meet. There are a couple of different loops in VBA and we will cover all of them with a couple of demos, first lets go over some basics.

Continue Reading

How to fix Word 2007 Crashes on Exit

Sometimes while using Word 2007 you can come across many different errors with it. One of the most common I have seen is when Word 2007 crashes whenever you try to close it. Here is how you fix it. How to fix it Run Regedit from the run box or the start menu. The registry [...]

Continue Reading

View Text Boundaries in Word 2010 or Word 2007

When formatting in Word, might need to see the text boundaries.Here is how to view text boundaries in Word 2007 and Word 2007.

Continue Reading

Fix OST Files in Outlook with SCANPST.EXE

Depending on how you have your Outlook setup you might have an OST. OST files or offline folder files, are typically used when you chose to have Outlook store copies of your email messages, calendar and other items locally for you. From time to time these OST files tend to get corrupt. Here is a [...]

Continue Reading

Calculate Remaining Days in the Year in Excel 2010

For this Excel how to tip, we are looking at how to calculate the remaining day in the year. This is a really easy, and quick to do.

Continue Reading