Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating Gantt chart without using an excel chart It was a day-wise scheduling format. Here I will show how to make a month-wise scheduling format. First I …
Lesson#87: How to make month wise auto-updating program schedule Read more »
So I show you here how the logic gates can be configured in Excel. AND gate Q = A AND B So here the formula for getting AND result will be =IF(AND(J20=1,K20=1),1,0) NAND gate Q = A NAND B So here the formula for …
Hello my reader friend how are you? Hope fine. Today I will discuss a small but important topic in Excel. It is adding or subtracting to Date and Time. Almost all of us know how to add to date value …
Lesson#85: Adding or subtracting to Time is not same as Date in excel Read more »
Here I will discuss a very useful feature Text to Columns. We can use this feature to split the data into cells throughout the column and split it into many columns very easily. In the above picture, we can see …
Lesson#84: Separate text in different columns easily Read more »
I always hear a common question from beginner Excel users “How to make a drop-down menu in Excel?”. I would like to ask them have used the feature Data Validation. Select all the cells on which you want to create …
Lesson#83: How to add a drop-down in an excel sheet Read more »
There is a nice feature in Excel by which we can type in multiple sheets at one time. Step 1: For that, you have to just press Ctrl and select all those sheets where you want to type. Step 2: …
Lesson#82: Type in multiple sheets at one time in Excel Read more »
Previously I had discussed how to make an analog clock with piechart in excel. I am sharing the post link below. Lesson#61: Making a semi-analog clock with a pie chart Now I will add some simple VBA to make the …
Lesson#81: Making an automatic analog clock in excel with a pie chart Read more »
We will learn how to make an automatically refreshing bar clock in excel. 1. First I made three merged cells by putting these formulas =HOUR(NOW()) =MINUTE(NOW()) =SECOND(NOW()) 2. Select those cells one by one and click on Conditional Formatting>Data …
Lesson#80: Make an automatically refreshing bar clock in Excel Read more »
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 »