How to Transpose Excel Columns to Rows

Transposed table in Excel

Everyone looks at data differently. Some people create Excel spreadsheets where the main fields go across horizontally in a row. Others put the data vertically. Sometimes these preferences lead to a scenario where you want to transpose Excel data. Transpose is an Excel function that allows you to convert Excel columns to rows without retyping the data. (Includes sample worksheet)

Easy Formulas to Extract Text from Excel Cell

Street address column values copied into new columns.

Excel is a great tool, but sometimes the spreadsheet files we get to work with aren’t ideal. One example is a file with a data column, maybe a street address, that you’d really like to pull parts. In this tutorial, I’ll show how to extract text from a cell in Excel using some useful text functions. (Includes practice workbook.)

How to Use VLOOKUP in Excel

VLOOKUP example with lookup table

One of the popular Excel tutorial requests is how do you look up a value on one Excel worksheet and use it on another Excel worksheet? For example, you need to translate a product number into a product name. One of my favorite functions is the VLOOKUP function and it can help with this task. (Includes example spreadsheet and video.)

How to Separate Names in Excel

Excel formula to parse name

Recently, a friend asked about fixing an Excel worksheet where subscriber names were in one column. He wanted to separate first and last names in Excel so he could send personalized greetings. In this tutorial, I’ll first show how to use the Convert Text to Columns Wizard. Then we’ll use some Excel formulas and Excel Flash Fill feature to handle exceptions.

Speed Up Data Entry with Excel Data Forms

Example of Excel Data Form.

I hate inputting data. It’s mind-numbing and given a chance, I’ll make mistakes. One way to speed up Excel data entry is to use an Excel form. These data entry forms are especially beneficial when your records span across many columns. In this tutorial, I’ll show you how to create a data entry form in Excel.

See How to Get Fast Answers With Excel Goal Seek

Excel Goal Seek dialog box

Have you ever stared at your spreadsheet and wondered how to find the answer to a “what-if” scenario? Let’s start with the goal in mind. In this tutorial, you’ll learn how to use Goal Seek in Excel to answer these and other analysis questions. (Includes video and example spreadsheet.)

Use Excel Conditional Formatting to Highlight Cells

Excel spreadsheet with data bars

Have you ever stared at a spreadsheet looking for the important stuff?  The problem with many spreadsheets is all the cells look the same. So you have to hunt for key information. In this tutorial, I’ll show how to highlight cells in Excel using built-in conditional formatting criteria. (Includes practice file.)

How to Find Invalid Email Addresses in Excel

Email addresses that didn't validate

This week was one where multiple requests converged. I had two friends that needed to send emails to their customers. One had their information in an Excel spreadsheet and the other exported their internal databases to Excel. Both thought there were problems with many email addresses and wanted to know if there was an easy way to find invalid email addresses before sending out the emails.