AMORDEGRC Function of Excel – Linear Depreciation of an Asset
In an accounting system, we might be willing to calculate the depreciation for the each of accounting periods. In this tutorial, we would learn to… Read Article
ACCRINTM Function of Excel – Calculating Accrued Interest
Have you ever heard about the term “Zero-Coupon Bonds”?. Well, a zero-coupon bond does not provide you the interest money in payments, instead returns the… Read Article
WEEKNUM Function of Excel – Finding Week Number
When we are working with dates in Excel, we might wish to know in which week of the year, this date falls. For example, what… Read Article
TIME Function in Excel – Returning The Time Format
The TIME Function in excel makes sure of the particular required format. Whenever we are working with time in excel, we might be willing to… Read Article
ISREF Function in Excel – Checking for Cell Reference
A cell reference refers to the specific address of each cell in the spreadsheet. The column number is represented by alphabets from A to XFD… Read Article
ISNUMBER Function of Excel – Checking If Cell Contains a Number
Many times, while working with numeric data in excel, we might feel a need to check if the cell contains a number or not. Manually… Read Article
ISNONTEXT Function of Excel – Check Non Text Cell in Excel
Many times, while working with data in Excel, you may as well feel a need to find the cell which is not in a text… Read Article
ISBLANK Function of Excel – Check if Cell is Blank
Many times, while analyzing the data in excel, we might be willing to work with the blank cells in the data. Out of the whole… Read Article
What is Date and Time Format in Excel?
I am sure that every excel user like you 😉 frequently work with dates and times in excel. Some may follow the excel date format… Read Article
ISTEXT Function in Excel – Checking if Cell Contains Text
Whenever we are working with data in Excel, we have to work with the cells set to text format. The text strings, numbers, date, time,… Read Article
ISNA Function in Excel – Checking for #N/A Errors
Many times, while searching for a value in the spreadsheet we have to deal with #N/A errors. Every time the function like VLOOKUP, HLOOKUP, MATCH,… Read Article
ISERROR Function in Excel – Checking for Errors
While working with the formulas in Excel, we may come across various kinds of excel formula errors. Therefore, we need to cope with these unwelcomed… Read Article