Excel IF Function with PARTIAL Text Match (IF with Wildcards)

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

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

Convert Numbers to Words

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

Change HORIZONTAL Data to VERTICAL

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

3 PowerPoint HACKS for INSTANT Improvement

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

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

Excel shortcut keys you SHOULD know!

Excel shortcut keys you SHOULD know! This post‘s topic is one the most requested topics for the site. SHORTCUTS!!!! These are keyboard shortcuts that EVERY Excel user needs to know, practice, and commit to muscle memory. From the beginning Excel user to

Have You Tried These PowerPoint Presentation Tips?

Have You Tried These PowerPoint Presentation Tips? This post is a bit of a departure from the norm.  Instead of discussing some lifechanging Excel feature, let’s talk about delivering better presentations. I want to share three tips that helped me create more