When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for ...

Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula.

How to find missing records using VLOOKUP() in Microsoft Excel Your email has been sent In Microsoft Excel, I have used many different solutions to compare lists. Sometimes the solution finds ...

How to use wildcards with the XLOOKUP() function in Excel Your email has been sent Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible. Lookup functions are great ...

As you use Microsoft Excel more and more, you'll find that the VLOOKUP function is a very popular tool for dealing with large Excel directories or databases. It allows the user to quickly find ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

This post explains how to use the new Excel TEXTSPLIT function. TEXTSPLIT() is a Text function in Excel. The purpose of this function is to split a given text string on the basis of one or more ...