If you use Microsoft Excel, you'll recognize that it is a powerful application, capable of acting as a full-featured spreadsheet and data analysis tool. While Excel is fully capable of some powerful ...

Spreadsheet apps like Microsoft Excel and Google Sheets aren't just for tabulating data — they're also designed to make that data and its accompanying labels neat and orderly. While the alphanumeric ...

There are two situations in which you might need to merge two columns of data in Excel 2013. If you've imported two columns of data from separate sources, you might want to combine them into a single ...

You can merge cells in Microsoft Excel as a quick and easy way to create titles, or to spread data neatly across columns and rows. There are several different types of merges you can perform in Excel, ...

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...

For many small business owners, Microsoft Excel is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare documents for distribution to partners or ...

Have you ever found yourself staring at a massive Excel spreadsheet, wondering how to pull the right information from multiple columns without losing your mind? If so, you’re not alone. Whether you’re ...

Part Two of this three-part article covers how to import your Outlook contact list—the CSV file—into Excel, then how to refine, maintain, and manage that database so, in Part Three, you can merge it ...

Columns organize data in Excel, and are often used as categories with headers to sort cells. You can simply right-click on an existing column to add another column immediately before it. To add ...

Do you want to send a single document to multiple people without having to send it many times to each person? Well, in Microsoft Office, there is a feature called Mail Merge. The Mail Merge feature ...

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...