Office Articles
Quickly Add a Table of Contents to a Word Doc
Create a great looking TOC that will impress your teacher or boss
Use Format Painter in Word to Copy and Paste Formatting
Hidden features like these really come in handy sometimes
How to Create Fillable Forms in Word
Just as good as creating a PDF
Did you know that you can create forms in Word that people can fill out? When you hear about fillable forms, it is almost always related to Adobe and PDF […]
How to Use Compare & Combine Documents in Word
Consolidate all of your resumes with this useful tool
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 […]
How to Create and Use Formulas in Tables in Word
When you need to include some simple data calculations and importing Excel is overkill
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 […]
How to Share or Collaborate On a Word Doc with Others
The next best thing to standing over their shoulder
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 […]
How to Use Excel AutoRecover and AutoBackup Features
Two features that may save your @$$
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 […]
How to Show Formatting Marks in Word
It makes it easier to fix those annoying glitches
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 […]
Use the Excel Watch Window to Monitor Important Cells in a Workbook
A very handy tool when you have thousands of rows
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 […]
How to Subtract Dates in Excel
It's easy at first, but it can get complicated
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 […]
How to use Sparklines in Excel
Create a mini chart inside a single cell
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 […]
How to Open Multiple Instances of Excel
Important for users of Office 2010 and below
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 […]
How to Remove an Image Background
Try these different methods and see which gives the best results
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 […]
Insert an Excel Worksheet into a Word Doc
How to create a link between the files so it updates automatically
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 […]
How to Open a WPS File
It's probably a Microsoft Works spreadsheet
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 […]
How to Filter Data in Excel
Hide rows and summarize filtered data
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 […]
Use Summary Functions to Summarize Data in Excel
How to create a formula and insert the function into a spreadsheet
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 […]
How to Hide Sheets, Cells, Columns, and Formulas in Excel
Each part of the spreadsheet can be hidden in different ways
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 […]
How to Track Changes in Excel
Several features, with a few caveats
Are you looking for a way to track changes made to an Excel spreadsheet? There are many cases where you have to distribute a file to multiple people and keep track […]
