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

Office 2016–New Chart Types

As a seasoned producer of charts, you have probably wondered why Microsoft has not included certain type of charts that have previously only been available via third-party add-on programs.  Microsoft has heard your calls and added some new and exciting charts to the Office 2016 charting engine.  These charts type are not just available in […]

QlikView–Creating a Master Calendar

If you’ve ever struggled with constructing a master calendar for a QlikView data model, this post should help reduce your stress levels. If you’re unsure of what the purpose of a master calendar is, a master calendar helps reduce the redundancy of date information in a data set.  Imagine placing in a table a year’s […]

Apply Two Different Number Formats to a Single Field (Excel Pivot Tables)

There comes a time in every Excel Power User’s life when they must deal with mixed content in a single field.  Examine the following table: The Value field (column E) contains a mixture of sale amounts (values as decimals) and discount rates (percentages.)  If a pivot table is constructed using this data, it can take […]

Missing Resources in Microsoft Project Resource Pools

If you work with Microsoft Project and have ever leveraged the power of Resource Pools across multiple projects, you may have encountered a strange behavior when assigning those resources. When you share resources between a Resource Pool file (a dummy project file that typically has no tasks but is merely a container for holding resources) […]

iPhone Trick – View an Email Message While Composing Another

Have you ever been composing an email message and realize that you have to check something in a different message?  If you’re like most people, you save the message you are currently composing as a draft, close the message, open the OTHER message to get the needed information, close THAT message, and then reopen the […]