Generate Random Numbers using RANDBETWEEN function
Formula Syntax =RANDBETWEEN(Bottom, Top) Bottom represents the lower value of the range, and Top represents the upper value of the range...
Conditionally Format Dates based on Different Criteria (>30, >60, >90...etc.)
For example, we have set of due dates and we would like to highlight dates more which are older than 30 days, 60 days, or 90 days. Follow...
Insert a Checkbox in Excel
Inserting a checkbox in Excel is very easy. The checkbox control is available in the Excel developer tools option. Checkbox can be very...
Hyperlinks in Excel
To create a hyperlinks in Excel, follow below steps: 1. From the Insert tab, click Hyperlink or right click and select Hyperlink 2. From...
Display the relationships between formulas and cells
Sometimes, checking formulas for accuracy or finding the source of an error can be difficult when the formula uses precedent or dependent...
Highlight Dates older than 6 Months
If you want to highlight dates older than 6 months, you can use any of the two formulas to do that =DATEDIF(A2,TODAY(),"m")>=6...
How to Add the Developer Tab to the Ribbon in Excel
The developer tab in Microsoft Word provides users with the option to write and run macros, use ActiveX controls and XML commands, create...
Financial Functions in Excel
Let’s consider a loan with monthly payments, an annual interest rate of 6%, 10-year duration, a present value of $250,000 (amount...
Sum/Count by Cell Colour in Microsoft Excel (VBA)
Last week one of my friends asked me whether it is possible to add cells based on their cell colour or not. As we know, Excel does not...
Use Data Bars to Highlight Data Quickly
Data bars in Excel are very useful to visualize values in a range of cells. A longer bar represents a higher value. To add data bars,...
