MS Office Tips

How to Add Action Buttons to a PowerPoint Presentation

by File in: MS Office Tips

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. These action buttons can make a presentation simpler to navigate and make the slides in your presentation behave like web pages. Before you add action […]

How to Sort Text in Word

by File in: MS Office Tips

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 is something that tells Word where the different parts of text begin and end. In this article, I’ll show you a couple of ways you […]

How to Use the YEARFRAC Function in Excel

by File in: MS Office Tips

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 years separately, rather than a combined number. Luckily, Microsoft included a built in Excel function to give you precise differences between two dates in a […]

Turn Caps Lock Text back to Normal in MS Word

by File in: MS Office Tips

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 so good at typing now that I don’t even look at the screen a lot of times when I know exactly what I need to […]

Password Protect Worksheets in Excel 2007

by File in: MS Office Tips

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 files with others, you can protect worksheets to ensure that recipients cannot change the content of the file. You can also specify which cells within […]

How to Add Music to a PowerPoint Presentation

by File in: MS Office Tips

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 the attention of the audience as well. For this tutorial, we will be using Microsoft PowerPoint, Windows Edition. If you do not have PowerPoint, you […]

What is ctfmon.exe and Do You Need It?

by File in: MS Office Tips

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 it. However, if it’s eating up your CPU, it might be worth taking the time to disable it. So what is ctfmon.exe? It’s a process […]

Fix Microsoft Outlook has Encountered a Problem Error

by File in: MS Office Tips

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, Windows, and Internet Explorer. Previously I wrote about a way to fix Internet Explorer has encountered a problem and needs to close error. In this […]

Fix for Cannont Empty the Clipboard in Office

by File in: MS Office Tips

Have you ever tried to copy some cells in Excel and gotten the Cannot empty the clipboard error message? I was recently the victim of this annoying error, which would pop up EVERY time I tried to copy data from any cell on my spreadsheet. The strange thing is that the copy still works for me, but […]

How to Switch Between Worksheets in Excel

by File in: MS Office Tips

A number of people in my office have been asking me how they can easily switch between worksheets in Excel using their keyboards rather than having to click on an individual sheet and this article will addresses that issue. This may sound lazy to someone who does not use Excel very often, but when you’re […]