Office Tips

How to Recover Deleted Emails in Office 365

by File in: Office Tips

It’s easy to accidentally delete emails every now and then. But it is possible to recover some emails that are thought to be gone for good. Deleted emails in Office 365, for example, can be recovered provided you meet certain conditions. The methods described below have a higher chance of working if you attempt to […]

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