Office Articles
How To Set Out Of Office Replies In Outlook
It depends if you are using it stand-alone, with Microsoft Exchange, or on the web
How To Fix When Word Opens In Read Only Mode
In case you need to edit it
If you’ve opened a document in Word but you can’t edit it, it’s probably locked for editing by someone or by a feature. Learning how to remove read only from […]
How to Remove, Crack, or Break a Forgotten Excel XLS Password
We cover both free and paid methods
It can be really frustrating when you go to use a password-protected resource and you have forgotten the password. Even online membership sites can be frustrating enough. But if it […]
How To Sync Outlook Contacts With Android, iPhone, Gmail & More
Pivotal in personal and business communications
Despite the growth and prominence of chat apps and mobile messaging services, we still send and receive emails every day. Email is a common form of communication in business, but […]
How To Get Microsoft Word For Free
And without even having to do anything illegal
Getting Microsoft Word for free sounds like a dream. It’s an awesome program and is a staple in most office, home, and school environments, but it normally costs each year […]
Charting Your Excel Data
A friendly, sexier way to share info
For some time now, charting data in Excel has become not only simple but also automated to the extent that you can easily go from a tabular spreadsheet to a […]
How To Understand What-If Analysis In Microsoft Excel
From the relatively simple to the highly complex
A what-if scenario is fairly easy to understand – put simply, your question is, “If this happens, what happens to my numbers, or bottom line? In other words, if we […]
Use Excel Mobile’s New “Insert Data From Picture” Function
Snap photos of charts and convert to tables in a snap
Microsoft have been doing a lot of work when it comes to their mobile Office applications. What started out as apps that basically only worked as document viewers now feel […]
Use Excel as a Tool to Copy Data from the Web
It's called scraping and can be used for good or evil
Web scraping is the act of extracting data, information, or images from a website using an automated method. Think of it as copy and paste on full automatic. We either […]
How to Completely Delete Personal Metadata from Microsoft Office Documents
Plus the reasons why you want to do this
Everything you do generates data somewhere. That data, when collected and analyzed, becomes information. That information can tell someone more about you than you probably want them to know. The […]
How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel
The three most commonly used formulas everyone should know
The three most commonly used formulas in Excel that perform simple mathematical calculations are COUNT, SUM and AVERAGE. Whether you are managing a financial budget in Excel or simply keeping […]
12 Useful Microsoft Word Tips and Tricks
For experienced Office users and newbies alike
Chances are, you either use Microsoft Word now, or may have to use it in the future. It’s easily the most popular word processor for Windows, so learning some useful […]
How to Separate First and Last Names in Excel
We'll show you how to set up your own formula
If you use Excel a lot, you have probably run across a situation where you have a name in a single cell and you need to separate the name into […]
Quickly Add a Table of Contents to a Word Doc
Create a great looking TOC that will impress your teacher or boss
Now that I’m back in school again after a long time, I’m also back to having to create various PowerPoint presentations and write reports up in Word. There are a […]
Use Format Painter in Word to Copy and Paste Formatting
Hidden features like these really come in handy sometimes
Word has so many features I rarely use, it’s pretty amazing. However, when you run into that one instance where you need to do something unusual, those hidden features really […]
Migrate Data from MS Access to SQL Server Database
This is particularly useful for large databases
Recently, I had to migrate the data from an Access database to SQL Server 2014 because my database was getting too large for Access to handle. Even though the process is […]
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 […]
