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 […]
Excel IFS and SWITCH Function (Say Goodbye to Nested IFs and VLOOKUPS On Small Tables)
Some of the first functions that a newly-titled “power user” learn are IF and VLOOKUP. The IF function provides the user the ability to ask a question and perform action “A” for one answer and action “B” for another answer. The catch is that any question posed must be answerable as either “true” or “false”. […]