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.
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.
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.
Ever faced frustration with Excel formula errors? Understanding and fixing these errors doesn’t have to be a daunting task. This guide simplifies the process, showing common errors and how to correct them using Excel’s Formula Auditing tools. Sometimes, the solution is as straightforward as adding punctuation.
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.
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.
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.
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.
Have you ever wondered about word count in Excel? It’s a handy tool that can make your data analysis easier. Imagine the possibilities with this new skill. In this tutorial, I’ll show you how to find Word count in Excel using various formulas. Includes samples and a practice file.
Are complex Excel scenarios bogging you down? What if there was an easy way to handle them? Our beginner’s guide to the IF function in Excel can help speed up the process. This step-by-step guide is all you need to turn data confusion into logical solutions. (Includes practice worksheet.)
Ever had some of your Microsoft Excel spreadsheets show a #DIV/0 error in various cells? It brings back memories of math class for some. In this tutorial, I’ll explain what causes them and how to remove #div/0 errors in Excel from showing that dreaded text. We’ll solve this problem by adding a simple IF function argument.
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.
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.)
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.)
Ever wished you could effortlessly switch rows and columns in Excel? Now, imagine the convenience of tailoring your spreadsheet’s layout to perfectly suit your data analysis needs. In this tutorial, I’ll show how to convert columns to rows using the Transpose feature. (Includes practice file.)