MS Office Tips

How to Use Compare & Combine Documents in Word

by File in: MS Office Tips

Word has two really useful features that almost no one ever uses: Compare Documents and Combine Documents. As their names imply, the features let you either compare two Word docs against each other or combine two together. So when would you ever need to use this? Well, if you’re like me, you probably have 20 […]

How to Create and Use Formulas in Tables in Word

by File in: MS Office Tips

There are a lot of times when I need to include some simple data calculations in a Word document and a table is the best option. You can always try to insert an entire Excel spreadsheet into your Word doc, but that’s overkill sometimes. In this article, I’m going to talk about how you can […]

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