Tag: MOD

Short Tips#0003: Finding exact middle character(s) of text

Tagged with: , , ,

Lesson#79: Automatic changing Excel sheet color in every second

Let me show you how to make a spreadsheet which changes its color in 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

Tagged with: , , ,

Lesson#78: Change the color of whole sheet in every minute in Excel

Now I will show how to make a spreadsheet which changes its color in every minute automatically. to make this you have to follow some steps. 1. Click the upper left corner of sheet to select all of the spreadsheet.

Tagged with: , , ,

Lesson#61: Making a semi analog clock with pie chart

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 3X3 table for hour, minute, second of current time.  

Tagged with: , , , , , ,

Lesson#22: How to find the exact middle character(s) of text using LEN

LEN is a function which is used for finding out number of characters in a text string. It’s syntax is LEN(text). THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG┬áhas 43 characters including <space> between words. Now I will show

Tagged with: , , ,

Lesson#19: How to convert digit into word in excel

In this lesson we will learn a method to convert digit into word. I will use functions like CONCATENATE, VLOOKUP, SUM, IF, MOD, which were discussed in my previous posts. 1st Step I have made a list of relevant word phrase

Tagged with: , , , ,

Lesson#18: What is MOD function?

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 MOD function to show

Tagged with:
Top