How to Change Uppercase to Lowercase in Excel
Often when working with text data such as names or address, you will get the data in uppercase, and you may need to convert it into lowercase or propercase. With …
Formulas
How to Extract Number from Text in Excel (Beginning, End, or Middle)
Extracting numbers from a list of cells with mixed text is a common data cleaning task. Unfortunately, there is no direct menu or function created in Excel to help us …
Convert Bytes to MB or GB in Excel
If you are working with data related to storage space or file-size, you will often need to convert between units. You might intend on using the data in calculations or …
How to Replace Asterisks in Excel
Working with data often involves cleaning up. If your data is imported or copied from an external source, it may contain a number of unwanted characters like commas or asterisks …
How to Convert Month Number to Month Name in Excel
When working with date-related data, there might be instances where you need to convert a number to its corresponding month. There might also be instances when you might want to …
Highlight Cell If Value Exists in Another Column in Excel
One of the best things about Microsoft Excel is that it can be customized to suit your needs and preferences. Excel has Conditional Formatting that allows you to format a …
How to Find Range in Excel (Formulas)
We usually require certain metrics to understand the data that we are working with. There are a number of such representative metrics, like the average, the median, etc. Among these …
How to Square a Number in Excel?
Thanks to spreadsheet software like Excel, it has become easier than ever to find squares of thousands of numbers at a time, even if some of them are quite large. …
How to Use ‘e’ in Excel? (Euler’s Number)
If you’re an Excel user, you’re probably familiar with basic functions like SUM, AVERAGE, and COUNT. But did you know that Excel has a built-in function to calculate Euler’s number? …
How to Calculate Antilog in Excel (Formula)
Logarithmic functions are often used when dealing with exponential values in your data. So when you have a log function, you might probably need to find the antilog at some …
10 Best Excel Books (that will make you an Excel Pro)
When we talk about learning Excel, we almost always think of videos and written tutorials. While these are great ways to learn Excel, books can do a much better job …
How to Compare Two Columns in Excel (using VLOOKUP & IF)
When you’re working with data in Excel, sooner or later you will have to compare data. This could be comparing two columns or even data in different sheets/workbooks. In this …