Short Tips#0005: Toggle case of text
Lesson#90: How to highlight a particular number in an array automatically
So here I will show you a simple but very useful trick with Conditional Formatting. This is about how to highlight a particular number in an array automatically. So in the above picture, I have a number array where I …
Lesson#90: How to highlight a particular number in an array automatically Read more »
Lesson#89: Example of a bar chart with life expectancy data
Hello reader. This post is a discussion about an example of a bar chart making with life expectancy data of all countries. Here I am having data in 4 columns. Country, Both sexes life expectancy, Female life expectancy, Male life expectancy. I …
Lesson#89: Example of a bar chart with life expectancy data Read more »
Lesson#88: How to make a Salary slip format from Employee Database
So, my friend, I will here discuss an important lesson which is really required for office people. That is how to make a salary slip from an employee database. This is not about salary slips only, we can make many …
Lesson#88: How to make a Salary slip format from Employee Database Read more »
Lesson#87: How to make month wise auto-updating program schedule
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 »
Lesson#86: Logic Gates in Excel
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 …