MS Office Tips

How to Share or Collaborate On a Word Doc with Others

by File in: MS Office Tips

Looking for a way to collaborate with others on a Word doc? If so, you can do it very easily in Word itself. The feature has been around for a couple of versions of Office and it works even if the receiving party does not have Word installed on their system. Note that in order […]

How to Use Excel AutoRecover and AutoBackup Features

by File in: MS Office Tips

It’s always a terrible tragedy when someone loses something important they were working on because they didn’t save their document properly. This happens more often than you would think to Excel and Word users! Luckily, Microsoft has added a lot of features in the last couple of versions that help reduce the chances of losing […]

How to Show Formatting Marks in Word

by File in: MS Office Tips

If you have ever created a complex Word document, you’ve probably run into those frustrating issues where you just can’t seem to get a bullet point or paragraph of text aligned correctly or some text keeps breaking off onto another page when you need it to be on the same page. In order to fix […]

10 Great Websites for Free PowerPoint Templates

by File in: MS Office Tips

PowerPoint is still the king when it comes to presentation software. It’s been around for ages and every new version adds more features and makes the product even better. The main problem with PowerPoint is that most people can’t create stylish or beautiful presentations on their own since that requires a high level of design […]

Use the Excel Watch Window to Monitor Important Cells in a Workbook

by File in: MS Office Tips

Sometimes a great feature in an application never gets the recognition it deserves and the Watch Window in Excel is a great example of one such feature. If you use Excel regularly, you probably have worked on some very large worksheets that span hundreds, if not thousands of rows. It could be useful if some of the cells […]

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