MS Office Tips

Save MS Office Files to Local PC Instead of OneDrive

by File in: MS Office Tips

In the desktop version of Office and in Office 365, if you are logged in using your Microsoft account, it will try to save the file to your OneDrive account by default. This is a new feature that started back in Office 2013 that aims to help you move your documents to the cloud, so […]

How to Use a Lookup Table in Excel 2010

by File in: MS Office Tips

One of the most often cited areas of assistance requests to help-desk personnel regarding Microsoft Excel, is the VLOOKUP command. For some reason, people seem intimidated by it, and then rather than break it down into simple components, panic and reach for help. Things don’t have to go that way though, because if you look […]

How to Create Form Letters in Word

by File in: MS Office Tips

Sometimes you may want to create a letter that you will be sending to a lot of different people, but you’d like certain parts of it to be individualized for each addressee: parts such as the greeting, name, address, etc. In Word parlance, this means you should create a form letter, which is really easy to […]

How to use AutoText and Quick Parts in MS Word

by File in: MS Office Tips

For several of the past iterations of Word, Microsoft has had an AutoText feature that allows users to capture a piece of text and then to use it over and over again in other parts of their documents, or even in other documents. Microsoft has added to that feature by including something it calls, Quick […]

Link Cells Between Sheets and Workbooks In Excel

by File in: MS Office Tips

A common thing to do in Excel is to use one sheet for collecting raw data, such as sales totals, and then to use another tab, or even a workbook to create summations or reports; the thing is though, doing so requires you link the cells first. Fortunately, this is a lot easier than it […]

How to Alphabetize in Word and Excel

by File in: MS Office Tips

One common question I get from readers of my blogs is on how to alphabetize a list in Word or in Excel. Suppose you have a list of items and you want to quickly sort them in ascending or descending order. Luckily, it’s really easy in both Word and Excel! Sorting in Excel is a […]

Make One Page Landscape in Word

by File in: MS Office Tips

Recently, I was writing a Word document and I came across an interesting problem! I had about 20 pages in the Word doc, but I needed only one of them to be in Landscape orientation! Even though I’ve been using Word for 10+ years, I never ran into this situation before. After playing around with […]

Find Out if Two Cells in Excel Contain Exactly the Same Number Values

by File in: MS Office Tips

Like a two-dimensional (or flat) database, Excel is capable of storing many different types of data from small business contacts to personal income tax records. In both of these examples, accuracy is essential to make sure you have the information you need when you need it. In any data entry situation, people often transpose numbers […]

Fix Microsoft Word has Stopped Working

by File in: MS Office Tips

I recently installed Microsoft Office on a Windows machine and everything worked fine for a few days, but all of a sudden when I open Word, I get the following error message: Microsoft Word has stopped working It then gives me the option to check online for a solution or to close the program. After […]

Use Excel to Figure Out an Effective Interest Rate from a Nominal Interest Rate

by File in: MS Office Tips

Among Excel’s more popular formulas, the EFFECT formula is often used by financial professionals to figure out an effective interest rate from a nominal interest rate. Also called annual percentage rate (APR) and annual percentage yield (APY), Excel makes it easy to calculate effective mortgage, car loan, and small business loan interest rates from the […]