Two-Way Lookup with the Intersection Operator

Locating a specific item in a table based on two separate criteria can be a challenging task, even for the most ardent Excel user.  Take the following table, for example: Suppose you wish to locate the sales for the Southern region in the month of March.  You could try to write a sophisticated VLOOKUP with […]

VLOOKUP–Looking to the LEFT!

Anyone who has ever used Excel and needed to query a table for information has no doubt used a VLOOKUP function.  VLOOKUP is one of the most widely used functions in all of Excel.  But even the most popular things in life are not without their shortcomings. The single most vexing problem for VLOOKUP users […]

How Big is a Spreadsheet?

Have you ever wondered just how large an Excel spreadsheet really is? When it comes to entering data, Excel spreadsheets have grown larger and larger over the years.  In Excel’s infancy, spreadsheets were only 256 columns wide and 16,384 rows tall.  Over the years the number of columns remained at 256 but the height grew […]

Using Excel MODE Function to Return a Text Response

Excel’s MODE function is a great tool for returning the most frequently occurring number in a set of numbers. But what if you want to return the most frequently occurring word in a list of words? MODE with Numbers Using the MODE function in Excel is quite simple; you point to a list of numbers […]

Add Dropbox to Office 2016

We’ve come a long way over the years when it comes to where we store our files.  In the 80’s and 90’s it was all about local storage; the venerable C:, or “C-drive”.  Then in the 2000’s, when connecting all of the office computers together on a network became the norm, companies told us not […]

Send “Out of Office” Replies from Outlook

You can send automatic “Out of Office” replies from Outlook 2013 or Outlook 2016 for Windows whenever you want to let people who send you email know that you won’t be responding to their messages right away.There are two different ways to set up automatic replies. The method you choose depends on the type of […]

Conditional Formatting with Subtotals in Excel

Just as there should be a Nobel Prize for the person who put a screwdriver in the end of a power drill, thus inventing the Power Screwdriver, there should be a Nobel Prize for merging the abilities of Conditional Formatting with the Subtotals tool in Excel. If you have ever used the Subtotals tool to […]

Never Miss Another Public Holiday

In the spirit of Thanksgiving, this week’s blog post will deal with managing holidays in Outlook. Do you have trouble remembering which day Labor Day is on versus Memorial Day?   Ever show up for work one morning just to discover that the office is closed for President’s Day and you could have slept late?  Well, […]

Supercharge Your VLOOKUP Functions in Excel

Any Excel user who considers themselves a “power user” cannot make such a statement with a straight face without knowing how to use VLOOKUP functions. Of all of the ways to retrieve information, the VLOOKUP function is without debate the most popular means of looking up and returning information from an Excel list.  It’s not […]

Create a Video in PowerPoint 2016

If you have ever been tasked with creating a video to demonstrate come process in an application, like creating pivot tables in Excel or performing a mail merge in Word, you probably had to spend a bit of money on some screen capturing software.  There are many great programs on the market designed specifically for […]