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 »
Hi! Continuing with the chart topic. In the previous post I showed you to use a radar chart and what type of data you can apply. Now I will show that you can add many chart data in the same …
Lesson#94: You can add many chart data in same area Read more »
Hi! I am back with one more interesting post. Here I will show you a chart example. Yes, my friend charts are very very important things to know in Excel. Rather than wasting time let’s discuss a Radar Chart example …
Lesson#93: Radar chart example with Cristiano Ronaldo Read more »
Hello Friend! I am back again with my other post. This post is about Conditional Formatting. Here I will show how to highlight a column value depending on the column values next to it. In the above picture, I am …
Lesson#92: How to highlight a column value depending upon the other column values 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 »
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 »
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 »
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 »