Office Tips

Change to Landscape Orientation in Google Docs

by File in: Office Tips

There’s no doubt that portrait orientation is the way to view the vast majority of documents on the web. It’s how we’ve always read books and browsed websites. You’re reading this post in portrait orientation now, right? However, in fringe cases where you’re trying to format a document to be wider than it is tall, […]

10 Excel Tips and Tricks for 2019

by File in: Office Tips

In this article, I’ll be covering 10 Excel tips that you can use to boost productivity and make your work life easier. Make sure you read through the entire list so that you can find the tips that will be most useful to you. I’ll be jumping straight into the action below. Make sure you […]

How to Recover Deleted Files from a PST File in Outlook

by File in: Office Tips

Removing emails from the Deleted Items folder should always be done with caution. But accidents happen and sometimes we delete emails by mistake. Luckily, there’s a way to recover deleted items in Microsoft Outlook. First things first: you must close Outlook immediately after you’ve deleted the items. It’s also important that you not restart the […]

Miss Hotmail? Microsoft Outlook Email Services Explained

by File in: Office Tips

Do you remember using Microsoft’s Hotmail email service? Throughout the years, Microsoft has offered a variety of cloud email services that it has rebranded several times. These rebrands become even more confusing when you follow Microsoft’s transition from Microsoft Hotmail, to Live Mail, and finally to the Outlook web app. MSN Hotmail – What Happened? […]

How to Create a Simple Pivot Table in Excel

by File in: Office Tips

If you are in the field of finance or accounting, you already know that most of the job opportunities require intermediate or advanced Excel skills. Some of the most common Excel functions in these roles are Pivot Table and VLOOKUP. This article will outline the basics of a pivot table. Go here if you want […]

How to Use If and Nested If Statements in Excel

by File in: Office Tips

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 results depending on whether the logical condition returns TRUE or FALSE. Let’s use the mobile phone sales table below as an example. You can download […]

Use Dynamic Range Names in Excel for Flexible Dropdowns

by File in: Office Tips

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 up a simple dropdown list, select the cell where data will be entered, then click Data Validation (on the Data tab), select Data Validation, choose […]

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