Office Articles
How to Hide Sheets, Cells, Columns, and Formulas in Excel
Each part of the spreadsheet can be hidden in different ways
Ultimate Guide to Repairing a Damaged or Corrupt Word File
Good news is most of the data can be recovered
Hide Text and Show Hidden Text in Word
Useful when printing out different versions of the same document
Microsoft Word has a feature whereby you can hide text so that it does not visibly appear in the document. If you don’t want to delete text completely, hiding the […]
How to Open MDI Files
A proprietary format used for storing images of scanned documents
An MDI file, which stands for Microsoft Document Imaging, is a proprietary Microsoft image format used for storing images of scanned documents created by the Microsoft Office Document Imaging (MODI) […]
Export Contacts from Outlook, Outlook Express and Windows Live Mail
Take the addresses with you when you switch computers
Need to export your contacts out of Outlook? I used to work at an office where there are multiple versions of Office installed on employee computers including Office 2003, Office 2007, Office […]
Link to Specific Slides in Other PowerPoint Presentations
This works for Word and Excel documents as well
Have you ever needed to link your PowerPoint presentation to another one? What if you could link it to a specific slide in the other presentation? What if you could link […]
How to Add Comments to an Excel Worksheet Cell
It's so useful, yet so underused
I’m a big user of Excel and it always amazes me how few people add comments to their Excel spreadsheets! Adding and using comments in Excel is a great way […]
Format Cells using Conditional Formatting in Excel
There are 5 good reasons why you want to do this
If you are used to using older versions of Excel, the conditional formatting options in Excel 2007, 2010, and 2013 will amaze you. So why would you want to bother using […]
How to Create Microsoft Outlook Shortcuts for Email and Tasks
Better than keyboard shortcuts because you don't have to have it running
Here’s a quick guide on how to create your own Outlook shortcuts (not Outlook keyboard shortcuts) on the desktop or Quick Launch bar so that you can easily create a […]
How to Make a Simple Graph or Chart in Excel
Once you learn the basics you can get more complicated
Excel is a powerful tool that you can use to create charts and graphs for small or large amounts of data. In this Excel tutorial, I’ll show you how to […]
Create Dropdown Lists in Excel using Data Validation
Store them like a database and use in any worksheet
If you’re a big Excel user, then you may have found yourself in a situation where you wished you could have simply picked a value for a cell from a […]
Ultimate Troubleshooting Guide for Office 2013 Installation Problems
Fun fact: you can't install it on Windows Vista or Windows XP
I’ve been installing Office 2013 on a lot of computers lately and I’ve ran into quite a few problems along the way. From annoying messages like “Sorry we ran into […]
Compare Two Excel Files using SpreadSheet Compare
Very useful if you are using it in collaboration with others
Office 2013 Professional Plus has a couple of new features including a new program called Spreadsheet Compare. Spreadsheet Compare takes two Excel files and tell you the difference between them […]
Save MS Office Files to Local PC Instead of OneDrive
Because sometimes you don't want everything in the cloud
In the desktop version of Office and in Office 365, if you are logged in using your Microsoft account, it will try to save the file to your OneDrive account […]
How to Create Form Letters in Word
You'll need to create a database, which we'll also show you how to do
Sometimes you may want to create a letter that you will be sending to a lot of different people, but you’d like certain parts of it to be individualized for […]
How to use AutoText and Quick Parts in MS Word
Really handy for repetitive typing tasks
For several of the past iterations of Word, Microsoft has had an AutoText feature that allows users to capture a piece of text and then to use it over and […]
Use Excel to Figure Out an Effective Interest Rate from a Nominal Interest Rate
Find out how much they are really ripping you off
Among Excel’s more popular formulas, the EFFECT formula is often used by financial professionals to figure out an effective interest rate from a nominal interest rate. Also called annual percentage […]
AutoFit Column Widths and Row Heights in Excel
A real time-saver and makes them much easier to read
Excel’s grid-like appearance can seem static at times without the possibility of creating customized interfaces to match the needs of the data stored in a worksheet. Although this is true […]
Add a Cover Page to a Word Document
An easy way to make it look professional
As any good writer will tell you, the presentation of your work is as important as the content. Consequently, if you want people to perceive your work as professional, you […]
