There’s nothing like a good keyboard shortcut to help improve workflow efficiency. Most Office users quickly learn the standard keyboard shortcuts, like CTRL+S for SAVE or CTRL+P for PRINT, but what about CTRL+F for FIND? This is a great way to bring up the FIND dialog box. Somewhere along the way, Microsoft, in its infinite […]
Excel IFS and SWITCH Function (Say Goodbye to Nested IFs and VLOOKUPS On Small Tables)
Some of the first functions that a newly-titled “power user” learn are IF and VLOOKUP. The IF function provides the user the ability to ask a question and perform action “A” for one answer and action “B” for another answer. The catch is that any question posed must be answerable as either “true” or “false”. […]
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
Add Dropbox to Office 2016
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, […]