Excel functions

If you haven’t yet, you’ll soon come across a situation through your journey with excel, where you’ll want to manipulate text by changing the case, I mean capitalization. In this …

What is MATCH function in Excel? The MATCH function is used to search for a value in a range in order to retrieve the position of a cell that matches …

If you are reading this, I guess you already know how the VLOOKUP function works. This function is so sensitive that it can detect even trailing and leading spaces in …

What is a double lookup in Excel? Two-way lookup or double lookup is simply a formula that looks in both vertical and horizontal directions simultaneously, in order to find a …

VLOOKUP is one of the popular functions in Excel. It is very helpful to many Excel users who want to look and retrieve information from a table (or dataset). As …

The built-in Excel data entry form is ideal for data entry tasks. It shines when you need to enter data that has been arranged in rows. It is a time …

In this step by step tutorials, you’ll learn how to use the INDEX function in Excel, with a clear syntax breakdown and examples demystified. What is INDEX function in Excel? …

Want to know why your Excel VLOOKUP is not working? You are in the right place. This tutorial will help you learn why you are getting VLOOKUP errors in Excel …

Want an Excel template that allows you to convert normal dates into Roman numerals dates? Look no further. Whether you want to know the roman numeral version of your birthday …

Excel drop-down list is a feature in Microsoft Excel, similar to a list box, that allows the user to choose one value from a list of values. It lets you create some …