A systematic Withdrawal Plan (SWP) is a popular investment strategy for retirees who want to receive a steady income from their investment portfolio. In this article, we will learn how to make an SWP calculator in Microsoft Excel to help …
Lesson#203: How to make an SWP calculator in Excel? Read more →
Hello friends! How are you? Just working on a simple thing. I was making some easy formulas to get color code in Excel. Just like if you color a cell then this formula will break the R, G, and B …
Let me show you how to make a spreadsheet that changes its color every second automatically. to make this you have to follow some steps where I will apply a little VBA to make it really automatic. 1. Click the …
Lesson#79: Automatic changing Excel sheet color every second Read more →
Now I will show how to make a spreadsheet that changes its color every minute automatically. to make this you have to follow some steps. 1. Click the upper left corner of the sheet to select all of the spreadsheets. …
Lesson#78: Change the color of the whole sheet every minute in Excel Read more →
OK friends! How is everyone? Now in this post, we will learn an unusual trick to make a semi-analog clock with Pie Chart. Let’s see. First I have made a 3X3 table for the hour, minute, and second of the …
Lesson#61: Making a semi analog clock with pie chart Read more →
LEN is a function that is used for finding out the number of characters in a text string. Its syntax is LEN(text). THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG has 43 characters including <space> between words. Now I will …
Lesson#22: How to find the exact middle character(s) of text using LEN Read more →
In this lesson, we will learn a method to convert digits into words. I will use functions like CONCATENATE, VLOOKUP, SUM, IF, and MOD, which were discussed in my previous posts. 1st Step I have made a list of relevant …
Lesson#19: How to convert digit into word in excel Read more →
MOD function returns the remainder after dividing a number with a divisor. Syntax of the function is =MOD(number, divisor). Let me show you an example. I have typed a random number 123456789 then I will add the MOD function to …
