MS Office Tips

How to Subtract Dates in Excel

by File in: MS Office Tips

If you have an Excel sheet with a lot of dates, chances are you will eventually need to calculate the differences between some of those dates. Maybe you want to see how many months it took you to pay off your debt or how many days it took you to lose a certain amount of […]

How to use Sparklines in Excel

by File in: MS Office Tips

Ever had a worksheet of data in Excel and quickly wanted to see the trend in the data? Maybe you have some test scores for your students or revenue from your company over the last 5 years and instead of creating a chart in Excel, which takes time and ends up eating up an entire […]

How to Open Multiple Instances of Excel

by File in: MS Office Tips

If you have ever worked with multiple workbooks in Excel, you know that it can sometimes cause issues if all of the workbooks are open in the same instance of Excel. For example, if you recalculate all formulas, it will do that for all open workbooks in the same instance. If you don’t want that […]

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 […]