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

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

Restoring FIND Keyboard Shortcut in Word 2016

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