Microsoft Project – Calculate Days Between Two Custom Dates

Microsoft Project packs more “bang for the buck” than most any other Microsoft Office application.  With just a small amount of data input, the user can produce mountains of useful analysis. Because MS Project shares many characteristics of a traditional database, users can take advantage of a myriad of pre-loaded database fields for storing information; […]

Outlook Meeting Invitations Deleted After Accepted… WHY?!?!

Outlook is an indispensible application when it comes to maintaining communication with friends and coworkers.  Microsoft has packed an array of wonderful features into Outlook to assist in this endeavor.  However, there is an interesting “feature” in Outlook that, for some people, seems to go one step too far in helping and actually doubles back […]

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

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