Tutorials
How to Reset Comment Positions in Excel Using VBA
Microsoft Excel is a powerful tool for data analysis and visualization. A useful feature is the ability to add comments to cells to provide additional information or context. However, sometimes...
How to Combine First and Last Name in Excel
If you have first names in one column and last names in another column, you can easily combine the two names in a third column, using Microsoft Excel. In this tutorial, we will show you the steps to...
How to Calculate the Interquartile Range using Excel (Quick and Easy)
You can use Microsoft Excel to determine the interquartile range (IQR) by following these steps: Step 1: Organize Your Data Before you calculate the IQR, ensure that your data is organized in a...
How to Create a Percentage Calculator in Excel
Introduction Excel is a powerful tool for performing a wide range of calculations, and one common task is calculating percentages. Whether you're working on financial spreadsheets, data analysis, or...
How to use the IFERROR function in Microsoft Excel
In a Nutshell The IFERROR function is a powerful tool that can be used to trap and handle errors in Excel formulas. It can be used to replace error values with text, numbers, or other formulas....
What is Financial Modelling?
Financial modelling is an essential tool for businesses, investors and financial analysts. It is a process of creating a mathematical representation of a financial situation or system using various...
How to use the TEXTJOIN function in Microsoft Excel
In a Nutshell The TEXTJOIN function combines the text from multiple ranges and/or strings in one cell. It provides the option to add delimiting characters (ike dashes or spaces) between all the...
How to use the MIN function in Microsoft Excel
In a Nutshell The MIN function is used to find the lowest value in a range of values. Syntax =MIN(number1, [number2], …) The arguments (number1 , number2, …) are up to 255 numbers for which you want...
How to use the CONCAT function in Microsoft Excel
In a Nutshell The CONCAT function combines the text from multiple ranges and/or strings. Syntax =CONCAT(text1, [text2], …) The arguments (text1, text2, …) are up to 253 items to be joined. Each...
How to use the MAX function in Microsoft Excel
In a Nutshell The MAX function is used to find the greatest value in a range of values. Syntax =MAX(number1, [number2], …) The arguments (number1 , number2, …) are up to 255 numbers for which you...