Home Blog Page 3

How to use COLUMN Function in Microsoft Excel

In Microsoft Excel, COLUMN function returns the column number of the specified reference or first column of supplied reference. In case when no reference...

Average Function in Microsoft Excel

In Microsoft Excel Average function is used to calculate the average value for available numbers by supplying the range in formula. Also, it is...

Randbetween Function in Microsoft Excel

Use RANDBETWEEN function to create random number between two numbers (bottom and top). Whenever we work on worksheet it calculates for new number every time....

Excel Errors and How to Fix Them

When Excel detect any error in formula then it gives a message by presenting different type of error. Every excel errors contain the reason...

Error Handling Functions in Microsoft Excel

In Microsoft Excel we have different reasons to occur different errors while performing the calculation. Error messages are bad especially when it appears in...

350+ Excel Keyboard Shortcuts – Windows

Many of us like to work rapidity while working on computers, and moreover, if we are working in data field then obviously this is...

How to Create Automated Sales Invoice Template

Sales Invoice is a commercial document which we required to sale and purchase. This invoice issued by a seller to a buyer as billing...
video

How to Create a Loan Amortization Template in Excel

A Loan Amortization Schedule which is also known as mortgage or loan schedule, is a list of payments that shows each loan repayment and a...

45 Quick Time Saving Excel Keyboard Shortcuts You Must Know

There are hundreds of keyboard shortcut in Microsoft Excel which are important and can save lots of time however, few of them are very...

How to use LEN Function in Microsoft Excel

The Excel LEN function is an in-built function hence frequently used in day to day life. The function is really simple and easy to...