Office Articles

One Excel function that I use quite a bit in my formulas is the IF function. The IF function is used to test a logical condition and produce two different […]

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

Excel spreadsheets often include cell dropdowns to simplify and/or standardize data entry.  These dropdowns are created using the data validation feature to specify a list of allowable entries. To set […]

Previously, we wrote about the differences between Google Docs and Microsoft Word and in this post, we’re going to talk about spreadsheets. Spreadsheets are the pillars for our modern day […]

Named ranges are a useful, but often underutilized, feature of Microsoft Excel.  Named ranges can make formulas easier to understand (and debug), simplify the creation of complicated spreadsheets, and simplify […]

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

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

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

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

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

If your Excel document has thousands of rows, manually deleting blank lines can be stressful and virtually impossible. You can use Excel macros to clean up your data, but it […]

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

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

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

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

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

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