Office Tips

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

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