Professor Excel
choose, formula, excel

CHOOSE Formula in Excel: Everything You Should Know

The CHOOSE formula in Excel is one of those, which is quite unknown. It can be very helpful though: For example it can easily convert the weekday-number into the weekday name. Often, it is used within other formulas. In this article you learn everything you need to know about the formula.

[…]

Combine Text in Excel

Combine Text in Excel: 4 Best Ways (+Download)

Excel offers three distinct formulas as well as a fourth way to combine multiple text cells into one cell. There are countless examples in which you might need this: Combine given– and family names or preparing primary keys for multi-conditional lookups. For example, in a VLOOKUP or INDEX/MATCH formula combination. In this article you learn 4 methods and in the end, you learn how to deal with a large range of cells.

[…]

find, search, find(), search(), findb, searchb, formula, formulas

FIND & SEARCH in Excel: How and When to Use These Formulas

The two formulas FIND and SEARCH in Excel are very similar. They search through a cell or some text for a keyword or character. Once found, they return the number of characters, at which the keyword starts. Let’s learn how to use them and explore the differences of the two formulas.

[…]

substitute, formula, excel

How to Replace Text with the SUBSTITUTE Formula in Excel

Sometimes, you need to change text in a systematic way: If you want to replace some text with new text, there are two options. If you only want to do it once, using the Find-and-Replace dialogue is probably the fastest choice. If you want to do it repeatedly or don’t want to mess with your input data, you should try the SUBSTITUTE formula.

lookup, formula, excel

LOOKUP Formula in Excel: Everything You Should Know

Besides the well-known VLOOKUP formula, there is a similar formula in Excel: LOOKUP. The formula is very unkown and hardly used. But there are good reasons why you should not use the formula. Let’s start with the basics about the formula and then talk about why you should avoid it.

[…]

formulas, dictionary, excel, language, languages

Dictionary for Excel Formulas

Microsoft Excel supports many languages. In total, you can use Excel in 107 different languages. Many of these languages also use local formula names. For example, VLOOKUP is called SVERWEIS in German, BUSCARV in Spanish or DÜŞEYARA in Turkish. Fortunately, you don’t need to remember different formula names because Excel automatically translates the formulas to your language. However, in some cases you need to know the local formula term. Please refer to our comprehensive dictionary below.

[…]

len, formula, length, excel

LEN Formula: Get the Number of Characters in Excel

You need to know how many characters does the cell contain?

subtotal, excel, guide, tutorial

SUBTOTAL in Excel: Everything You Should Know

SUBTOTAL is one of those formulas in Excel, which is very powerful but not well known. The reason is, that you can achieve all its operations by other formulas as well. But in many cases, SUBTOTAL would be the better choice. Read here how to use it and why SUBTOTAL is very useful.

[…]

weekday, day, name, monday, sunday

Weekday Name in Excel: Paste This Easy Formula into Excel Cell

You want to know the weekday of a certain date? Excel provides the WEEKDAY formula. The WEEKDAY formula returns the day of the week as a number, for example 1 for Sunday, 2 for Monday and so on. You can modify, which weekday starts with one.

3d, 3 way, lookups, 3d lookups, excel

3D Lookups in Excel: 6 Methods (+Download)

The king of lookups in Excel: The 3 way- or 3D lookup. Imagine this scenario: You got several Excel tables, each has rows and columns. Depending on your input values, you want to get the data from a specific cell from the right table, row and column. Such lookups are called 3D lookups or 3 way lookups. In this article we explore 6 methods of how to conduct 3D lookups in Excel.

[…]