Tech Tips

Hidden Tricks in Windows File Search

Searching for files is the next big thing. Why remember where you put something when searching is so easy? That’s the philosophy, but one of many baffling decisions made by Microsoft in its newer versions of Windows (Vista, 7, 8) has been lack of discoverability in how to do a more refined search for files… Read more »

Repeat Entered Data in a Fillable PDF Form

In PDF forms, it is often necessary to repeat a user-entered value on several pages of the form. Imagine a contract where a party’s name is printed on each page, or an application that has the applicant’s name in a repeated header. You can do this in a PDF by using Adobe LiveCycle Designer’s Master… Read more »

Generate a Random Number in Excel

If you’ve ever been in charge of picking a contest winner, the image that comes to mind is an oversized hat and hundreds of pieces of paper. But in the electronic world, that doesn’t cut it if all of your contest entries lay before you in an Excel spreadsheet. Before you break out the printer… Read more »

How to Make Microsoft Project Calculate a Task Duration

Often you may have an idea of how much work is involved in a task, but not necessarily how long it will take to complete. How long it takes depends on the other main factor in this equation: resources. But what if you don’t yet know how many resources you can commit? Microsoft Project certainly… Read more »

Change the Default Formatting in Outlook 2013

Outlook 2013 introduced a pretty different look and feel to your Inbox that, unfortunately, might make for a bit of struggle if you try to reconcile that with what you were used to. The predominant complaint from me is that it appears that Microsoft did not design Outlook with a smaller screen in mind (such… Read more »

Link Excel Data across Multiple Sheets

Excel has an excellent, underutilized way to take data from a master sheet and capture subsets of that data on other sheets. In this way Excel can act like a functional database by using a component called Microsoft Query. Let’s say that I have a master sheet of all technical support questions posed in 2013,… Read more »