How to Create Form Letters in Word
You'll need to create a database, which we'll also show you how to do
How to Alphabetize in Word and Excel
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 […]
Make One Page Landscape in Word
It's not very intuitive at all
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 […]
Fix Microsoft Word has Stopped Working
7 different methods explained for you
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 […]
Use Excel to Figure Out an Effective Interest Rate from a Nominal Interest Rate
Find out how much they are really ripping you off
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 […]
AutoFit Column Widths and Row Heights in Excel
A real time-save and makes them much easier to read
Excel’s grid-like appearance can seem static at times without the possibility of creating customized interfaces to match the needs of the data stored in a worksheet. Although this is true […]
How to Connect a Projector to a Windows PC
Plus the best options for displaying a presentation
Since Windows 7, one feature that’s been greatly enhanced in Windows is the ability to instantly connect a projector using different options depending on your needs. Using a simple keyboard […]
Add Headers and Footers to a PowerPoint Presentation
Make it look slick with numbers or other important info
Although PowerPoint presentations are usually displayed on a screen, they are just like other documents in the Microsoft Office suite such as Word, Excel, and Publisher. Just like those other […]
Add a Cover Page to a Word Document
An easy way to make it look professional
As any good writer will tell you, the presentation of your work is as important as the content. Consequently, if you want people to perceive your work as professional, you […]
Add a Linear Regression Trendline to an Excel Scatter Plot
An easy way to visualize data
Although Excel is capable of calculating a number of descriptive and inferential statistics for you, it is often better to show a visual representation of data when presenting information to […]
How to Add Action Buttons to a PowerPoint Presentation
Plus a couple of things to consider first
Found in a strange place in the application, you can add action buttons to a PowerPoint slide to make your presentation more interactive and easier to use for the viewer. […]
How to Sort Text in Word
When most people think of sorting text in an application, they think of sorting cells in an Excel spreadsheet. However, you can sort text in Word as long as there […]
How to Use the YEARFRAC Function in Excel
You can calculate the precise difference between 2 dates
One of the limitations of subtracting dates in Excel is that the application can only give you either the number of days, the number of months, or the number of […]
Turn Caps Lock Text back to Normal in MS Word
AN EASY WAY TO STOP SHOUTING
At one time or another, we have all accidentally tapped the Caps Lock key while typing. If you were multitasking while typing, it is completely possible you typed several sentences in all caps! I’m […]
Password Protect Worksheets in Excel 2007
If you work with people from all over the country or world, you probably share and e-mail files back and forth to one another. If you share Microsoft Excel 2007 […]
How to Add Music to a PowerPoint Presentation
Adding music to a PowerPoint presentation is a very simple process, requiring only a couple of steps to complete. Music will not only give your presentations more appeal but grab […]
What is ctfmon.exe and Do You Need It?
It depends if you are using speech or handwriting recognition
Are you seeing a process called CTFMON.exe using up resources on your Windows PC? Most of the time, this process is harmless and you really don’t need to worry about […]
Fix Microsoft Outlook has Encountered a Problem Error
Put down the drill and follow these instructions
One of Microsoft’s favorite error messages is “Program X has encountered a problem and needs to close”. You’ll get this message from pretty much any Microsoft product, including Microsoft Office, […]