How to Check Excel Cells for Specific Text

Not long ago, a friend challenged a comment I made. It had to do with word choices and if people use one verb more than others. In this article, I’ll show you how to tell if an Excel cell contains specific text. We’ll test this out using a series of questions people posed to Google.

Excel Flash Fill Learns By Example

Excel flash fill examples and patterns.

Learn how to easily manipulate cell entries with Excel Flash Fill. The feature doesn’t rely on formulas or coding. You simply have to find a pattern and Excel’s machine learning does the rest.

How to Transcribe Audio Files with Word

Transcribe pane and editor with callout options.

Have you ever listened to a podcast, webinar, or class lecture and wished you had a written transcript? Microsoft released a new feature for Word for the web that simplifies transcription for English speakers. It’s a great start, but like all audio transcription tools, you still need to do editing.

Quick Guide to Microsoft Excel Solver

Solver results on top of original results.

Some time back, I wrote a tutorial about a useful function in Microsoft Excel called Goal Seek. It quickly allows you to solve easy “what-if” scenarios. Although helpful, it has limitations. Fortunately, Microsoft has a more powerful add-in analysis tool that overcomes these issues. You can even add a constraint to your solution. In this tutorial, I’ll show you how to use Solver in Excel.

How to Add HTML Signature to Outlook

2 column HTML signature displayed in web browser.

Email signatures can be a great marketing tool. However, I often run into people and business owners who struggle with trying to get their HTML versions into Microsoft Outlook. The process to add the code to emails is a bit different. Included are two ways you can add them.

Practical Gift Ideas For Anytime

hands delivering gift box

Are you looking for gift ideas? If so, I’ve assembled some items by price category that I’ve bought and used. I’ve tried to keep the ideas practical and have intentionally omitted things like gift certificates or other soft goods.

How to Manage Cookies in Chrome

Listing of all cookies sorted by domain.

I’m a creature of habit and each Wednesday I go to my local supermarket’s website to see the specials. Certain of these specials are unique to me so I need to log in to see them. This week I couldn’t log in. Each time I got a message saying my session expired and to log in again. I had a pretty good idea that the problem was with some site cookie. The good news is there are multiple ways to clear cookies for one site with Google Chrome.

Customize Excel Ribbon for Your Needs

Excel Ribbon Display Options

One issue I run into with this site is software updates. I’ll be updating an article and low and behold, something is missing or changed. Usually, this is a result of software changes. The area that is impacted the most is the Excel Ribbon. In two articles, I noticed I was missing the Forms button and in the other case, the Excel Developer tab. Both issues are easily fixed when you know how to customize the ribbon.

When Alexa Voice Recognition Gets it Wrong

Alexa account history menu

Image my surprise this morning when I looked at my To Do list and saw, “do a review on grimm kermit call marilee”. I stared at the screen for a good 20 seconds hoping something would pop to mind. I was stumped. Fortunately, I could tell the task had been placed the day before by Alexa. Now, the question was how to figure out what Alexa voice recognition heard. It was time to go to the source.

How to Use VLOOKUP in Google Sheets

VLOOKUP Function

VLOOKUP is one of the most popular spreadsheet functions with spreadsheet fans. It allows you to lookup needed values and use them elsewhere in your spreadsheet. This tutorial will show you step-by-step on how to use the function. Includes downloadable file.