Latest Posts From Hosne Ara
In Excel, most of the time we do calculations using formulas. However, when we copy data from one location to another, formulas are copied as well. Besides, ...
Hosne Ara
In this tutorial, I will show you how to convert an exponential value to an exact number in Excel. Usually, when you enter a number that is longer than 11 ...
In this tutorial, I will discuss how to concatenate cell contents that are spread over several rows in Excel. Basically, concatenate means merge/combine/join ...
In this tutorial, I will show you how to calculate the percentage of time in Excel using the basic percent formula. Besides, I will show some examples of using ...
In this tutorial, I will show you how to add a percentage to a product’s price using an Excel formula. Luckily, adding percentages to a price is very easy. ...
In this tutorial, I will show you how to calculate the amount of gold loan interest in Excel. Before applying for a loan, you can calculate periodic loan ...
In this tutorial, I will show some methods for calculating the average of multiple columns in Excel. Usually, you can get an average of a range of having ...
In this article, I will show how to convert single columns to rows using excel formulas. Basically, when we copy data from any word editor to excel, those data ...
In this tutorial, I will discuss how to freeze 2 columns in Excel. While scrolling in Excel worksheets, you might want specific columns to be visible all the ...
In this article, I will discuss the random number generator between a range in Excel. Often, while doing statistical and financial analysis, you might have to ...
In this article, I will show you how to link an MS Word document to Excel worksheets. Often, while working in Excel, you may need to link information from a ...
In this tutorial, I will discuss several ways to find a partial match in text using Excel VLOOKUP approximate match. We all know that the VLOOKUP function ...
In this tutorial, I will show some methods to sort a drop-down list in Excel. Often, when we work with lots of data or repetitive data, if we can sort them ...
In this tutorial, I will explain how to edit a hyperlink in excel. Usually, we use hyperlinks often to serve different purposes such as: to go to a specific ...
In this tutorial, I will describe some easy and quick ways to remove comments from Excel sheets. Comments are useful while drafting Excel files. However, ...
