CHOOSE the RIGHT Chart Animation in PowerPoint Have you ever been tasked with presenting a chart or a graph in a meeting? If you are using PowerPoint during the presentation, the way you setup the PowerPoint slide matters. Let’s look and a
LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) Extracting records from a data set that matches defined criteria is a skill most users acquire early in their learning. This usually takes the form of
SUPER EASY Excel Data Entry Form (NO VBA) In this post we will look at creating data entry forms in Excel. The best part is… NO VBA! Suppose you need to input data into an Excel table and you want to make
Excel IF Function with PARTIAL Text Match (IF with Wildcards) How can we look for an approximate match using wildcards with Excel’s IF Function? =IF(YouTu* THEN…) Can you use wildcards in the logical test portion of the IF Function? It seems like
Why you SHOULD be USING Custom Number Formatting in Excel Let’s see a few Excel Custom Number Formatting tips that will not only save you time, but also help you avoid common spreadsheet mistakes. First, we’ll see the formatting in action and
Excel Formula to Convert Numbers to Words One of the most asked for Excel features is the ability to turn a number into words. Because many people need this ability, and Excel does not currently possess such a feature, the old saying
Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed) Efficiency is a key objective here at XelPlus, but sometimes even the best of us miss the mark. In a previous post, we discussed three different ways to transpose data in
Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA This post will show you how to create an Excel macro that will allow you to print specific worksheets by selecting them form an automatically generated list.
3 PowerPoint HACKS for INSTANT Improvement (incl. Morph between Shapes) This post will introduce you to three PowerPoint techniques that you can use to impress your colleagues and boss. They will think you spent HOURS honing and crafting your presentation… …but you
Charting Survey Results in Excel (Visualize Employee Satisfaction results) This post spotlights a practical way to visualize survey results in Excel, particularly surveys that follow a “like/hurt” format. Surveys, like employee surveys, that provide a range of choices between “Strongly Disagree” to