So here is another important lesson for you. How to HLOOKUP chart from a drop-down menu in Excel? Here I am having a table. Table contents skill set data of six players. Here I will show you how to HLOOKUP …
Lesson#96: How to HLOOKUP chart from a drop-down menu in Excel Read more »
So that’s an important lesson for you my dear. How to VLOOKUP chart from a drop-down menu in Excel? Here I am having a table. Table contents skill set data of six players. Here I will show you how to …
Lesson#95: How to VLOOKUP chart from a drop-down menu in Excel Read more »
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 »
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 »
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 »
Hello friend. In this post, I will show how to get a new fresh formatted sheet every time when you click the button in the excel sheet. That thing is exactly needed for making invoices in a store, shop, or …
Lesson#75: Get a new fresh formatted sheet every time when you click the button Read more »