Office Articles
How to Recover Deleted Files from a PST File in Outlook
Mar 4th, 2019 by Christopher Jan Benitez
Some very important steps to do right away
Miss Hotmail? Microsoft Outlook Email Services Explained
Feb 13th, 2019 by Ryan Dube
Hopefully this will bring you some closure
How to Create a Simple Pivot Table in Excel
Feb 4th, 2019 by Aseem Kishore
Also, we answer what is a pivot table?
How to Use If and Nested If Statements in Excel
Calculate commissions and so much more
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 […]
How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel
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 […]
Use Dynamic Range Names in Excel for Flexible Dropdowns
Easy to edit, great for inexperienced users
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 […]
Google Sheets vs Microsoft Excel – What are the Differences?
The gap is closing between them
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 […]
Why You Should Be Using Named Ranges in Excel
Use it in forms, macros, and source definitions
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 […]
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 […]
12 Useful Microsoft Word Tips and Tricks
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
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 […]
How to Delete Blank Rows in Excel
A few methods, with pros and cons of each
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 […]
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 […]