Office Articles
Use Dynamic Range Names in Excel for Flexible Dropdowns
Easy to edit, great for inexperienced users
Google Sheets vs Microsoft Excel – What are the Differences?
The gap is closing between them
Why You Should Be Using Named Ranges in Excel
Use it in forms, macros, and source definitions
Google Docs vs Microsoft Word – What are the Differences?
Some of these are very important
Ever wondered what the differences were between Google Docs and Microsoft Word? Whilst both word processors may look similar on the surface, they are actually different in many ways. In […]
Best New Features in Microsoft Office 2019
Office 365 users can access right away
Microsoft Office 2019 was announced and released on September 24, 2018 and it’s now available for Mac and Windows 10 users to purchase in all regions. Microsoft Office 2019 brings […]
When to Use Index-Match Instead of VLOOKUP in Excel
We'll show you with an example
For those of you who are well-versed in Excel, you are most likely very familiar with the VLOOKUP function. The VLOOKUP function is used to find a value in a […]
How to Delete Blank Lines in Excel
A few methods, with pros and cons of each
One of the most common tasks in Excel is deleting blank rows. Whatever type of data you may have in Excel, there are many occasions where you will also have […]
How to Take and Insert Screenshots using OneNote
Here are a few different methods to try
As a professional blogger, I take a lot of screenshots on a daily basis. Most I use and then simply delete, but there are occasions when I need to save […]
How to Reduce Outlook Memory Usage
Do these routine tasks for faster performance
One of the major issues most users have with Outlook is the fact that it gets really slow and eats up a lot of memory on their systems. I have […]
How to Merge Multiple Word Documents Together
It's not as intuitive as it should be
If you’re a heavy Word user, you probably have come across a situation where it would be convenient to merge multiple Word documents into one master document. Even though it’s […]
10 Tools to Recover a Lost or Forgotten Outlook PST Password
Including a bunch of free options to try first
Looking for a way to recover a password for an Outlook PST file? I recently tried to load up an old PST file that I used at my previous company […]
How to Export Your Emails from Microsoft Outlook to CSV or PST
You never know when something catastrophic could happen
Are you planning on leaving a job and want to make sure you get a copy of all your emails in case you need to refer to them at a […]
How to Install 64-bit Office via Office 365
Because why install in 32-bit?
Office 365 Personal, Home or Business products are great ways to access all of Microsoft’s Office products on your desktop, tablet or mobile phone. It’s way better than having to […]
Fix End Tag Start Tag Mismatch Error When Opening DOCX Files
Finally, a permanent solution
If you’re using Word 2007, 2010 or 2013, you might run into a strange error when opening a DOCX file. Recently, I tried to open a DOCX file I had […]
Troubleshoot and Fix Office Problems with Repair
If it's slow or you're having some other issue
If you’re having problems with any Office program like Word, Excel or Outlook, you can always perform a repair, which will try to fix any issues that may be causing […]
Fix Word Opens in Safe Mode Only
Several solutions to this perplexing problem
I installed Office on my Windows machine a long time ago and everything was working fine until today. I tried to open a Word document from my desktop and for […]
Can’t Open Hyperlinks in Outlook?
It's because you uninstalled Google Chrome
I recently ran into a very annoying problem while using Outlook on my computer. When I tried to click on a link, I ended up getting the following message: This […]
How to Trace Dependents in Excel
Find out which cell values are connected
If you work with formulas a lot in Excel, you know that the value of a single cell can be used in a formula in many different cells. In fact, […]
How to Write an IF Formula/Statement in Excel
Essential if you are dealing with numbers
Excel is such a powerful spreadsheet program that I doubt anyone can possibly know everything that it can do. There are so many aspects to the program, it’s amazing that […]
Outlook Autocomplete Not Working or Resetting?
We found 5 methods to fix this
One of the great things about online email services like Gmail is that you never have to worry about things like autocomplete because all your contacts are stored in the […]