Office Tips

Google Sheets vs Microsoft Excel – What are the Differences?

by File in: Office Tips

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 society. Spreadsheets are useful for work, record keeping, collaboration, or just personal organization. Right now, we have two top contenders in the spreadsheet world – […]

Why You Should Be Using Named Ranges in Excel

by File in: Office Tips

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 your macros. A named range is just a range (either a single cell, or a range of cells) to which you assign a name.  You […]

Google Docs vs Microsoft Word – What are the Differences?

by File in: Office Tips

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 this article, I want to point out the major differences to help you decide which option is best for you. Functionality – Microsoft Word Wins […]

Best New Features in Microsoft Office 2019

by File in: Office Tips

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 a number of small tweaks and additions so we thought we’d highlight all of the most exciting changes in this article. What is Microsoft Office […]

When to Use Index-Match Instead of VLOOKUP in Excel

by File in: Office Tips

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 different cell based on some matching text within the same row. If you are still new to VLOOKUP function, you can check out my previous […]

How to Delete Blank Lines in Excel

by File in: Office Tips

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 a bunch of blank lines throughout the file. If you have thousands of rows, manually deleting blank lines is a major pain and virtually impossible. […]

How to Take and Insert Screenshots using OneNote

by File in: Office Tips

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 a screenshot for some future purpose. My main note taking app these days is OneNote and naturally I like to save my screenshots in a […]

How to Reduce Outlook Memory Usage

by File in: Office Tips

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 a 1.5 GB Outlook file, but Outlook runs fast and doesn’t hog all the resources on my computer! Why? Well, it’s because I optimize my […]

How to Merge Multiple Word Documents Together

by File in: Office Tips

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 not very difficult to do this in Word, it’s also not very intuitive. You would think Microsoft would have included some merge documents feature into […]

10 Tools to Recover a Lost or Forgotten Outlook PST Password

by File in: Office Tips

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 many years ago, but realized it had a password set on it. I tried every password I had ever used, but nothing worked. Finally, I […]