MS Office Tips

How to Remove an Image Background

by File in: MS Office Tips

So you have a wonderful picture of your kids or dogs and you want to have some fun by removing the background and dropping in a different background? Or maybe you just want to remove the background on a picture so that you can use it on a website or digital document? There are many […]

Insert an Excel Worksheet into a Word Doc

by File in: MS Office Tips

Ever need to insert an Excel worksheet into a Word document and have them linked so that when you update the main Excel worksheet, it automatically updates the values in the Word document also? Well, there are actually a couple of ways to insert an Excel spreadsheet into Word: linking, embedding and creating a new one. Whether you […]

How to Open a WPS File

by File in: MS Office Tips

Do you have a WPS file on your computer and have no idea how to open it? A quick Google search will tell you that the WPS file extension is from the Microsoft Works program, which was discontinued many years ago. However, there are still quite a lot of people who use Microsoft Works and […]

How to Filter Data in Excel

by File in: MS Office Tips

I recently wrote an article on how to use summary functions in Excel to easily summarize large amounts of data, but that article took into account all data on the worksheet. What if you only want to look at a subset of data and summarize the subset of data? In Excel, you can create filters […]

Search Outlook Email by Sender, Date, Keyword, Size and More

by File in: MS Office Tips

Searching through Outlook email can prove to be a tough task if you are someone like me with multiple PST files and tens of thousands of emails spanning decades. Most corporate environments use Outlook for email and many people end up having business and personal email stored in Outlook. In older versions of Outlook, you […]

How to Make Flowcharts in PowerPoint

by File in: MS Office Tips

PowerPoint is a powerful application that can be used for just about any type of presentation. One great example of using PowerPoint is to present processes and decisions using flow charts and diagrams. Just about every version of Office has the ability to add standard flow chart shapes like Process, Decision, Data, etc., but Office […]

Use Summary Functions to Summarize Data in Excel

by File in: MS Office Tips

For those who use Excel regularly, the number of built-in formulas and functions to summarize and manipulate data is staggering. Excel is literally used by everyone: from students in a financial class to hedge fund managers on Wall Street. It’s extremely powerful, but at the same time very simple. For those just getting started with […]

How to Hide Sheets, Cells, Columns, and Formulas in Excel

by File in: MS Office Tips

If you use Excel on a daily basis, then you’ve probably run into situations where you needed to hide something in your Excel worksheet. Maybe you have some extra data worksheets that are referenced, but don’t need to be viewed. Or maybe you have a few rows of data at the bottom of the worksheet […]

How to Set Away Message in Outlook

by File in: MS Office Tips

Going out of the office soon and need to setup an Out of Office, Away or Vacation message in Outlook? You would think it would be super easy, but unfortunately it’s not! There are actually two ways of creating an automatic reply and it depends on whether Outlook is stand-alone or using Microsoft Exchange. If your are in […]

Ultimate Guide to Repairing a Damaged or Corrupt Word File

by File in: MS Office Tips

Need to repair or fix a corrupt Word document? Sometimes when opening a Word document, you will give you an error stating that the document cannot be read because it is corrupt or because there is some other problem with the file. Word documents can become corrupt in a number of different ways, but usually it’s […]