Lesson#99: Formula to separate words from a full name
OK. I am back again with some crazy formula. Here in this post, I will show …
Lesson#99: Formula to separate words from a full name Read more →
Excel Tricks
Lesson#96: How to HLOOKUP chart from a drop-down menu in Excel
So here is another important lesson for you. How to HLOOKUP chart from a drop-down menu …
Lesson#96: How to HLOOKUP chart from a drop-down menu in Excel Read more →
Lesson#95: How to VLOOKUP chart from a drop-down menu in Excel
So that’s an important lesson for you my dear. How to VLOOKUP chart from a drop-down …
Lesson#95: How to VLOOKUP chart from a drop-down menu in Excel Read more →
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 …
Lesson#90: How to highlight a particular number in an array automatically 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 …
Lesson#87: How to make month wise auto-updating program schedule Read more →
Lesson#82: Type in multiple sheets at one time in Excel
There is a nice feature in Excel by which we can type in multiple sheets at …
Lesson#82: Type in multiple sheets at one time in Excel Read more →
Lesson#81: Making an automatic analog clock in excel with a pie chart
Previously I had discussed how to make an analog clock with piechart in excel. I am …
Lesson#81: Making an automatic analog clock in excel with a pie chart Read more →
Lesson#80: Make an automatically refreshing bar clock in Excel
We will learn how to make an automatically refreshing bar clock in excel. 1. First I …
Lesson#80: Make an automatically refreshing bar clock in Excel Read more →
Lesson#79: Automatic changing Excel sheet color every second
Let me show you how to make a spreadsheet that changes its color every second automatically. …
Lesson#79: Automatic changing Excel sheet color every second Read more →
Lesson#78: Change the color of the whole sheet every minute in Excel
Now I will show how to make a spreadsheet that changes its color every minute automatically. …
Lesson#78: Change the color of the whole sheet every minute in Excel Read more →