How Do I Sum Colored Cells in Excel

Excel subtotal formula.

Are you a Microsoft Excel user who loves adding a background cell color? The benefit of colored cells is that it makes important information stand out. Another helpful feature is that it’s easy to act on the colors. In this tutorial, I’ll show you how to sum colored cells in Excel. You won’t need to write any VBA code or use the get.cell function.


Excel Formulas to Check If Cell Contains Specific Text

Have you ever struggled to find specific text within an Excel cell? For example, the cell contains multiple words, but you’re looking for one word. In this tutorial, I’ll show several methods including SEARCH and MATCH. Learn these techniques and transform your formulas since the Excel CONTAINS function doesn’t exist at the moment.


Excel Hack: How to Convert Month to Number in No Time

Excel month arguments dialog and result.

Need to convert month names to numbers in Excel? Recently, I compiled a list of dates from a friend’s website and faced this challenge. In this quick tutorial, I’ll guide you on how to change the text string to numerical data using Excel’s MONTH function. For instance, we’ll transform March into 3.


How to Keep Leading Zeros in Excel (Solutions & Sample Files)

Example of dropped zero in zip code

Are you struggling with disappearing leading zeros in Excel? We’ve got some solutions that will keep those zeros right where they belong. Imagine the ease and accuracy you’ll experience when your zip codes or other data retain their correct formatting. In this tutorial, I’ll show you how to keep leading zeros in Excel.


XLOOKUP Tutorial: Improve Your Excel Workflow in No Time

Discover the game-changer in Excel: the XLOOKUP function. Offering simplicity and flexibility, it outshines VLOOKUP and HLOOKUP. In this tutorial, I’ll guide you through using XLOOKUP. First, practice with an example spreadsheet and transform your spreadsheet skills. Then, we’ll dive in and unlock the power of this fantastic function.


How to Split Names in Excel for Cleaner Data

Excel formula to parse name

Learn how to separate names in Excel to boost productivity and improve data organization. This article teaches you various techniques, including using the Text to Columns tool, formulas like LEFT, RIGHT, and MID, and the powerful Flash Fill function. Apply these methods to streamline your workflow and make your data more manageable.

Easy Excel Random Number Generator

Randbetween function.

Recently, I got a request from our city manager asking if I could randomly select 150 people from a list of names. I think the purpose was to do a survey, but maybe it was to select contest winners. I didn’t ask. In this tutorial, I’ll show you how to generate random numbers in Excel. Includes an extra function if you’re a Microsoft 365 subscriber.


How to Count Characters in Excel

Function Arguments dialog with cell C2 in Text field.

A reader posed an interesting conversion problem between an old database and a new online one. She wanted to use an Excel file to move the data from one system to another. However, the new system would not accept field values longer than a certain number of characters. In this tutorial, I’ll show how to check the character count in Excel using the LEN function.


Excel VLOOKUP Made Easy – Learn Basics with Practice File & Video

VLOOKUP example with lookup table

Have you ever found yourself lost in a sea of data spread across multiple columns and worksheets in Excel? Worse, you need a way to connect items. In this Microsoft Excel VLOOKUP tutorial, you’ll learn how to use VLOOKUP using two examples with different match types. (Includes free downloadable Excel VLOOKUP practice sheets and video tutorial.)


Discover Easy Excel Formulas to Extract Text from Cells

Street address column values copied into new columns.

Microsoft Excel is a great tool, but sometimes the source files we get aren’t ideal. One example is a file with a data column, maybe a street address, that you’d like to break into smaller parts. In this tutorial, I’ll show how to extract text from a cell in Excel using powerful but straightforward text functions. (Includes practice workbook.)