Office 2016 Template Library – Worth a Revisit

If you have been a user of Microsoft Office going back to the “old days” of Office 95 thru Office 2003, one of the features you probably held in least regard were the templates.  Templates suffered several major disadvantages: Templates were stored on the local PC’s hard drive, which took up much needed storage space […]

Create a PowerPoint Presentation from a Word Outline

Imagine you need to create a PowerPoint presentation but you are plagued with one or a combination of the below problems: You aren’t very well versed in the use of PowerPoint You don’t have PowerPoint installed on the computer you are using You have very little time to put a presentation together Now suppose you […]

Windows 10 – Switch Audio Output Devices FAST

If your work entails somewhat repetitive tasks, there is nothing like having your favorite music playing in the background to help pass the time.  Working in an office, especially one with cubicles, employees are often discouraged or prohibited from playing music at their desks or workstations so as to not bother other employees.  It is […]

Excel – Consolidate Tool

Suppose you have data stored in multiple locations but you wish to create a chart from all of the data sources as if they were stored as a single data source.  You could spend time manually copying and pasting the data into a single, unified list, but this may prove difficult if the data is […]

PowerPoint – Insert Video with Different Audio

When inserting a video into PowerPoint, there are times that you want to replace the original audio track.  This can be for a variety of reasons: Original video has no accompanying audio Original audio is of poor quality Original audio contains content that violates copyright laws To replace the original audio track, perform the following […]

Excel – Display an Alert If a Sorted List Becomes Unsorted

Excel has the ability to sort data in a variety of ways: Alphabetically Numerically Chronologically In addition, the data can be sorted in either ascending (smallest to largest) or descending (largest to smallest) order. Sorted lists are useful when printing or for scanning when looking for information.  It is far easier to locate an item […]

Excel – Adding Ordinal Suffixes to a List of Numbers

An ordinal indicator is a character, or group of characters, that follows a number denoting that it is an ordinal number, as opposed to a cardinal number. For English speaking countries, this corresponds to the suffixes -st, -nd, -rd, -th in written ordinals (represented either on the line 1st, 2nd, 3rd, 4th or as superscript, […]

Merge Multiple Word Documents into a Single Word Document

Imagine putting together a research paper, training manual, or business proposal.  These documents are often the culmination of several separate documents assembled by a team.  If each member of the team is working on their part off the project in their own project file, the time will come when all of the pieces of the […]

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

Excel Color – Order of Application (Hierarchy)

Have you ever wondered why Excel, on occasion, will or will not color a cell according to your instructions?  The reason may lie in the order by which Excel applies colors. Excel applies colors in layers.  These layers are comprised of three criteria: Colors automatically applied via the implementation of a Data Table Colors manually […]